User`s guide
23.6.1 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 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.
23.6.1.1 Enabling server-side processing
1.
On the File menu, click Report Options.
2.
Select Perform Grouping on Server on the Report Options dialog box.
This check box is inactive if Use Indexes or Server for Speed is not selected.
3.
Click OK.
2012-03-14546
Understanding Databases