April 11, 2011 at 4:28 am
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
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
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
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