Share via

Trouble-shooting subreport rendering

Timothy Linward 1 Reputation point
2022-01-19T16:57:01.943+00:00

I'm working on reports in ProMonitor, a student information database that has a module which can generate, import and render RDL files to display data. It's possible the issue I'm going to describe is due to ProMonitor rather than something that's innate to RDL files, but it has rendered everything else I've thrown at it from report builder and I'd like to eliminate human error.

The subreport contains a tablix with two columns. The body of the report is 5x1cm, the page size is 6x2cm, the margins and the body add to less than the page size, which is the main issue I've read about causing subreports to display to the wrong size.
The main report contains a tablix, and the subreport is in the rightmost column in the main data group of the tablix.
When I run the report, the cell containing the subreport gets inflated out to the right, as if there's another empty column in the subreport, or the body size of the subreport is much larger than it should be. The subreport data gets loaded correctly and even in the right location: the whole thing could fit on one page but it's rendering with much greater width, creating a horizontal scrollbar when viewed online or spilling to a second page when downloaded to PDF or word.

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,878 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,571 Reputation points
    2022-01-20T02:28:00.717+00:00

    Hi @Timothy Linward ,
    I did a test locally and when I insert a subreport in the second column in Tablix, the right side of the subreport cell is rendered with too much white space.

    We could switch to a subreport and change its rendering behavior in the main report by resizing the subreport's report body. Switch to the subreport, and in the property bar, set the Size of the report body. Make sure the subreport is in the report body.

    Report Body Properties of Subreport:

    166509-body-properties-of-subreport.jpg

    Then we switch to the main report, at this time preview, the subreport cells render normally.

    Best Regards,
    Joy

    If the answer is the right solution, please click "Accept Answer" and kindly 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.