hi

you want display zero when null values comming to report can i do that

yes type the following expression in report expression box:

ifnull( expression substitute(0))

saiprasad.m

raghavendra.c

9341716016

You can follow this proceedure :::

• Lets assume revenue is the field in which we have to display null values as 0.
• First creat a calculated item and
• Then write the expression of the cal item using If Then Else construct as
• If (Revenue is null) Then ('0') Else(Revenue)
• I think u can easily understand this.
• Now u can see that the null values r displayed as '0' in the calculated item.

Hope this helps u...

Select he column u need in report.In the left pane u will find properties.

Select dataformate

In that u select Number

U will find Missing value characters giv zero there.

This May solve ur problem.Sorry if am wrong...

Thnx