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