mrc Documentation
michaels, ross & cole, ltd.
http://www.mrc-productivity.com/
|
|
Controlling
the Number of Records Returned in a Reports
Ever
see a message like this before?
(Web
2.0 Report)
Or
“The
web report can only handle 10000 records” is a common error if you are trying
to develop a report that is run over a very large file. This governor is placed
on the application for a few reasons.
- Since a
Report returns all the data to the screen at one time, reports over 10,000
records will be slow to your end user.
- Very
large reports can place a strain on your database server affecting others
trying to work with the database.
- End users
usually do not have the patience to wait for a large report to run.
- In a
practical sense, very large reports are only needed to show sub-total and
grand total data, not detail level. If this is the case, consider first
building a summary file to extract all of the sub-total data first. Then,
run a report over the summary file.
Of
course, you can increase the preset governor. Here is how:
Compile
your report, then enter m-Painter. Click on the
“Application Properties” link in the toolbar (circled below).
Once
in the Application Properties screen, navigate to the “Program Options” tab,
and search for the “max_records” and max_web_records” parameters.
If
the report is only run from batch, then only the “max_records”
needs to be modified.
If
the report is only being run interactively (from a browser), only the “max_web_records” needs to be modified.
As
a general rule of thumb, many users modify both these values as an interactive
report may, one day, become a report run from batch.
Increase
the number to your desired upper governor. Note:
For your protection, there is no “No Limit” setting.
After
you have increased the numbers accordingly, click OK. Then click the “Save and Deploy” button. Re-run your report.