[dba-SQLServer] SQL - What's a null in Reporting Services

Eric Barro ebarro at verizon.net
Thu Jan 19 18:33:06 CST 2006

If IsDBNull 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Thursday, January 19, 2006 4:17 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] SQL - What's a null in Reporting Services

Hello all

In Access to test for null and replace it with x I would do something like


When I try this in a text box in reporting services it says

Replace Null with System.DBNull

So I did and now get the error...

dBNull is a type in system and cannot be used as an expression


Anyone know what the correct syntax should be to test for Null and put in my
own value if true and 

Leave the FieldValue if not true?

Many thanks


dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

__________ NOD32 1.1372 (20060119) Information __________

This message was checked by NOD32 antivirus system.

More information about the dba-SQLServer mailing list