MSAccess: SubReport Missing in Print Preview and Print
Hello Experts
I have a collection of SubReports inside a MasterReport. I'm having a small problem where SubReport number 9 (for instance) doesn't show up if there are no records. Instead there is just a blank section in the MasterReport, and then it shows the next SubReport. Its worth noting that SubReport number 9 does show up in Report View and Layout View, but does NOT show up in Print Preview or during an actual Print.
Ideally, we'd like it to display the headers for this SubReport and no records underneath them - instead of just all white space because this MasterReport is structured with numbers in the Titles, etc. (Check Number 1 - Expenses; Check Number 2 - Overdrafts, where 1 is SubReport 1 and 2 is SubReport 2). The numbers are important, and the order is also important.
For what its worth, I am using Office 365 Access.
Thanks for your ideas and thoughts!
-IT_Crowd
I have a collection of SubReports inside a MasterReport. I'm having a small problem where SubReport number 9 (for instance) doesn't show up if there are no records. Instead there is just a blank section in the MasterReport, and then it shows the next SubReport. Its worth noting that SubReport number 9 does show up in Report View and Layout View, but does NOT show up in Print Preview or during an actual Print.
Ideally, we'd like it to display the headers for this SubReport and no records underneath them - instead of just all white space because this MasterReport is structured with numbers in the Titles, etc. (Check Number 1 - Expenses; Check Number 2 - Overdrafts, where 1 is SubReport 1 and 2 is SubReport 2). The numbers are important, and the order is also important.
For what its worth, I am using Office 365 Access.
Thanks for your ideas and thoughts!
-IT_Crowd
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@als315 - yeah, I've seen that "solution" online and I was hoping to avoid it. At this point I am considering it though.
@hnasr - yes, report 9 is empty. If I change the positions, it remains blank (white space) but just in the new spot on the report. There is no code to not print if empty (or not show, or anything like that)
@hnasr - yes, report 9 is empty. If I change the positions, it remains blank (white space) but just in the new spot on the report. There is no code to not print if empty (or not show, or anything like that)
It is real way :). It is used very often for multicolumn subreports
Upload a sample, if you can reproduce the issue, with only 2 subreports 9 and another one.
Add an image of the expected output.
Add an image of the expected output.
ASKER
Thanks! I'll be extracting the subreport headers out and showing them on the main report page.
What happens if you switch positions of sub reports 1 and 9?
Do you have any instruction, not to print if empty?