locked
matrix rdlc report hiding the columns where there is no data RRS feed

  • Question

  • User-2011750245 posted

    Hi,

    I have a Matrix where i am showing data like pivot table. i have taken 3 column level values,2 data level values(data1,data2), and 1 row level values. Problem is when i am not getting data for data2 Report headers are showing, that should not happen.


               data1        data2

            Units Values| Units Values
       ABC   5     40   |             |
       Def   10    50   |             |

          (Correct o/p)     (Wrong o/p)

                so i want to hide the total data2 part when there is no data in data2
    Thanks
    Vamsi

    Friday, October 26, 2012 3:36 AM

Answers

  • User2105670541 posted

    you need to set the visibility properties of your column for achieving this.

    right click on the column of your matrix >> properties >> visibility >>

    here paas the expression for hidden like :

    =iif(Fields!yourColumn.Value=="",true,false)

    let me know if it doesnt work.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, October 26, 2012 5:36 AM