In SSRS reports you can easily determine which table columns are visible by default. Not everyone knows that you can give user possibility to choose which columns should be visible.
Using “Lookup” function in SSRS you can combine data from two datasets in one table.
To set alternating row colour you need to:
Select the row you want to change the height of. With that row selected bring up the properties pane (Alt+enter if you don’t see it). Scroll down to the position group of properties and specify the width and height there. The “cangrow” and “canshrink” properties are useful too sometimes.
All you nedd to do is set Hidden property of control to expression:
If You want to break line, put & vbcrlf & in textbox expression
=”Issue list:” & vbcrlf & Parameters!pListName.Value
If you want to sort dataset/tablix using parameter follow these steps: