Repeating separate report elements on each page (image, textbox, tablix)

Tunkkari 21 Reputation points
2022-06-28T10:15:59.247+00:00

Hello,

I need to repeat certain report element on a report on each report page. The elements are an image, a few text boxes and a tablix.
After experimenting a little based on the information I found and trying to scram all these elements into a table, I think the best solution
is to create a separate subreport with the required elements and add the subreport into a single column table.
Then somehow configure the table containing the subreport to repeat on each page.

Does this sound like a reasonable solution or does anyone have a better, more convenient one?
How should I implement the repeating of the table on each page? Using grouping, somehow?

In my initial table approach, I tried the solution over here, but couldn't get it to work: https://social.msdn.microsoft.com/Forums/en-US/65c9299a-767c-4dd2-8d36-633d84cf173d/ssrs-repeating-information-on-all-pages

Best regards,

Tunkkari

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,989 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Isabellaz-1451 3,616 Reputation points
    2022-06-29T01:08:24.443+00:00

    Hi @Tunkkari

    There is a easy way,you only need to set the ‘RepeatWith’ property of the item(image or textbox) you want to repeat.
    215902-image.png

    And about the tablix repeat,I think it is a wonderful idea to insert subreport on the tablix header , because it can merge data from different dataset, we know that when in one tablix ,only one dataset can be used. I have tested this method ,it works.

    My steps are as below ,you can take a reference :

    1. prepare the subreport ,upload it to the report server
    2. prepare the current report , merge all the tablix header,and then insert the subreport ,
    3. next is to repeat the subreport ,I open the advanced mode
      215847-image.png

    then select Static on row groups ,set RepeatOnNewPage = true
    215944-image.png

    At last ,preview,the subreport is successfully repeated on each page

    Best Regards,
    Isabella


    If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    0 comments No comments

  2. Tunkkari 21 Reputation points
    2022-07-04T16:01:20.09+00:00

    Thank you for the reply, @IsabellaZhangMSFT-7746

    I'm on SQL Server reporting services 2014. Forgot to mention that.

    As I have several tablixes already on the report, I tried the following, but wasn't able to get the tablix to repeat to second page:

    Here's the Tablix I modified. I enabled the "Advanced mode" and set the "KeepWithGroup" to After and "RepeatOnNewPage" to True for all the static rows under my "table1_details_group" -row group of the tablix.

    See the screenshots below.

    217395-image.png

    217406-image.png

    217435-image.png

    I first render the report in HTML format, where I only get one page. These reports are used in the PDF format, though. So when I render the report in PDF format, I do get two pages, but
    the tablix I modified above, does not repeat to the second page.

    I didn't try the subreport approach yet, because I thought it would be more convenient to just modify the existing tablixes to repeat to the second page and then take all the other required elements to the second page with a tablix using the RepeatWith -functionality.

    Can you think of anything what's keeping the tablix from repeating to the second page?

    Best regards,

    Tunkkari


  3. Tunkkari 21 Reputation points
    2022-07-05T11:02:39.26+00:00

    Hi @IsabellaZhangMSFT-7746 ,

    I'm just not getting this to work and I'm totally out of ideas. This is what I've tried:

    1. I created a tablix for the subreport, that I want to be repeated to all pages. I then merged all the columns in the table and deleted the group which was automatically created in the tablix.
    2. I placed the subreport in the only row inside my tablix (see the screenshot below at the top of the image). 217696-image.png
    3. I turned on the Advanced mode in the Grouping pane and set "KeepWithGroup" to After and "RepeatOnNewPage" to True 217678-image.png
    4. When I render the report, the lowermost tablix at the bottom of the report is pushed to a second page, but nothing else. I can't get the tablix with the subreport, located at the top of the page, to repeat on the second page no matter what I try. The subreport doesn't appear there in the HTML rendering of the report OR the PDF rendering.

    Best regards,

    Tunkkari

    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.