Append continued in the Group Header SSRS/Power BI Paginated Report

Question

I am working on a report and it requires showing the group name appended with the text "Continued" on the subsequent pages if the group spill over to multiple pages.

Answer 1

Hi @Amar Deep Singh

I found a link for you with a similar question, do you want the way this issue is displayed? Maybe you can use it as a reference: https://learn.microsoft.com/en-us/answers/questions/267904/ssrs-repeating-column-header-appends-word-continue.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Answer 2

Hi @Amar Deep Singh

Absolutely, I did a simple test.

1. Firstly, in the dataset query statement, I group according to color and add row numbers.
2. Then I made the table normally and added the parent group "Color". Remember to add the group header row.
3. Then add an expression in the text box of the group header row. For convenience, we can change the name of the text box to FirstRow.

5. Then we go ahead and add another expression, call the value of the FirstRow text box to compare with the Row in the group.

6. After adding the expression, we can delete the Color group because we have set another group title. Then you need to set the row headers and group headers to repeat both in the new page.

7. If you don't want to keep the Row column, you can also check this column in the column group in the advanced mode and set "Hidden" to "True"

Preview:

Best regards,

Aniya

Answer 3

Hi @Amar Deep Singh

Due to some limitations of printing and pagination layout, the method I provided above may not be the result you want.

Would you mind showing the grouping name on the header? If you don't mind, the following method can be used.

1. Make a report normally, then expand Group->PageBreak in the group properties, set the pagination as follows, and fill in the grouped fields to PageName. This resets the page number when the grouping changes.

2. Add a text box to the header, and then fill in the following expression, call the value of the Color text box and the global variable page number.

Print Layout preview:

Best regards,

Aniya