Share via

adobe saves report incorrectly

db042190 1,516 Reputation points
2020-08-22T15:29:44.32+00:00

Hi after some work, my subreport which is just one rectangle enclosing various "sub" rectangles etc looks beautiful when saved to word. But ridiculous when saved to pdf.

the first sub rectangle prints on pg 2 out of order after the 2nd and 3rd sub triangles instead of being kept to together in the main rectangle and showing in the proper order on pg 1. and the last sub rectangle prints at the bottom of the 2nd page after a large gap that if printed correctly is where the 2nd and 3rd sub rectangles would have printed. and then there is a blank 4th page.

are there nuances about adobe that make it non viable or require certain practices in rdl development to make reports saved as pdf work as well as word?

some behaviors in my report include a barcode font in a textbox in the 1st rectangle. 2 side by side tablix's in the 3rd rectangle which also have barcodes in most of the cells in col 1 of each. I dont know what else i can share about my report that makes it so incompatible with adobe.

if memory serves, adobe was acting weird even before i encased all the sub rectangles in one rectangle as i tried to get everything to show on one page. word prints my one page beautifully. its basically 8.5 x 11 with top and bottom margins of .15 in.

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,827 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 33,701 Reputation points
    2020-08-24T06:40:27.427+00:00

    Hi,

    I have set two properties like shown below.

    Note the width and margins:
    【Click on Report > Report Properties > Layout tab (Page Setup tab in SSDT)】
    19787-annotation-2020-08-24-143300.png

    Note the width of the body：
    19812-annotation-2020-08-24-143410.png

    Remember: (Body Width + Left margin + Right margin) < (Page width-1cm)

    And then I set the report property called ConsumeContainerWhitespace to True (the default is false).
    19813-annotation-2020-08-24-143811.png

    Here is my rendering as PDF.
    19814-annotation-2020-08-24-143912.png

    Regards,

    Zoe

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. db042190 1,516 Reputation points
    2020-08-24T14:33:14.4+00:00

    thx that was helpful. before i did that, i did the following which also helped a lot. its tough to say if i would have needed to do both had i done your thing first...

    ...my report originally had one rectangle containing about 4 sub rectangles. and a few loose text boxes too. i combined the contents of the sub rectangles into one rectangle and removed that first outer rectangle. what that accomplished was it prevented sub rectangles 2 and the loose text boxes from jumping outside of pg 1 onto pg2.