Hello all,
I have two issues that I need to solve through.
1. I have a report that uses 3 subreports. Each subreport has a total in its report footer. I have a textbox in my main report that adds up all of the totals from each subreport and it appears to display correctly when I select print preview. This only works if all of the subreports aren't blank (I have verified this to be true). 2 of the subreports should always have something in it. The 3rd subreport may or may not have a total because there may or may not be any activity that month for a particular person that the report is being conjured up for.
My equation in the text box for the mainreport is: =[subreport1].[Report].[subTotal1]+[subreport2].[Report].[subTotal2]+[subreport3].[Report].[subTotal3]
I've tried wrapping the subreport total in Nz, but that didn't work. this gives me #Type! error
I've tried the equation above using Nz([subreport3].[Report].[subTotal3]). that throws #Size! error
I've tried, in the subreport, to use a query with an expression for either IsNull or IsEmpty and when I view it shows nothing...which I though it was supposed to say true or false?
2. Once I get #1 working, my next problem involves that same subreport. Right now my main report is setup so that each subreport is on its own page by using page breaks. If my third report is blank, then I don't want it to show and I don't want it to use the page break control. So it should either show me 3 pages if all subreports have something in it, or only two pages if the one report has nothing in it.