Quick Tips on SSRS Report Development on Visual Stuido 2013

I just complete couples of SSRS recently. I summarize some of the tips here, please feel free to take them if you think they are helpful.


1. How to show the Report Data Windows on Visual Studio 2013

use  Ctrl + Alt + D from Keyboard or click on the View on the toolbar menu, then select Report Data option.




2. How to add a group total in the report with row group being added.

select the column that you want to add the total based on the same group, then right on the selected column

select Add Total option from the popup menu





 3. Add Group Name or Description on the top of each group
 select the group column, then right click on it, then click on Insert Row, then select Inside Group Above,
then yon add your group name or description on newly added row.




4. Add a line break to the group

select the group column, then right click on it, then click on Insert Row, then select Inside Group Below, then yon can see a new line on each group in the report.


5. Show column header on each report page.

 first we need to enable the advance mode from the column group



second go to the Row Group tab, then select the static



 Set RepeatOnNewPage property to true in the Properties Window