IsNothing not working on empty value in report builder

reporting-services ssrs-2008 report reportbuilder3.0
user2094981 picture user2094981 · Jul 7, 2013 · Viewed 39.3k times · Source

I have an expression in a table that checks if there was a return value.

If the query returns empty or null I want to set the value to 0.

=IIF(IsNothing(Fields!DndCount.Value),0,Fields!DndCount.Value)

But if the query returns empty IsNothing() does not work.

Answer

Wanja picture Wanja · Sep 4, 2014

I have tried this code and it worked for me.

IIF(Sum(Fields!DndCount.Value)Is Nothing, "0", Sum(Fields!DndCount.Value))

Related questions

SSRS Pull Variables Or Values From Sub Report Into Main Report

I have a main report with several sub reports, each of these with slightly different queries and different ways to show the data. So, in my situation, I have a textbox that needs to compile data from a few different …

Read More
SSRS Report Does Not Refresh Via URL Access

I want to display the output of an SSRS report in an IFrame of another application. I set the source to something like this: http://SERVERNAME.domain.com/ReportServer?%2fTBI_MSCRM%2fCustomReports%2f%7bdafdbed0-1e96-e211-a5da-001d0967…

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More