By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,158 Members | 917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,158 IT Pros & Developers. It's quick & easy.

Order of subreports on main report

P: 7
:confused: I have inheritted a system with reports that were probably written by a novice access programmer. My problem is a report with a dozen subreports in them. I had to add another subreport to that report. Many subreports set a global variable that is used to sum grand totals later. When I added my report, placed in the middle of the report, I found that the grand total subreport, which is placed after my subreport, is opened prior to my subreport. My subreport adds a value to that grand total. Because my report opens after, it is not included in the grand total subreport.

How do I determine or set the order of subreports on the main report?

Al
:confused:
Jun 27 '06 #1
Share this Question
Share on Google+
2 Replies


PEB
Expert 100+
P: 1,418
PEB
:confused: I have inheritted a system with reports that were probably written by a novice access programmer. My problem is a report with a dozen subreports in them. I had to add another subreport to that report. Many subreports set a global variable that is used to sum grand totals later. When I added my report, placed in the middle of the report, I found that the grand total subreport, which is placed after my subreport, is opened prior to my subreport. My subreport adds a value to that grand total. Because my report opens after, it is not included in the grand total subreport.

How do I determine or set the order of subreports on the main report?

Al
:confused:
Hi,

Ohh My Got it's easier to recreate the report isn't it! Reelly I don't have any idea why it's like this...
Sep 9 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Try setting group headers and footers. By putting the subreports in footers and that grandtotal subreport in the report footer this should help.



:confused: I have inheritted a system with reports that were probably written by a novice access programmer. My problem is a report with a dozen subreports in them. I had to add another subreport to that report. Many subreports set a global variable that is used to sum grand totals later. When I added my report, placed in the middle of the report, I found that the grand total subreport, which is placed after my subreport, is opened prior to my subreport. My subreport adds a value to that grand total. Because my report opens after, it is not included in the grand total subreport.

How do I determine or set the order of subreports on the main report?

Al
:confused:
Sep 9 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.