Post reply

How do I set a page break to get exactly 6 tables per page on a tabular report? -- pics included!

  • November 27, 2009 at 5:16 pm

    #214408

    Tabular report, I've got 6 tables I'd like to show up on 1 page. I created the report using the <property> value as the page header. I checked the box "fit into 1 page if possy...", but I'm still taking up 2 pages for each <property>. First page shows the page header and 3.5 of the tables, the following page has the last 2.5 tables. How do I manually set the page breaks for this?

    Thanks!

  • November 27, 2009 at 5:33 pm

    #1085059

    I should be more clear...

    When I preview the report in the Report Designer, AND via the web, the 6 tables split into 2 pages. If I export the web version to excel, all the data shows up on one tab as desired.

    Further, I've already tried setting the page height to 25 and 100in to no avail.

    I guess my new improved question would be "How do I get the data to display correctly on the Web and (ideally) in the Preview Pane in the Report Designer?"

    Thanks!

  • December 4, 2009 at 11:08 am

    #1087911

    Hi.

    You can have a try of RAQ Report. With it, you only need to set it in the dialog box as shown below:

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

  • December 6, 2009 at 8:46 am

    #1088265

    Hi

    Simple answer: Set the InteractiveHeight = 0 (SSRS 2008: expand Interactive size, set Height = 0)

    Accessible only through the properties pane. In BIDS use view properties window. To pop up all properties.

    Using the report properties button only shows (printable page sizes).

  • December 6, 2009 at 8:49 pm

    #1088341

    That's what I needed Kees. Did the trick. THANKS!

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

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