Subreport null data

[andrew3254]

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?

 

[Golfinray]

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

 

[andrew3254]

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.
--
Thank you

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

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?