[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

SSRS Matrix column visibility

I have ssrs matrix report with Months 1 and 12. if there is no data in any one of months I would like to hide that column

Example:

Account Id                   Jan    Feb  Mar  Apr May Jun Jul Aug  Sep Oct Nov Dec
100                                1        2       3       4                          7     10   11            12

output will be

Account Id                   Jan    Feb  Mar  Apr  Aug  Sep Oct  Dec
100                                1        2       3       4       7     10   11     12
0
SURESH0518
Asked:
SURESH0518
  • 2
1 Solution
 
Vikas GargBusiness Intelligence DeveloperCommented:
Hi,

You can set the collumn visibility property

=IIF(sum(Fields!Column.Value)>0,false,true)
0
 
SURESH0518Author Commented:
But the above condition works in Tablix not in Matrix
0
 
Vikas GargBusiness Intelligence DeveloperCommented:
If the column would have a single value then the full column will be visible.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now