Directory First, perform a record selection in the database server side, only transferred data after the filter. 1. Advantage 2, down the record selected - Example 2, display data on demand, only acquire and display the required data when needed. 1. Advantage 2, hidden (deepening) data, on demand ... 3, use the sub-reports in need to distribute sub-reports ... Third, processing packets and sorting in the database server, the advantage 2, perform most processing on the server and only Push your computer into your computer about details. 4. Use the data saved in the report. 1. Advantage 2, saved data 3, save the data with the report ------------------------------------------------------------------------------------------------------------------------------------------------------- - 1. Perform a record selection in the database server side, only transferred data after the filter. 1. Advantages (1) The connection time with the database server is shorter. (2) There are fewer data from database servers to clients. (3) The transmission time from the database server to the client is shorter. (4) Less memory required to process reports on your computer.
2, down the record selection - Example This example presents the benefits of the record selected formula that can be pushed to the database server.
In the order table of the Xtreme Example Database, there are 2192 records, with 181 items before 2001. Suppose you only want to tabulate these records. On the one hand, the following records can be used: Year ({Order. Order Date}) <2001
The generated SQL query sends all 2192 records to Crystal Reports, and then records the selected formula to 181. To learn this, click "Show SQL Query" on the Database menu, you will notice that the SQL query does not have a WHERE clause. This is because Crystal Reports can't get down the Year () function in the WHERE clause.
On the other hand, the following record selection formula generates the same report: {Order. Order Date} <#jan 1, 1997 #
The second formula above can be executed on the database server, so it can be pushed. The generated SQL query will only send 181 records to Crystal Reports. Therefore, the record is not required to further eliminate the record when the recorded selection formula is evaluated by Crystal Reports. Click "Show SQL Query" on the Database menu, you will notice that there is a WHERE clause in the generated SQL query.
As shown in this example, the processing speed of the report is improved after improved record selected formula. In this example, two formulas generate the same report, but the second formula uses the function and optimization of the database server when processing its data.
Tip: Please see the section of the "Record Selected Performance Tips" section to learn about other information and settings to record the restrictions.
To learn more about writing an efficient record selected formula, read the rest of this section: Use enhanced records to select the formula.
Note: If you are not familiar with the record selected formula, you can start learning from "Select Expert" or record the selected formula sample template. For more details, please refer to Select Record. ---------------------------------- Two, on demand display data, only when you need it, you need it and display The data. 1. Advantages (1) Only the currently needed data is transmitted. (2) The connection time with the database server is shorter. (3) There are fewer data from the database server to the client. (4) The transmission time from the database server to the client is shorter. (5) Handling less memory required by the report on your computer. 2, hidden (deepening) data, display ... Hidden (deepening completed) Binds to groups on the server - Example The following example describes a typical tabulation scheme, for this scheme, packets on the server can significantly reduce database server Unnecessary data transmission.
Open the exemplary report group.rpt (located in the Feature Examples folder). 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.
3. Use the sub-reports on demand ... If the report has a quantity of recorded sections, the section can be put into the sub-report on-demand. The sub-reports on demand appear in the main report in the form of hyperlinks. When the main report is turned on, no data on which the sub-report is dispense until the corresponding hyperlink is deepened.
For example, in the design report, each employee may also wish to track the progress of each employee by following the quarterly sales of each product and each product type. However, many users who view the report may not be interested in this extra data. In such cases, the weekly sales section of the report can be extracted, and it is attached to the report as an on-demand assignment sub-report. Detailed information about weekly sales conditions only when the user deepens on the sub-reports on the sub-reports in the press. Many report objects (such as large crosstabs, OLAP meshes, advanced charts, and maps) can include ideal candidate objects in a sub-report in need to deepen them before they are deepened.
To insert a sub-report, see Insert a sub-report and create a sub-report as needed.
Tip: You can also put this type of report object in the Hidden "Details" section of the report using the "Packet" option on the server. When doing this, the database server performs most of the processing tasks, and only the recorded subset is transferred from the server to the local computer (other records). --------------------------------- Third, in the database server-side processing packet and sort 1, advantage (1) The connection time with the database server is shorter. (2) There are fewer data from database servers to clients. (3) The transmission time from the database server to the client is shorter. (4) Less memory required to process reports on your computer.
2. Execute majority processing on the server and only push your computer on your computer. Server-end processing enables you to create a report to perform multi-processing on the server and only push your computer on your computer.
Server-side processing is operational: Send SQL statements to the database server by using SQL delivery technology, Crystal Reports uninstalls many data retrieval and sorting work to the server system, released local memory and resources for use More important tasks. That's why server-side processing only processes reports of sorted and grouped, if the report is not sorted and packet (for example, if a simple list report), the server cannot be pushed. It should also be noted that server-side processing only processes reports based on SQL data sources.
Note: This description is only applicable to the case where packets and sorts are unloaded into the server. When pushing the packet into the server, the required temporary database may use a large number of server resources.
Keep in mind: To execute the group on the server, the report must meet the following: Enable the "Packets on the server" option (located in the Options dialog). For more information, see Enabling server-side processing. Reports use some group of packets. The report is at least partially hidden (at least "Details" section must be hidden). Since the server will handle those hidden sections, the larger the visual part of the report, the greater the amount of processing that must be performed on the client. If the Details section is displayed, the server-side processing will not be possible. In some cases, the formula field must be processed on the client. If the packet is based on the formula field, or if the formula is used in the summary field, all records must be transmitted to the client to obtain the formula. This will increase the amount of time required to run the report. Therefore, it may be necessary to use SQL expressions as alternatives to formulas. Note: Recording the selected formula is an exception, which can be pushed into the server. In order to process reports on the server, any running total in the report must be based on a summary field (because the data required to run the total will be pulled to the client). In order to handle the report on the server, the report must not contain average or non-repetitive count summary. The report does not contain the specified value packet. Note: When deepening the hidden festival in the report, the connection to the server will be automatically launched as the process on the server is processed. If the connection from the client to the server (for example, if the report is downloaded to a laptop and processes from the remote location), the deepening of the data will result in an error due to the database unavailable. If you use the Report Save Data option to save a report that is partially handled on the server, the program will only save records that have been transferred to the client. In other words, if a hidden feature has been deepened, and in the Crystal Reports, there is a tab for those data (indicating that data is transmitted), and those records are saved. -------------------------------- 4, using the data saved in the report. 1. Advantages (1) No connection with the database server. (2) No data transfer from the database server to the client. (3) No transfer time from the database server to the client.
2. The saved data has a report with saved data to handle data that is not updated frequently. When users browse with reports with saved data and deepen columns or charts to view detail, they don't directly access database servers; instead, they accessed the saved data. Therefore, reports with preserved data not only reduce network data transmission, but also reduces the burden on the database server.
You can schedule these reports within Crystal Enterprise to automatically refresh from the database. For example, if the sales database is only updated once a day or once a day, then the report can be run in a similar schedule and save it with the data. In this way, the sales representative can always use current sales data without having to access the database each time you open the report. Alternatively, you can also refresh the report with the saved data as needed.
To save reports with data, you must first make sure that the "Save Save Data" option is selected in the File menu and save the report.
3. Save the data with the report to use the created report again if you plan to use the created report (for example, accurately adjust it), or intend to sharing the report with other people who cannot access the original data, please use the "Save the data with the report" together " command. Typically, the program saves the report definition and its basic data when the report is saved. Report definitions include all information required to print reports. These data are snapshots of raw data when running the report. If the option commands on the File menu clears the "Save the Data with the Report" option, the program only saves the report definition. Data must be refreshed each time you run the report. See refreshing report data commands. To select this option for the current report, use this command.
Consider something before using the "Save Data and Save" commands.
If you only save the report definition, you need less disk space (enough template only), but the program needs to retrieve data before printing the report. If the data is saved with the report, the report requires more disk space (sufficient to report template and data), but the program does not need to retrieve data before printing the report. Switch the command between the open or off as needed. By default, this option is set to open. To change the default settings, select the option command from the File menu and select the "Save Data" and save the data with the report "option after the" Establish Report "tab (" Options dialog) dialog box appears.
Note: The data is compressed when the program saves the data with the report to reduce the disk space occupied. Data will be decompressed when you open a report.
