DBNull issue in Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LVP - 29 May 2008 00:15 GMT

Hi all,

Using SSRS 2005

I have a SSRS report that shows #ERROR when my returned date has DBNULL

I tried to check for DBNULL, NOTHING etc..

What type of Expression should I use to have the DBNULL value as
String.empty.

I see no DBNULL.value

it seems that the error is thrown before the expression.

my field property format is set to default

Any help is appreciated.

Thank you,
LVP

Reply to this Message

prabhupr@gmail.com - 27 Jun 2008 17:19 GMT

Can you try TRIM, if return is string & then check Variable= "". Not
sure if this works, but worth the try...

> Hi all,
>
[quoted text clipped - 17 lines]
> Thank you,
> LVP

Reply to this Message

Bruce L-C [MVP] - 27 Jun 2008 18:01 GMT

I would do this in SQL. Use IsNull function in your query.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

Can you try TRIM, if return is string & then check Variable= "". Not
sure if this works, but worth the try...

On May 28, 4:15 pm, "LVP" <sql_agent...@hotmail.com> wrote:

> Hi all,
>
[quoted text clipped - 17 lines]
> Thank you,
> LVP

Reply to this Message