### Group Tree (using SQL GroupBy command)

If your reports contain server-side processing of SQL GroupBy statements, the Smart Navigation Group Tree will be affected when the reports are displayed. In these cases, only summary information is returned to the client. Detail records are evaluated by the SQL server and grouping and summary values are calculated and then sent to the client without the detail records.

Although this method greatly reduces the amount of data sent across the network, it also affects the Group Tree. Group names are listed in the Group Tree as they normally would be. However, if you expand a group in the Group Tree, the detail information will not be available. The server sends only the group summaries to the client. A magnifying glass will appear beneath the group name in the Group Tree indicating that detail data can be retrieved.

If the magnifying glass is clicked, the Web Component Server will retrieve the detail data for that group and display detail groups or record names beneath the original group name. This process requires querying the database. You may not want to use this feature if you think people viewing the report are always going to want to view the details of the summary.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com