Thursday, September 6, 2012

SSRS General tips


#. Adding Toggle (master level) as Param

     I see many reports have toggle. It will be useful to have as a parameter, to expand all toggle sections. This is apart from each section toggling.

     Have a parameter as "ToggleAll" as boolean and with default as false.

    In every textbox that has toggle functionality, use some what like ...
           
                                =Parameters!ToggleAll.Value
               

     For Table Row
               
                  
                =Not (Parameters!ToggleAll.Value)
                textbox111
            
                 

No comments: