Subreport null data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

andrew3254 - 09 Apr 2008 10:14 GMT

Hi

I have a report with multiple subreports on it, one for each month.

The subreports are linked to the main report via a project ID, and some
projects dont have data entered for that month. The missing data is blank
but I want to show 0s. I have tried

Nz([Int Forecast], 0)

and

IIf(HasData, [Int Forecast], 0)

and neither work.

Does anyone have any ideas?

Signature

Thank you in advance

Reply to this Message

Golfinray - 09 Apr 2008 13:58 GMT

Try this - it should be close. IIf([int forecast]>0,[int forecast],0)

> Hi
>
[quoted text clipped - 13 lines]
>
> Does anyone have any ideas?

Reply to this Message

andrew3254 - 09 Apr 2008 14:47 GMT

Unfortunately no. I also tried using VBA in the NoData section in the module
to see if I can change the values in the text boxes. That didn't work
either. Its something to do with their not being data for a specific project
for the appropriate month. All the data management functions that deal with
this dont seem to be working.

Signature

Thank you

> Try this - it should be close. IIf([int forecast]>0,[int forecast],0)
>
[quoted text clipped - 15 lines]
> >
> > Does anyone have any ideas?

Reply to this Message