Solved

SSRS Matrix column visibility

Posted on 2014-09-30
3
148 Views
Last Modified: 2015-02-25
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
Comment
Question by:SURESH0518
  • 2
3 Comments
 
LVL 14

Expert Comment

by:Vikas Garg
ID: 40353943
Hi,

You can set the collumn visibility property

=IIF(sum(Fields!Column.Value)>0,false,true)
0
 

Author Comment

by:SURESH0518
ID: 40356514
But the above condition works in Tablix not in Matrix
0
 
LVL 14

Accepted Solution

by:
Vikas Garg earned 500 total points
ID: 40356608
If the column would have a single value then the full column will be visible.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now