System resource exceeded

[Christine]

I have combined about 26 queries using "union select" into one union
query. I have made 5 level groupings with "Sorting & Grouping" in the
Report. The details and the subtotal of the first and second group
footers turned out fine in the Report.

Problem starts when I try to insert a total for the third group footer,
an error message appeared "System resource exceeded" and the report
doesn't appear at all. When I delete the third footer, the Report
appears again with no problem.

Hope anyone can assist me to complete this final total.

 

[Christine]

*I have combined about 26 queries using "union select" into one unio
query. I have made 5 level groupings with "Sorting & Grouping" i
the Report. The details and the subtotal of the first and secon
group footers turned out fine in the Report.

Problem starts when I try to insert a total for the third grou
footer, an error message appeared "System resource exceeded" and th
report doesn't appear at all. When I delete the third footer, th
Report appears again with no problem.

Hope anyone can assist me to complete this final total. *

Has anyone encountered error message "System Resource Exceeded" whe
you try to add a third footer? I really need this one more footer fo
the report to appear and my whole project will be done