Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Keeptogether property on Subreport is not working in SSRS 2008 R2

Odpovědět Keeptogether property on Subreport is not working in SSRS 2008 R2

  • Wednesday, March 06, 2013 7:46 PM
     
     
    Sign In to Vote
    0

    I'm facing the page break issue on subreport. Each page may contain more than one record but if the full record is not able to fit into the page then we need to insert a page break and push that record into next page.

    I need to use the sub report becuase of the data relationships. Keeptogether property on sub report is not working. Please let me know if you need more infomration. Thank you for your help in advance!.

    One record contains many field and each page can contain multiple records(rows). Please see the attachment for sample report.
    if row is not able to fit on the page then we need to insert a page break which is not working on suprt report.

    • Edited by Posha Mudam Wednesday, March 06, 2013 7:48 PM
    •  
     

All Replies

  • Thursday, March 07, 2013 9:09 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Posha,

    Based on your description, it seems that you had specify page break in the subreport and when preview the main report, the subreport keep in single page in the main report.
    There is an explicit “KeepTogether” on the subreport. Page breaks defined in subreports are not respected/override the pagination defined in the main report. To work around this issue, you can try to specify the page break in main report.

    If I have any misunderstanding, please let me know.

    Regards,
    Fanny Liu

    Fanny Liu
    TechNet Community Support