Server for speed and formula's 1

[Deano1976]

If I select the 'Use Server for Speed' option does this impact any formulas that I have set up?

For example if I have the formula:

left([Field],3)

will this be performed by the server or not?

 

[DallasAggie]

to my knowledge, no. I use commands or stored procedures to perform all the work .. and let Crystal do as little as possible. .. just my flavor

 

[Madawc]

I think it's critical when you are selecting records for use in your report. It's more efficient to tell the server you don't want it, than to make the selection within the report.

Check the report-generated SQL (under [Database] on the menus) against your actual report selection. Selection rules that don't appear in the SQL are being done by the report, and this should be avoided if possible.

The case you showed is a selection from a field on a record you already have. I've always assumed that this is done efficiently by Crystal - if anyone knows better, please let me know.

Madawc Williams (East Anglia, UK)

 

[lbass]

Take a look at database->show SQL query. Only the work that will be performed on the database will appear in the query. You might also try using a SQL expression and then check if that gets passed. Using the Xtreme database, here's how the SQL expression would look

{fn LEFT(Table.`field`,3)}

-LB

 

[Deano1976]

I'm now little confused as appears that two of these replies are contradicting each other.
If my formula's or select statements appear in the 'show SQL query' in Crystal are they being performed by the server or by the report?

 

[lbass]

The two replies are consistent with each other. Whatever appears in the show SQL query is being performed at the server level.

-LB