assigning some value when the field value is null

[bravindra]

Hi,

In my database some times fileds may contains null values. when i am printing them in ireport i want to check whether it is null or not. if it is null, then i want to print it as '-'.

Could you please help me how to do that.

 

Regards,
Ravindra

[CaptnTony]

Personally, I'd let the database do the data management and let the report engine report on what is returned.  This means that I might use the IsNull() in my SQL Stmt. 

Syntax:

Select IsNull(<field>, 'N/A') AS MyValue From <tablename> Where <constraints>

In this case, if my <field> contained a null value, the query would return 'N/A' instead of null.

Hope this helps.

Post Edited by G. Todd Frahm at 01/12/09 21:28

Post Edited by G. Todd Frahm at 01/12/09 21:28