Can you tie sections together in an SSRS report?

See more:

SQL-Server

SSRS

Hi SQL2012 and SSRS

I have a dataset for a report with 14 sections. Each section merges data from the dataset.
The dataset has flags which state if a section is hidden or shown.

Thats the first problem. We need to hide the whitespace when the section is hidden.


Also, section 8 is a footer and should always be at the foot of the page when it is shown. Section 7 is tied to section 8, so it always appears just above section 8 (if it shown).

Section 1 is tied to the header. Section 2 tied just below Section 1... and so on.

As an example You could have Section1, then section 2 at the top of the page, a big gap then section 7 then section 8 at the foot of the page.

Is this possible to do and how? any help is appreciated!

thanks

Arf