Page break before group footer

Jean-François Handfield 101 Reputation points
2020-11-11T16:33:37.597+00:00

Hello,

Here's what I'm trying to accomplish. I need to have on one page the names of the different person living at one address and on the second page a form that the could fill. Right now I can't figure where to put the page break to have my form on the second page, by the way this is going to be printed and . I'll post some screenshot of my setup. On my report I have a body section containing a list view with 3 sections : I have a group header, that contains my address that I make my group by, a detail section with the names of the residents, if more then one, and a group footer with my form to fill. Everything is fine but I can't figure out how to make my form on the second page after the detail of my resident.

39155-groupby.png
39133-groupby2.png

Thank you for the help

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,915 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,576 Reputation points
    2020-11-12T07:29:29.777+00:00

    Hi @Jean-François Handfield
    From you pic, I think the group you refer is row group ?
    Right click the last section of the structure, I think you would get rectangle property. Then , check the add a page break before to have the page break as you want.  
    39281-01.jpg
    Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Jean-François Handfield 101 Reputation points
    2020-11-17T18:19:42.967+00:00

    Sorry for the late reply. For some reason your answer but yet again it doesn't work on my report. What I managed to do is resize my form and play a bit with my detail size section and like magic it moved on the second page and it seems consistent. But honestly I have no clue why your solution didn't work. There might be something I'm doing wrong or I don't understand the basic on how to setup a proper report in SSRS.

    Anyhow, thank you for taking the time to reply bacck on my problem. I'll mark this question as answered.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.