locked
Page Break after each record in a table RRS feed

  • 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 Gajjar
    Thursday, January 6, 2011 11:13 AM
  • I dont have any groups in my table
    Thursday, 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 Gajjar
    Thursday, 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