Thursday, August 1, 2013

Page break in ssrs

The following expression, when placed in the group expression, assigns a number to each set of 25 rows. When a page break is defined for the group, this expression results in a page break every 25 rows.

=Int((RowNumber(Nothing)-1)/25)

Steps for adding Page Break in Reporting
Step 1- Remove all the Groupings of the Table.
Step 2- Select the Detail Row(All total Data Row) of the Table -->Right Click.
Step 3- Click on Add Group --> Parent Group.
Step 4- In the Group By Expression
                         Add =Int(RowNumber(Nothing-1)/10) -->OK.
Step 5- Go for Row Group(At the left corner below of the Design View) --> Group Properties.
Step 6- Go for Sorting Properties, Remove the Sort Expression.
Step 7- Go for Page Breaks and check the "Between Each Instance of Group"-->OK.
Step 8- If you dont want the Newly added Column , Select The Total Column -->
             Click on Delete Columns.
Step 9- Select the "Delete only columns" Radio Button from the Dialog Box.

No comments:

Post a Comment