HasData?

[genevx]

Hi,
I have a subreport and I want to calculate the totals for it. however, since it is connected to the main report, some fields might not always have data for the subreport. I'm guessing that's what's causing the total not to come out if there is no data for the field. I did a quick search the forums and I'm guessing it has something to do with the HasData Property. But where and how am I supposed to state this? thanks for the help! =)

genevx

 

[norm]

I'm doing something similar and am pretty sure you need to carry the subtotal over via the main report and only from the subreport's footer section... i think.

i'm following http://support.microsoft.com/default.aspx?scid=kb;en-us;Q208835 but haven't gotten it to work yet.

If something works for you let me know....

 

[Rich]

There have been several examples of how to use the HasData method here, try searching or post back for more specific help

 

[genevx]

=IIf([rptMgrsSummaryToday].[Report].[HasData]=True,[rptMgrsSummaryToday].[Report]![Total],0)

I found it out. put that in the control that carries your total out from the subreport to the main report. Bascially it makes all blank record sources = 0.

genevx

thanks for trying! =P

 

[Rich]

You don't need the =True part