Microsoft's Report Builder's Settings?

Jonathan Ratchford 20 Reputation points
2024-01-31T23:42:55.69+00:00

Microsoft's Report Builder only has a certain size when creating a report. If the number of lines or characters exceeds this size, then you are hosed. Is there any way to increase the size?

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,064 questions
SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 41,491 Reputation points
    2024-02-01T02:17:33.3333333+00:00

    Hi @Jonathan Ratchford,

    Margins are drawn from the edge of the physical page dimensions inward to the specified margin setting. If a report item extends into the margin area, it is clipped so that the overlapping area is not rendered. If you specify margin sizes that cause the horizontal or vertical width of the page to equal zero, the margin settings default to zero. Margins are specified using the Report Properties pane, Page Setup dialog box or by changing the TopMargin, BottomMargin, LeftMargin and RightMargin properties in the Properties pane. If you want to override the margin size that is defined in the report, you can specify the margin size using the Device Information settings for the specific renderer that you are using to export the report.

    The area of the physical page that remains after space is allocated for margins, column spacing, and the page header and footer, is called the usable page area. Margins are only applied when you render and print reports in hard page break renderer formats. The following image indicates the margin and usable page area of a physical page.

    See Pagination in paginated reports (Microsoft Report Builder)

    Regards,

    Zoe Hui


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

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 47,441 Reputation points
    2024-02-01T07:06:55.02+00:00

    if the number of lines or characters exceeds this size, then you are hosed.

    I don't understand what you are talking about? You can define any size as you like and if anything looks odd, then because you defined it the wrong way; your fault.

    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.