Print Page | Close Window

how to prevent subreports from overlaping

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
Printed Date: 24 Sep 2023 at 1:49pm

Topic: how to prevent subreports from overlaping
Posted By: JRCharlie
Subject: how to prevent subreports from overlaping
Date Posted: 14 Oct 2020 at 5:14pm
I have a report with 4 subreports.
These subreports hold the order category and their due dates.
Each Category holds orders for an entire week
I have a page break after each day on each sub report.
I have tried placing the 4 subreports in a group section on the main report but they overlaped, then I created a second group to place c and d but they only show after all the orders of A and B have rendered.
I want to follow the format below and having each day in a seperate page,

Category A       Category B

Category C       Category D


Posted By: kevlray
Date Posted: 19 Oct 2020 at 4:43am
Are each of the sub-reports in their own section.  They should not overlap if they are.

Posted By: JRCharlie
Date Posted: 19 Oct 2020 at 2:59pm
They overlap when I place them on the same section.
I also placed them on seperate group sections, section 'A' and 'B'
subreport A and B side by side in Section 'A' and Subreport C and D also side by side in Section 'B'.
This way it displays all the orders of the fist group for the entire week one day per page than does the same for the second group.
But I would like to display subreport A and B then C and D below A and B printing all one day per page or two if the report is longer than one page

Posted By: kevlray
Date Posted: 20 Oct 2020 at 4:16am
Unfortunately I do not think you can detect if a section is longer than one page other than somehow using the pagenumber function.  Not sure how that would work.

Posted By: lockwelle
Date Posted: 20 Oct 2020 at 5:42am
Since you want only 1 day per page, I would add a parameter the subreports for the day desired. The different sections will help, but it sounds like what you are saying is that subreport A prints 3 days of info and then subreport D is printing those same 3 days, and the data is jumbled (just looking at dates)...

This might require some refactoring so that you can pass the dates that you want to subreports.

It is the only idea the comes to my mind.


Posted By: lockwelle
Date Posted: 20 Oct 2020 at 5:44am
As a follow-up to what kevlray is saying...a subreport is just that, it is a complete report, and it is going to render in full before another report starts rendering.

you can count lines to determine if section is longer than 1 page...and that is only an estimate.


Posted By: JRCharlie
Date Posted: 21 Oct 2020 at 4:01pm
I have an idea, accept if it works I dont know how to do it.
So far the subreports are printing one day per page the only thing is, it prints subreport A and B for the entire week before starts to print subreport C and D.
Now my idea is, could the main report send a date paramater to all the sabreports, this way instead of printing the entire week it would print one day at a time.

Posted By: lockwelle
Date Posted: 22 Oct 2020 at 1:11pm
I will give a qualified yes. If there is a data in the main report that has a date, you could use that.

If you have a date range parameter for the report, you should be able to increment the date and send it to the subreports.

I can see a start date parameter and in a group header keep incrementing it until it is larger than the end date.

It's an idea.

Posted By: JRCharlie
Date Posted: 22 Oct 2020 at 2:53pm
Yes, the same data that exist in the subreport also existes in the main report.
I also was thinking by gouping the date and when the date would change I would pass it to the subreports.
Since I don't have much experience I would need more detail on how to do this.

Posted By: lockwelle
Date Posted: 23 Oct 2020 at 12:09pm
Sounds promising...
I would create a group based on the date.
Then in the group header section for the date, you can call you subreports and link the subreports using the date field in the main report to map to the date parameter in the subreport.

of course you would have multiple group header sections, one for each subreport.


Posted By: JRCharlie
Date Posted: 28 Oct 2020 at 3:15pm
Thank you all for your assistance.
It took awhile but I got it working.
By placing the subreports in groups in the main report, and then by linking the group date with the subreports.

Print Page | Close Window