I have a field in the Group footer of my report that is supposed to add values from two different subreports.
The expression is: =IIf([rptSubInvOutstanding].[Report].[HasData],[rptSubInvOutstanding].[Report]![Diff]+[rptInvoicesSub].[Report]![txtGrSum],[rptInvoicesSub].[Report]![txtGrSum])
If the rptSubInvOutstanding does not have data the field shows properly with the value from txtGrSum. However if rptSubInvOutstanding does have data the field does not show at all.
Just to add a little fun to it, if rptSubInvOutstanding does have data the system print previews a page with no totals and then an extra page with the proper totals. Fun Huh?
I am hoping that if we can fix the first issue that the other one will go away.....I hope.
Thanks