#### Improving the performance of running a report to Delimited Format on JReport Enterprise Server

When exporting a report to Text, if you want to improve the performance of running a report to Delimited Format (such as the CSV format) on JReport Enterprise Server, you are first required to set certain settings in JReport Designer. After which you can then publish the report to JReport Enterprise Server for running to Delimited Format. See the example below:

1. Start JReport Designer and open the report you want to run to Delimited Format on JReport Enterprise Server.
2. In the Report Inspector, browse to the root node of the report, find the two properties Fast Pass and Columned, and then set them to true.
3. 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.

4. 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 to Delimited Format.
5. Publish the report to JReport Enterprise Server. When you run or schedule the report, after you choose the 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.