Calculated Field with null

[jayjay5]

Hi

I am a brand new user to SSRS using 2008 R2 - formerly a Crystal user.

I need to do a calculated field where there are dates in two tables and if date is null in first table then use date in second table e.g.
if table1.stardate is null then table2.startdate
(else table1.startdate)

I just can't work it out, can anyone help?

Thanks

 

[xlbo]

SQL table or report table?

same data set or different data set?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question