Reporting tab (Set General Preference Utility)

Configures reporting settings.

Option Description
Save accounting information Select or clear this check box to save or discard accounting information. The default setting is to save accounting information.
Maximum message log size Specifies the maximum entries that will be logged in the Message Console. The default value is 10,000 entries. If the maximum value is reached, Output Manager performs a cleanup routine to remove the oldest messages. This will reduce the message count to match the maximum number of messages.

Use the Configure button to adjust the message priority level for logging and the display level for any user that configures logging.

Output history period Specifies the number of days that will be saved in the Destination Output History window. The default period is 1095 days (3 years). The maximum period is 3650 days (10 years) Limiting the amount of data stored in the output history table is particularly important if you are using SQL Server Express, as there is a 4 GB limitation on the data file.
Reporting query timeout Specifies the reporting query timeout period. Reporting queries by default time out in 30 seconds. If you have a report that is timing out, and you do not mind waiting longer you can increase this timeout period.

Generally, a better solution is to determine why the query is taking so long to complete. For example, decreasing the Output History Period setting will reduce the number of rows in the output history table and will cause most reports to run faster.

Maximum report size Specifies the maximum number of records in a report. The default value is 10,000 records.