sql server reporting services: Handling nulls in matrix sub totals -- sql server reporting services

You're in the

sql server reporting services

group:

Handling nulls in matrix sub totals

Andrew Murphy
7/31/2006 9:47:01 AM

sql server reporting services: I have a matrix where I am using the inscope function to return different
calculations depending on which group it is in (ie the detail is just the
value and the sub totals are sum(values)).

In for the subtotal group I have used:

iif(isnothing(sum(Fields!CurrentCount.Value)), 0,
sum(Fields!CurrentCount.Value)

But this is still returning blanks where there are no values in the group to
sum together.

Can anyone suggest how to get around this issue as it ?

TIA

Andrew

Re: Handling nulls in matrix sub totals

Ben Watts
7/31/2006 1:01:44 PM

you might try iif(sum(Fields!CurrentCount.Value = nothing)
[quoted text, click to view]

Re: Handling nulls in matrix sub totals

Ben Watts
7/31/2006 1:09:28 PM

also if this formula you put on here looks just like the one you have in the
expression then you need to add a perenthesis onto the end. I tried to
recreate your problem and I get a 0. Weird

[quoted text, click to view]

Re: Handling nulls in matrix sub totals

Ben Watts
7/31/2006 1:11:43 PM

and aslo maybe you should try to set the null value to 0 before you sum it.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn