HP Intelligent Management Center Standard Software Platform - Manual (Page 705)

amount of processing that must take place on the client side. If the Details
section is shown, server-side processing will not be possible.
• In some cases, formula fields must be processed on the client side. If
grouping is based on a formula field, or if a formula is used in a summary
field, then all the records must be transferred to the client side before the
formula can be evaluated. This will increase the amount of time required
to run the report. Therefore, you may want to use SQL expressions as
an alternative to formulas.
Note:
Formulas used for record selection are an exception and can be pushed
down to the server.
• For a report to be processed on the server, any running totals appearing
in the report must be based on summary fields (since the data needed
for the running totals will be pulled over to the client side).
• For a report to be processed on the server, the report must contain only
summary fields of these types: Sum, Maximum, Minimum, Count.
• The report does not contain specified value grouping.
Note:
• When you drill-down on a hidden section of a report, with the processing
being done on the server, connection to the server will be automatically
initiated. If the client is disconnected from the server (for example, if you
download a report onto your laptop and you work on it from a remote
location), then drilling-down on data will produce an error since the
database is not available.
• If you save a report that has been partially processed on the server using
the Save Data with Report option, the program will save only those records
that have been transferred to the client side. In other words, if you have
drilled-down on a hidden section and there is a tab for that data in Crystal
Reports (indicating the data has been transferred), those records will be
saved with the report.
How server-side grouping affects the SQL query
When a report pushes most of its processing to the server, this by necessity
alters the SQL query. Thus, when the Perform Grouping on Server option is
Crystal Reports 2008 SP3 User's Guide 705
25 Understanding Databases
Server-side processing