Troubleshooting

Printed Reports Show Only a Single Record

Sometimes, my printed reports contain only the first record of data. Why is that?

Chances are that your print settings are configured to print the current record rather than the current found count. When printing from a list view, be sure to select the option to print Records Being Browsed. This configuration can be specified within a script, so be sure to set your print scripts to use this configuration as well.

Slow Generation of Subsummary Reports

I have built several subsummary reports, but many of them take quite a while to generate. Is there anything I can do to speed them up?

A number of factors can influence the time it takes to generate a subsummary report. The most important of these is the size of the found set. A subsummary report over a found set of 50,000 records takes considerably longer to generate than one with 100 records. Another factor is the amount of summarization the report performs . Having a half- dozen summary fields in a subsummary part requires more time than a report with a single summary field.

Another potential bottleneck is the complexity of the summarization. Summary fields that operate on plain number fields generally perform better than summary fields that operate on calculations that return number results. This is especially true if the calculations contain complex logic or aggregate functions that operate on large record sets.

There are a few things you might try to help ease the pain of slow subsummary reports. The first is to automate the reports to run during the middle of the night; you can view the results as a PDF in the morning. Another option is to pre-summarize some of the data. This might involve running a script to set plain number fields to the result of complex calculations. Or you might create utility tables where you can store summarized data. For instance, every month you might run a month-end closing routine that posts monthly totals for each product or salesperson to a utility table. Then, rather than summary reports based on granular data, you can run reports against the pre-summarized data.