Share via

Problems creating documents/letters in SSRS

Steeena 1 Reputation point
2021-12-15T20:04:36.49+00:00

I have created a Violation Letter and Administrative Citation Letter in SSRS report builder. I can not seem to get the margins right. I've look everywhere online and different forums but can't seem to find anything on letters/document building in SSRS. Can anyone point me in the right direction to get some knowledge on this?

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.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,651 Reputation points
    2021-12-16T06:12:04.507+00:00

    Hi @Steeena
    Unfortunately, you need to manually set report properties in SSRS. You could also use the extended tools in Microsoft Dynamics 365 Finance to create a custom report design, and then import the model in visual studio. Please see: Create custom designs for business documents.

    In SSRS, we can adjust the layout by changing the page settings in the report properties. The following links will help you understand "the physical page size" and "The Report Body"
    And the concept of "Margins". Please see: Pagination in paginated reports (Report Builder).

    It is worth mentioning that, although your report can be perfectly rendered when previewing, there may be deviations when you export the report. This is due to different rendering effects caused by different rendering extensions.When you run a report on the report server, the report uses the HTML renderer. HTML follows a specific set of pagination rules. If you export the same report to PDF, for example, the PDF renderer is used and a different set of rules are applied; therefore, the report paginates differently. To successfully design an easy-to-read report for your users that is optimized for the renderer that you plan to use to deliver your report, you need to understand the rules used to control pagination in Report Builder. For more information, please see: Rendering behaviors in a paginated report (Report Builder).
    Using Page Size and Interactive Size to Manage Printing.

    Best Regards,
    Joy


    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.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.