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.
=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