Need help with a funky report in access 2013
I have a report that prints a list of items and then their total. There are groups (such as all the percentage discounted items are grouped together and the flat value discounted items are together, and the like) but the user does not want any subtotals.
I put the grandtotal in the page footer. I was going to put the grandtotal in the report footer, but there is a proprietary statement that has to show up at the bottom of each page. So here is what I did, and so far it is almost working:
I put both the grandtotal and the proprietary statement in the page footer (the grandtotal line above the proprietary), and put some code in to see if it is a one page report or a multipage report. If it is a one page report, the page footer prints normally, if it has more than one page, the grandtotal area controls are set to white so that the user does not see them, on the previous pages and then on the last page the controls are set back to black.
Now here is the issue. This actually works except sometimes the report will print with a second page with no details lines on it but the grandtotal is at the bottom.
How does Access decide there should be multiple pages? To me, when I see the report with all the records filling the detail section, should only be one page, but the pages property shows 2, and like I said there is nothing in page 2's detail section.
I hope this makes sense.
Andy
I put the grandtotal in the page footer. I was going to put the grandtotal in the report footer, but there is a proprietary statement that has to show up at the bottom of each page. So here is what I did, and so far it is almost working:
I put both the grandtotal and the proprietary statement in the page footer (the grandtotal line above the proprietary), and put some code in to see if it is a one page report or a multipage report. If it is a one page report, the page footer prints normally, if it has more than one page, the grandtotal area controls are set to white so that the user does not see them, on the previous pages and then on the last page the controls are set back to black.
Now here is the issue. This actually works except sometimes the report will print with a second page with no details lines on it but the grandtotal is at the bottom.
How does Access decide there should be multiple pages? To me, when I see the report with all the records filling the detail section, should only be one page, but the pages property shows 2, and like I said there is nothing in page 2's detail section.
I hope this makes sense.
Andy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thank you for translating:)
ASKER
Thanks for the response. The total line I am printing is not for the groups (I had that at one point as a subtotal in the group footer but they did not like it) it is a grandtotal for the whole invoice. I just cannot figure out how and why Access thinks I need a second page when it fits everything in the detail section.
Andy