For prompts and notes for how to create a fast interactive report, see making correct design selections. For information on how to fully use existing databases, see Optimizing your tablistic environment. To reduce the amount of data transfer and enhance the performance of the report, see Selected Formulas using enhanced records. To shorten the processing and data transfer time of packets, sort, or total reports, see Improve packets, sorting, and total. Under normal circumstances, you will encounter similar performance issues regardless of the way you are distributed. By the following strategic operations, you will find that the performance is not only improved in the multi-user web environment, and performance in single-user situations will be significantly improved. ------------------------------------------------ make correct Design Selection This section provides design choices and considerations that help to improve statements. This topic covers the basic recommendations, such as updating the old report to the latest file format, to more complex decisions, such as using active data or using the saved data and how to effectively use sub-reports.
In design reports, especially when designing reports for web, the reporter should be allowed to manipulate the data they viewed. That is, the summary information is displayed so that each user can quickly browse the report, then deepen to access other data. With this method, since the data requested only from the database server, the Web traffic is minimized and the response time is shortened.
The following is just a few advantages of designing user-driven reports:
Report users can interact with the type and quantity of the information viewed on the Web. Because only the information requested only from the database server, data transfer and network traffic are reduced. When the user needs to make a report based on the web based on real-time data, the user's report responds quickly and can effectively communicate with the database server. Reports are more useful because each user can customize the contents of the report, thereby creating report solutions for their specific decision issues. This section contains four topics:
Use the faster report format to select the design summary report between active data and saved data to use a report --------------------------- --------------------- Optimize your watch environment The step of ensuring that the report user can quickly receive information is to assess the watch environment. Which type of database do you use? How to organize data in the database? How do I connect to data that needs to make it report? How to link to a database table? By considering these important factors, you can significantly reduce the amount of data that must actually transmit through the network.
This section contains five topics:
Choose the fastest database and connection Use Table Index Improve Table Links to choose to use the thread secure database driver to use the stored procedure faster process -------------------------------------------------------------------------------------------------------------------------------------- -------------------------- Using enhanced records The most important way to increase report handling speed is to limit the amount of data returned from the database. The main tool to achieve this is to record the selected formula.
Crystal Reports analysis records the selected formula and generates SQL queries. Then, the database processes the SQL query, send the resulting record back to Crystal Reports. Crystal Reports then performs a recordset that records the recorded selection formula for each record retrieved from the database, thereby calculating the record set for ç.
Unnecessary records can be removed in the following two phases: query over the database through the SQL query and by logging selected formulas in Crystal Reports. In order to improve the speed, you may need to eliminate records as much as possible in the first phase. By efficiently designing the selected formula, a large part of the processing can be pushed to the database server, so that the database has eliminated unnecessary records before returning records to Crystal Reports. This is often referred to as "pushing the record to the database server".
For a short demodation that pushes the record selection to the database server how to improve performance, please refer to the subcoutrically recorded - example. This section provides a few points to ensure that the record-selected formula is pushed to the database server:
Record the selected performance prompt to write efficient records of the selected formula, merge the parameter field to record the SQL expression in time in the record selected formula -------------------------------------------------------------------------------------------------------- -------------------------- Improve packets, sorts and total execution groups on the server When making real-time tabs from active data through web, Use option "to execute packets on the server" to reduce the amount of data transmitted from the database server. After using this option, most of the data processing work is uninstalled to the database server and only one data subset is only in the beginning. The details are returned from the database only when you deepen in the report.
Note: The server-side processing is only applicable to those skilled and packets based on SQL data sources.
Enable server-side processing in the File menu, click Report Options command. Select "Perform Packet on the Server" in the Report Options dialog box. If you do not select "Use indexes or servers" to increase speed, the checkbox is inactive.
Tip: When the "Use Index or Server" is selected, you can quickly enable packets on the server from the Database menu.
Click OK. To learn how to affect performance on the server, go to the benefits of grouped on the server - example.
Related topics Insert SQL expressions for grouping, sorting, and totaling SQL expressions for CASE logic in population and running total field
