Empty Subreport

[runbear]

A subreport has no data (query finds no records).



How do I get it to show zeros instead of blanks?

[blazerboy6]

You and me both, This seems to be a more common issue than I thought.

[pbaldy]

If you mean to get a zero value to some other point, I use this:

nnz function

[runbear]

NZ only works if there is a record.

[pbaldy]

Look more closely. That's a custom function; note the two n's. It will handle when a subform or subreport doesn't return any records (from outside it).

[runbear]

Thanks, will try it.