how to - show 1 of 2 fields in 1 column, conditionally?

[ravina]

Hi,

I have two date fields, date1 and date2. one of them is not null.
on my report I have date column.. and I want to show date from one of this fields. I have to show date1 if it is not null or date2 if it is not null.

I tried to create data item and wrote expression etc.. do not know all steps or how to do above thing?

-ravina

 

[mfgf]

Drop a calculation into your report, with the expression as follows:

if([date1] is not null) then ([date1]) else if ([date2] is not null) then ([date2]) else (null)

Hope that helps.

MF.

 

[ravina]

sure will help. Thanks.

will try today and let you know.