Knowledge Base

Using Prepared Report

  • 74views
  • February 6, 2024

Using Prepared Report

Often, when generating a report that involves a significant amount of data, such as a GL report for the entire year, you might encounter the following error message: “Request Timed Out.” This happens because there is a large volume of data to be processed and displayed on the report page, but the server resources are insufficient, leading to a timeout.

To enhance the processing of such reports, BizCentric provides Prepared Reports. When a report is designated as a Prepared Report, it is generated via a background job. Once it’s ready, users can view it without encountering timeouts.

Steps to Set Up Prepared Reports

  1. Go to Role Permission for Page and Report.
  2. In the field ‘Set Role For’ select Report.
  3. In the ‘Report’ field select the report for which you want to enable/disable prepared report.
  4. Use the Disable Prepared Report checkbox to enable/disable the prepared report. If the option is checked, the prepared report option will be disabled for the selected report.
  5. Click on Update.

How To Use A Prepared Report

  1. Open said report (say General Ledger) and apply all filters needed.
  2. If the prepared report option is enabled for that report, you will see a Generate Report button. Click on the same.
  3. You will see a notification on the bottom-right of the screen saying “Report initiated. You can track its status here
  4. You can either wait on the said screen or click on here in the above message to open the page for the report. This will open a new page for the report:  As you see, the report page has status as “Queued”. Once the report is ready, you will see a Show Report button which you can click to view the report:
  5. Since Prepared Report is also a doctype, to view the list of Prepared Reports, you can use the Role Permission Manager to grant access to the same.