I am building a very complex report with several sub reports. When I filter the overall report to a particular company everything appears to work but when not filtered I get the message. Could I be hitting a limit on the number of queries across the the total database? The report is used as a completion of a tax audit which is closing and will be archived. I think the report will only be run on a single company at a time. But not sure.
Any suggestions where to look or any approach for creating a very complex report. Currently the main report has four subreports with one of the subreports including two additional subreports.
Should temp tables be created for each of the subreports then used to populate the complete report?
Hopefully I am making sense.
Rod
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar