Give some name for Null Data

[#1]

Hi,

I am designing a graph for number of employees for each city. There is no data for the city field for some employees so it us seen as blank in bar chart as well as list box. I need to replace teh Null Vlaue with 'No Data'. How to do this?

[#2]

Hi,

You can write if condition for that like: if len(EmployeeName>0,EmployeeName,'Others') as EmployeeName.

Regards,

Ravi

[#3]

Try this expression

If(isnull(city) or len(trim(city))=0,'No Data',City) as city

[#4]

Hi,

Thanks, It worked when I gave the formula at Script level. But how to do at the report level? If it part of a multibox or a list box or a chart.

Nanda.

[johnw]

I recommend doing it in the script for performance. But if you really want to do it in an object, the syntax is the same. For instance, create a list box, select <expression> instead of the field, and enter the expression that was working in your script (without the "as city" part).