Print Page | Close Window

Problem with Underlay Following Section

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20886
Printed Date: 19 May 2024 at 12:18am


Topic: Problem with Underlay Following Section
Posted By: LaurenNY
Subject: Problem with Underlay Following Section
Date Posted: 15 Jul 2014 at 9:31am
I am have a report with a section in a group that contains a subreport. I need that subreport to show beside the details section as if two columns. I set the "Underlay following Section" option and this works great as long as the subreport is not multiple pages. If the subreport spans multiple pages, the details section will not show up until the last page of the subreport. I need both to always show at the beginning, side-by-side. Any suggestions or ideas would be greatly appreciated!

I am using CR 2011.

Thank you,
Lauren


Replies:
Posted By: DBlank
Date Posted: 15 Jul 2014 at 10:12am
try:
right click on the sub report
select format sub report
select common tab
uncheck (false) 'keep object together'
 

Posted By: LaurenNY
Date Posted: 16 Jul 2014 at 2:14am
Originally posted by DBlank

try:
right click on the sub report

select format sub report

select common tab

uncheck (false) 'keep object together'

 


Thanks for the suggestion, but unfortunately that is how I already have it setup.

Posted By: DBlank
Date Posted: 16 Jul 2014 at 4:13am
not seeing another solution for this but that does not mean one is not available...
other approach is to create side by side sub reports in the same section.

Posted By: LaurenNY
Date Posted: 16 Jul 2014 at 5:55am
Thank you for your help. What you suggested does work, however, I added in the underlay to fix another issue I was having. Maybe if I explain my initial issue someone will have an alternative to using underlay.

I have a 2 column report using subreports. Below is how I originally had it laid out:

GH1a->
    Sub Report 1                 Sub Report 2
GH1b->
                                 Sub Report 3
GH1c->
                                 Sub Report 4
GH1d->
                                 Sub Report 5

Having it formatted this way, causes Sub Report 3 to NOT print directly underneath Sub Report 2, when Sub Report 1 is longer than Sub Report 2. Basically there is a big gap, which is not desired. I need to have sub reports 2-5 flow one after another without any gaps.

Report output without using underlay:
Sub Report 1 Detail 1           Sub Report 2 Detail 1
Sub Report 1 Detail 2           Sub Report 2 Detail 2
Sub Report 1 Detail 3           Sub Report 2 Detail 3
Sub Report 1 Detail 4
Sub Report 1 Detail 5
Sub Report 1 Detail 6
                                Sub Report 3 Detail 1
                                Sub Report 3 Detail 2
                                Sub Report 4 Detail 1
                                Sub Report 4 Detail 2
                                Sub Report 5 Detail 1
                                Sub Report 5 Detail 2

I need to have it output as follows:
Sub Report 1 Detail 1           Sub Report 2 Detail 1
Sub Report 1 Detail 2           Sub Report 2 Detail 2
Sub Report 1 Detail 3           Sub Report 2 Detail 3
Sub Report 1 Detail 4           Sub Report 3 Detail 1
Sub Report 1 Detail 5           Sub Report 3 Detail 2
Sub Report 1 Detail 6           Sub Report 4 Detail 1
                                Sub Report 4 Detail 2
                                Sub Report 5 Detail 1
                                Sub Report 5 Detail 2


When laying it as follows, I get my desired output until Sub Report 1 goes to a 2nd page.

GH1a-> (Underlay following sections is checked
    Sub Report 1
GH1b->
                                 Sub Report 2
GH1c->
                                 Sub Report 3
GH1d->
                                 Sub Report 4
GH1e->
                                 Sub Report 5

I hope this all makes sense. Again thank you for your help.


Print Page | Close Window