Matrix and Report Header

  • Hope this is clear for everyone. I've created a simple Matrix report. i want this report to print on legal size paper, landscaped. The issue I'm having is whenever I extend my report workspace pass 3.75", I get a blank page every other page. If I shrink my workspace under 3.75", then I get number of pages without any blanks.

    I wouldnt mind leaving the workspace under 3.75", but I need to add a header and center it. If I leave it at 3.75" and add a header, the header is all the way to the left.

    If I extend it the way I want it and center the header, I get the blank pages again.

    I've adjusted the page setup, selected landscape and legal. Still I get blank pages every other page.

    Anyone else run into this issue? If so, how you resolve this?

    Thanks!

  • When you said you adjusted page setup, is this in the print dialog box, or in the report design view? You need to change it at design time. go to the layout tab. In your properties window select the Report properties. In PageSize, change Width to 14in and Height to 8.5in.

    Then when the report is generated your pages should be contiguous like you want.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • I adjust it in both place, the design view and in print setup.

  • How are you printing the report? Are you using the Reporting Services Print Control or just clicking print from your browser control? Does the same thing happen if you export it to a PDF and then print it?

    Are you using any subreports that may have their own margins/page boundaries? Are you accounting for any margins on the report when you size your report layout? (i.e. with a 14 in wide legal page, is the design surface set to 14" or is it set to 12" with 1 inch margins?)

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • This is what I've done.

    1) Created a report with a Matrix object.

    2) Adjusted Report Properties to print in landscape on legal. Margins all the way around are .50.

    3) When I preview report in Studio, I click on the Print Layout so I can view report as if it was printing on paper.

    That's pretty much it. So the page properties are set to legal and landscape, but still come up with issue.

    However!!! When in Design View, you right-click on the yellow area and click on View-->View Ruler, you get your rules on the side and top, right.

    And you know how you can adjust your Body (the white area) to what ever size you want. When I make the Body 3.75" across, the blank page issue is gone. If I extend it passed 3.75", then I get the blank pages. Dont understand why that is.

    I wish the white area was the size of the paper you choose and not adjustable, just like in CR. (small rant!)

  • Try expanding the yellow area to a width of 13 inches. create the textbox you are using for header and expand it the full 13 inches. Center the text inside the textbox.

    How does it react then?

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply