The following example describes a typical tabulation scheme, for the scheme, packets on the server significantly reduce unnecessary data transmission of the database server.
Reduce data transfer open exemplary statements Group.rpt (located on the Feature Examples folder) by grouped on the server. Check the lower right corner of the Crystal Reports window, you can notice that 269 records are returned to this report.
Note: This number will only be seen only in the "Status Bar" option in the View menu.
In the Report menu, click "Section Expert" to open "Festival Expert". In the "Section" list, select "Details". In the Public "tab, select" Hide (Deepen Disting) ". This hides the "Details" section of the report to display only group headers in the report. (In this case, the report presses the "Country" group.) Click "OK" in "Section Expert". "Details" record disappears from the report. Press F5 to brush new report data (or click the "Refresh" button in the toolbar). It can be seen that even if the "Detail" record is hidden from the view, 269 records are returned for the report.
In the Database menu, click "Perform Packet on the Server." Now you can see that only 71 records are returned to the report. (Press the Country / Region) group has been completed on the server, so that the records transmitted to the report are less.
Double-click the report to deepen a country. Tip: When deepens, the cursor will become a magnifying glass.
Crystal Reports will retrieve the corresponding "Details" records according to your needs.
For example, if you deepen Australia, Crystal Reports quickly retrieves seven records constituting the group.
By hiding the "Details" record of this report, you have created an easy-to-browse summary report for users. Each user can position him or her attention to the country, and then deepen to retrieve valuable details.
In addition, by enabling the "Packet" option on the server, you have ensured that the initial process is done on the database server. Thereafter, only the necessary records are transmitted for the report.
For more information on server-side processing, see the server-side processing.
