Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Anand.A
Posting Yak Master
109 Posts |
 Posted - 2012-02-22 : 03:09:19
|
| hii create a report in ssrsso in that report i want to get month_name jan,feb,mar,april - total valuesso i create a calculated fieldin that field i wrote expression like this=iif(Fields!month_name.Value='jan' ,Fields!TOTAL_AMOUNT.Value,nothing)but this will give, only month for jan how to get all the month dataanand |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-22 : 09:42:23
|
| add a grouping based on Fields!month_name.valueand then under group data region add=SUM(Fields!TOTAL_AMOUNT.Value)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
ssrs expression