Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Force new page for each record
- Thread starter TimTDP
- Start date
HandsOnAccess
Programmer
You need to use Group By Option on a unique field in the record.
In report design View
Click on "View" Menu
Click on "Sorting and Grouping"
In the "Sorting and Grouping" Dialog, Choose one unique field under "Field/Expression" Option
In "Group Properties", Choose "Yes" for "Group Footer" Option
Close the "Sorting and Grouping" Dialog
In the report desing view, you will see <<Field Name>> Footer grey bar near the bottom of the report page
Double Click on <<Field Name>> Footer Grey Bar
"Property" Window Pops Up
In "Format" tab of the "Properties" Window, the very first option is "Force New Page", whose default option is "None"
Set this Property to "After Section"
Close the Property Window
Save and View the Report.
Let me know how it goes...
Regards
In report design View
Click on "View" Menu
Click on "Sorting and Grouping"
In the "Sorting and Grouping" Dialog, Choose one unique field under "Field/Expression" Option
In "Group Properties", Choose "Yes" for "Group Footer" Option
Close the "Sorting and Grouping" Dialog
In the report desing view, you will see <<Field Name>> Footer grey bar near the bottom of the report page
Double Click on <<Field Name>> Footer Grey Bar
"Property" Window Pops Up
In "Format" tab of the "Properties" Window, the very first option is "Force New Page", whose default option is "None"
Set this Property to "After Section"
Close the Property Window
Save and View the Report.
Let me know how it goes...
Regards
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question