Page break within a group(s)

Question

I have a report that uses a group that contains three parts, a details part, a blank lines part, and a totals part.

What I am attempting to achieve, is to produce the report so that there are page breaks within this group. The page breaks should happen after each part.

I have been able to achieve the desired look by adding a group for each part, with an additional 'blank' group to provide a page break between the Details Part and the remaining 2 parts. 

This, however has left me with 3 issues;

1. Throughout the report, there will be pages with only the heading and no details.
2. There are pages that show 2 headings (one for the ending detail group and the other is for successive detail group)
3. How to remove the headings for the blank lines part and totals part (which is now on their own separate pages) 

The major pain point for me is issue #3. Anyone able to offer suggestions with the amount of information provided?

Answer 1

Hello,

Based on your description, you have three part in one group. You have add page break between each part. You have mentioned that the heading will repeat in each page. You have set the tablix repeat headers on each page, right?

Since you have blank line part in the group, when we add page break between each part, we will get a blank line page. When we have set the heading will repeat in each page, we would also have repeat page header in blank page.

Now, what your requirement is not get the repeat header in the blank page and total page, right? Please refer to the following steps below:

1. Cancel the headers repeat in each page configuration.
2. Add a total row before of the detail group. Change these text box values with headers values.

Please refer to the screenshot below:

If there are any misunderstanding, please feel free to let me know.

Regards,
Alisa Tang

If you have any feedback on our support, please click here.

---

Alisa Tang
TechNet Community Support

Answer 2

OK, i'll give this a try and post the results. Thanks so much!!