Adding Subreport moves main report grand total

Adding Subreport moves main report grand total

Hello there. My job is in the prehistoric district, where we run Access 2007. I am trying to add a subreport to my main report, which works for the most part. However, I have one issue dealing with the main report grand total in the Report Footer. Before adding the subreport, the grand total in the report footer will show on the last page of the report. However, after adding the subreport to the report footer, the grand total now shows at the beginning of the sub report, instead of the end of the main report.

What do I need to do, in order to add my subreport AND also keep my grand total on the last page of the main report? Any help is greatly appreciated, as I’ve been pulling my hair out trying to solve this for awhile.

Below is the report before adding the subreport, with the grand total working as desired.

https://i.redd.it/49t6xpy4a6431.png

Below is the report after adding the subreport, with the grand total now showing at the top of the subreport page, and erased from the main report on the page before it.

https://i.redd.it/ce1bgfhb96431.png

The amount of space at the bottom of pg.84 is irrelevant. Even with lots of space, the total is shown on the next page.

https://i.redd.it/xc79coc7a6431.png

submitted by /u/Passett
[link] [comments]

Posted on

Adding Subreport moves main report grand total

Adding Subreport moves main report grand total

Hello there. My job is in the prehistoric district, where we run Access 2007. I am trying to add a subreport to my main report, which works for the most part. However, I have one issue dealing with the main report grand total in the Report Footer. Before adding the subreport, the grand total in the report footer will show on the last page of the report. However, after adding the subreport to the report footer, the grand total now shows at the beginning of the sub report, instead of the end of the main report.

What do I need to do, in order to add my subreport AND also keep my grand total on the last page of the main report? Any help is greatly appreciated, as I’ve been pulling my hair out trying to solve this for awhile.

Below is the report before adding the subreport, with the grand total working as desired.

https://i.redd.it/49t6xpy4a6431.png

Below is the report after adding the subreport, with the grand total now showing at the top of the subreport page, and erased from the main report on the page before it.

https://i.redd.it/ce1bgfhb96431.png

The amount of space at the bottom of pg.84 is irrelevant. Even with lots of space, the total is shown on the next page.

https://i.redd.it/xc79coc7a6431.png

submitted by /u/Passett
[link] [comments]

Posted on