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

enabled, individual aspects of server-side processing will modify the SQL
statement in different ways.
• If you select Use Indexes Or Server For Speed (in the Report Options
dialog box), the program adds an ORDER BY clause to the SQL statement
and a WHERE clause for the record selection formula, if possible.
• If you group on a linkable data type in the DBMS, the program adds a
GROUP BY clause to the SQL statement. The program uses the GROUP
BY clause to perform the grouping on the server.
• If you summarize on a linkable data type, the program adds a summary
field to the SELECT clause of the SQL statement.
• If you drill-down on a linkable data type, the program adds a WHERE
clause to the SQL statement.
• If you group in descending order on a linkable data type, the program
adds an ORDER BY clause to the SQL statement.
The statement also varies between tabs:
• If you are working in the Preview tab, the statement includes the GROUP
BY clause, as well as any aggregates that the report is pushing to the
server.
• If you are drilling-down, the statement varies depending on the underlying
data and the level of drill-down. With each drill-down, the WHERE criteria
changes. Also, if you drill-down to the details, the statement will not include
a GROUP BY clause (since you no longer have any groups on that
drill-down tab).
To view the current SQL statement for the active tab, choose Show SQL
Query from the Database menu. The Show SQL Query dialog box appears,
displaying the SQL statement.
Note:
You can use the Formula Workshop to edit SQL expressions to be processed
on the server.
Enabling server-side processing
1. On the File menu, click Report Options.
2. Select Perform Grouping on Server on the Report Options dialog box.
706 Crystal Reports 2008 SP3 User's Guide
Understanding Databases 25
Server-side processing