<div>
Hi,<br />
<br />
You can set the collumn visibility property <br />
<br />
=IIF(sum(Fields!Column.Val<wbr />ue)&gt;0,fals<wbr />e,true)
</div>


Hi,

You can set the collumn visibility property

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

<div>
But the above condition works in Tablix not in Matrix
</div>


But the above condition works in Tablix not in Matrix

<div>
<div class="content wysiwyg-content">
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<br />
<br />
Example:<br />
<br />
Account Id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jan &nbsp; &nbsp;Feb &nbsp;Mar &nbsp;Apr May Jun Jul Aug &nbsp;Sep Oct Nov Dec<br />
100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7 &nbsp; &nbsp; 10 &nbsp; 11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12<br />
<br />
output will be<br />
<br />
Account Id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jan &nbsp; &nbsp;Feb &nbsp;Mar &nbsp;Apr &nbsp;Aug &nbsp;Sep Oct &nbsp;Dec<br />
100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; 7 &nbsp; &nbsp; 10 &nbsp; 11 &nbsp; &nbsp; 12
</div>
</div>


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

SSRS Matrix column visibility

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.