NULL field in SQL Reporting Services

[jensays]

I am combining a few fields with expression like ="Entered by: " & Fields!Entered_by.Value & " on " & Fields!date_entered.Value & " " & Fields!comment.Value. Sometimes the Fields contain NULL values, in which case I want to hide the text values. In Crystal I could set it as a formula with IS NOT NULL etc. But how do I do something comparable in SQL RS? Yes, I am being "converted" over from Crystal.

 

[Sheco]

IF Fields!Entered_by.Value [highlight]Is Nothing[/highlight] THEN
'The field was null
ELSE
'The field was not null
END IF

 

[xlbo]

another option - you can account for NULLS in SQL with the ISNULL function

SELECT X,Y,ISNULL(Z,"Z Is Null") as Z
FROM a,b,c
etc etc

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

 

[henslecd]

You could write the logic into your sql statement instead of handling it on the front end. Just use a case statement.

select case when field1 is null then "do this" else "do this" end field1alias, field2 from table