How to set visibilty to the matrix in SSRS

Question

Hi,

I have a matrix in SSRS
                   Month       Feb-09                Mar-09       April-09          May-09
        DM                      C%  NC%           C%  Nc%      C%  NC%        C%  NC%

ES                                NA   NA                NA    NA         NA    NA          80%  20%
Others                          NA   NA                NA    NA         NA    NA          60%  40%


As per my report,there can be data only for 1 month at one time.
Now I want to set the visibilty for this report that should show only the data for that month.
I don want to show the 'NA'.

How to implement this?
I hope my explanation is clear.

Please let me know the solution.

Regards,
Ruhani

Answer 1

R u trying to replace NA by some thing which is meaningful,, if so please use REPLACE function,,,


or if u do not want show NA data..
 u can filter this at report level...

 select the matrix report.
Right click Properties..
Filters tab ..
here u specify the  condition.. to restrict the data NA

---

Praxy

Answer 2

Select the matrix column -> right click ->properties -> select Column Visibility and set your visibility condition as expression.

Hope this helps.

Regards,
Senthil

Answer 3

Hi Thanks for the reply..
Actually i have resloved the issue..I have made the changes in SP