SSRS Report 2014- Dynamic Image Pagination

GKCarbie 0 Reputation points
2024-03-05T22:55:42.6533333+00:00

I have a report in SSRS 2014 that has Tablix table with dynamic images being populated from a SQL stored procedure (url's).

User's image

When I view the report I can see all the images in the right order... basically ex: Accessible route 1 scrolls all the way to the right till then Accessible route 2 next row.

But when I save to PDF - what happens is it puts 3 images on a row (which is great), the first row is Accessible Route 1, 2nd row is Accessible Route 2, then next page Accessible Route 1, then Accessible Route 2... etc etc. I want them to stay together- so it would be Accessible Route 1's on however many pages it needs to be, then go to Accessible Route 2.

I have Keep together set to True. Is there some setting for this to come out correctly?User's image

Column Group properties: =rownumber("Details")

User's image

Thank you!

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

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2024-03-06T06:39:04.0533333+00:00

    But when I save to PDF

    There are several limitation on export to files, especially in SSRS web view you can have an "unlimited" interactive size, while in PDF you always have a limited printable size.

    See Export a paginated report to a PDF File (Report Builder)

    1 person found this answer helpful.
    0 comments No comments

  2. ZoeHui-MSFT 41,491 Reputation points
    2024-03-07T02:37:44.35+00:00

    Hi @GKCarbie,

    It will have limitation when you export the report to Pdf in SSRS.

    You may try to put the Tablix table into a rectangle to see if it is helpful.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.