Post reply

Hidding Reports with a neat layout

  • April 11, 2011 at 4:28 am

    #389246

    Hi All,

    I have a report which contains 4 reports, each in their own table, each with their own dataset.

    Example:

    Page 1 - Report 1

    Page 2 - Report 2

    Page 3 - Report 3

    Page 4 - Report 4

    In order for these reports to be on their own page, i put a page break after the table.

    I also need to be able to hide reports. For example, i might only want report 2 and report 4, in which case, my report should look as follows:

    Page 1 - Report 2

    Page 2 - Report 4

    The problem im having is when i hide report 1 and 3, the layout isnt right. Not only that, i need the hidden reports not to show any evidence of gaps and spaces. The basically the report needs to squeeze up with a neat layout.

    Any ideas how?

    Regards,

    Robbie

  • April 11, 2011 at 6:02 am

    #1309763

    So you have 4 tables on the report, right?

    They're not in rectangles or anything?

    And they're all directly underneath each other (maybe with a few pixels space)?

    If you hide one by setting the visibility property, it shouldn't leave any empty space. As a test try adding a filter to the table instead of setting the visibility property; for example instead of having Hidden =IIf(somethingIsTrue, True, False) add a Filter that =IIf(somethingIsTrue, 1, 0) | Equals | = 0. It will have the same effect.

    The reason being (that I've experimented with before) is that the BIDS viewer and the web viewer and the export options all used to act a little differently regarding whitespace when things were hidden and whether it was hidden with True/False or an expression.

    Are you running SP2?

  • April 11, 2011 at 3:07 pm

    #1310127

    Yes, i have 4 tables each with their own dataset. The are placed directly beneath each other (no spaces), with a page break at the end of each table so when the report runs, they are each displayed on their own page.

    As mentioned, when i try hide tables i get spaces where the hidden tables should be, so the next table is not squeezed into the space of the hidden table.

    Would the use of rectangles help?

  • April 11, 2011 at 6:05 pm

    #1310168

    I don't think a rectangle will help.

    Try the filter I suggested.

    Also try adding a few pixels of space between them. I have seen RS do some odd things when objects directly follow one another.

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

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