How to get columns that doesn't contain any data in SSRS Report

Question

Post reply

How to get columns that doesn't contain any data in SSRS Report

Mkrish

Ten Centuries

Points: 1256
More actions
September 19, 2014 at 12:46 am

#397371

I have an ssrs Report which contains amounts for the months....
but for some months there is no amount
if there is no amount that month is hiding in my report
i have tried the below expression but iam not getting the months that contains no amounts and i want to place 0 in place of amounts for the months that contains no amounts.....
=iif(SUM(Fields!Performance_Amount_Usd.Value),SUM(Fields!Performance_Amount_Usd.Value),0)
can any one suggest me how to get all the months and how to place zero for the months that contains no amount.........

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

HanShi SSC-Dedicated Points: 33507 More actions · Answer 1

Have you tried the solution offered in this post? http://www.sqlservercentral.com/Forums/Topic688467-150-1.aspx

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Mkrish Ten Centuries Points: 1256 More actions · Answer 2

sorry iam not getting

i have to use one field that is performanceamount_usd only

can u please give me according to my requirement

Thank you

HanShi SSC-Dedicated Points: 33507 More actions · Answer 3

Allthough the offered solution in the post isn't excactly what you need, you are pointed to the use of "IsNothing". So implementing this in your code it will be something like:

=iif(IsNothing(SUM(Fields!Performance_Amount_Usd.Value)),0,SUM(Fields!Performance_Amount_Usd.Value))

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Mkrish Ten Centuries Points: 1256 More actions · Answer 4

i have tried the below expression but iam not getting the months that contains no amounts and i want to place 0 in place of amounts for the months that contains no amounts.....

=iif(SUM(Fields!Performance_Amount_Usd.Value),SUM(Fields!Performance_Amount_Usd.Value),0)

and i also tried

=iif(IsNothing(SUM(Fields!Performance_Amount_Usd.Value)),0,SUM(Fields!Performance_Amount_Usd.Value))

but iam unable to get those months that contains no amounts....

is there any other way how to get all the months and how to place zero for the months that contains no amount.........

please help me...