SubReport1 overlapping SubReport2

[ccding]

CRXI; SQL Server;
I have a main report with about 4 subreports.
How can I place SubReport1 above SubReport2 without having the items in SubReport1 overlapping into the place of SubReport2. (Without inserting a new section) ??
I have 'Can Grow' for all SubReports;


Sample Report:

SubReport1 SubReport3 Subreport4
--data-- --data-- --data--
SubReport2
--data--

Thanks !

 

[synapsevampire]

Why not insert a new section below?

Can't understand why you'd object to this, it works the same way and solves your problem.

-k

 

[ccding]

Thanks K for you reply !
Ahh, good point,, however ...

If I insert a new section below... then how do I fix the problem when Subreport 3 or Subreport 4 grow to variable lengths? The section with SubReports1, 3, and 4 grow to the necessary length. So when Subreport 4 reaches its end, then the next section begins. Thus creating a huge gap - (Subreport1 and SubReport2) need to flow in the same vertical alignment without a break in space. So keeping SubReport 1 and Subreport 2 in the same section is necessary.
I hope that made sense of why I can't use another section?

 

[synapsevampire]

Yep, and there isn't a solution I can think of other than eliminating some of the subreports.

Consider doing a UNION ALL query in the subreport 1 and 3 to resolve this.

-k

 

[ccding]

thanks k - but would I still have the same problem with SubReport 4?

 

[synapsevampire]

There wouldn't be a subreport 4.

It's data would be displayed via the UNION ALL in sub 3.

-k

 

[ccding]

oh right -- sorry about that one !


Thanks K !

 

[lbass]

I think you could insert three sections. Place Subs 3 and 4 in section_a, sub 1 in section_b, and sub_2 in section_c. Format section_a to "underlay following sections".

-LB

 

[ccding]

That's Great!! I think that will work!!
Thank you both for your kind help !!