Home > Report Result Formats > Exporting report results > To Text > Improving the performance of running a report to Delimited Format on JReport Server
Improving the performance of running a report to Delimited Format on JReport Server
When exporting a page report to Text, if you want to improve the performance of running the page report to Delimited Format (such as the CSV format) on JReport Server, you are first required to set certain settings in JReport Designer. After which you can then publish the report to JReport Server for running to Delimited Format. See the example below:
- Start JReport Designer and open the page report tab you want to run to Delimited Format on JReport Server.
- In the Report Inspector, browse to the node of the report tab, find the two properties Fast Pass and Columned, and then set them to true.
- Choose the object you want to display in the result file, and then set the location for where you want it to be shown in the result file.
To do this, select the object, and set its Column Index and Row Index properties in the Report Inspector as required. ColumnIndex refers to the column where the object will be located, and RowIndex refers to the row where the object will be located in the result file. The numbers of the column and row start with 1, and are counted within its parent. For example, if you want to place the object in the first column and the second row in the detail section, set ColumnIndex = 1 and RowIndex = 2.
- Go to the server.properties file in
<server_install_root>\bin, and change the property engine.single_thread = false. This enables the property Fast Pass to take effect when running the report tab to Delimited Format.
- Publish the page report containing the report tab to JReport Server. When you run or schedule the report, after you choose the report tab and then choose To Text format, select the Delimited Format box, and then click Submit to generate a Delimited Format file.
Notes:
- When the Fast Pass property is set to true, in the report header panel, the values of the objects that use global parameters to make calculations will be incorrect. Page level calculation, such as Page Number and Total Page Number, will also be incorrect. In order to avoid such errors, you should move these objects from the report header panel to the report footer panel.
- Remember to set the positions for objects with the Column Index and Row Index properties. Otherwise, all the objects will be located in the first column and the first row of the result file.