0 TOTALS IN SUBREPORTS

[BobH]

I have a report with 15 subreports that total different
fields of my application. What can I do to print a Zero
(0) where there is no information for the subreport to
calculate.
I've looked for default settings and a way to write some
script but so far I have no luck with either.

Any and all assistance will be greatly appreciated.

Bob Hightower

 

[Ken Snell]

Try wrapping the field that's being summed with Nz function:

=Sum(Nz([FieldName], 0))

 

[Duane Hookom]

To borrow from Allen Browne's response
=IIf([Sub1].[Report].[HasData], Nz([Sub1].[Report].[Text1], 0), 0)

 

[Marshall Barton]

Try wrapping the field that's being summed with Nz function:

=Sum(Nz([FieldName], 0))

NZ won't get a chance to do anything when the subreport has
nothing to sum. Actuall subreport are totally suppressed
when there is no data for it to process.

This must be dealt with in the main report by making a label
control with a caption of "0" visible or not:

Me.lblZero1.Visible = Not Me.subreport.Report.HasData

you may also need to set the subreport control too:

Me.subreport1.Visible = Me.subreport.Report.HasData

 

[Ken Snell]

Thanks, Marsh.

--
Ken Snell
<MS ACCESS MVP>

Try wrapping the field that's being summed with Nz function:

=Sum(Nz([FieldName], 0))

NZ won't get a chance to do anything when the subreport has
nothing to sum. Actuall subreport are totally suppressed
when there is no data for it to process.

This must be dealt with in the main report by making a label
control with a caption of "0" visible or not:

Me.lblZero1.Visible = Not Me.subreport.Report.HasData

you may also need to set the subreport control too:

Me.subreport1.Visible = Me.subreport.Report.HasData

 

[Marshall Barton]

Thanks, Marsh.

Sorry Ken, that was supposed to be a reply to BobH. I guess
I mentally combined both your reply and his post into the
common question of why doesn't NZ take care of the problem.