Answered by:
Page Break after each record in a table

Question
-
IN SSRS 2005 i have a report which has a table with 1 row and 1 collum and i have inserted a sub report in the details section of the table
I want only 1 sub report to be rendered per page when i take a print of it
i am expecting many rows
Thursday, January 6, 2011 10:21 AM
Answers
-
http://img194.imageshack.us/img194/5379/ss1rb.jpg
Vishal Gajjar- Proposed as answer by Tony Chain Monday, January 10, 2011 5:37 AM
- Marked as answer by Tony Chain Friday, January 14, 2011 9:45 AM
Thursday, January 6, 2011 12:02 PM
All replies
-
go to row group properties for which you wan to add page break;
select "Between each instance of a group"
Vishal GajjarThursday, January 6, 2011 11:13 AM -
I dont have any groups in my tableThursday, January 6, 2011 11:44 AM
-
you can select the row header of the table > right click and go to Edit Group > you can select from the two options available in dialog (Page break at start / Page break at End)
Vishal GajjarThursday, January 6, 2011 11:59 AM -
i want a page break for each record in the table
lets say i have 10 records in the table
i want each record in each page
Thursday, January 6, 2011 12:01 PM -
http://img194.imageshack.us/img194/5379/ss1rb.jpg
Vishal Gajjar- Proposed as answer by Tony Chain Monday, January 10, 2011 5:37 AM
- Marked as answer by Tony Chain Friday, January 14, 2011 9:45 AM
Thursday, January 6, 2011 12:02 PM -
Perhaps you can have a text boxes instead of table and wrap all things (textbox,subreport) within a list control....?
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/Thursday, January 6, 2011 12:14 PM -
Hello,
1. Add a group and the group expression should be =RowNumber("Scope") Scope -- TableName
2. Now for that group add page break for each instance.Hope its clear & helpful....
Pavan Kokkula Tata Consultancy Services.Thursday, January 6, 2011 12:27 PM