Crystal Reports Forum : Report Design

how to prevent subreports from overlaping

Wed, 28 Oct 2020 15:15:37 GMT

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.

Edited by JRCharlie - 28 Oct 2020 at 3:17pm

how to prevent subreports from overlaping

Fri, 23 Oct 2020 12:09:22 GMT

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.

HTH

how to prevent subreports from overlaping

Thu, 22 Oct 2020 14:53:18 GMT

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.

how to prevent subreports from overlaping

Thu, 22 Oct 2020 13:11:20 GMT

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.
HTH

how to prevent subreports from overlaping

Wed, 21 Oct 2020 16:01:52 GMT

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.

how to prevent subreports from overlaping

Tue, 20 Oct 2020 05:44:16 GMT

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.

HTH

how to prevent subreports from overlaping

Tue, 20 Oct 2020 05:42:19 GMT

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.

HTH

how to prevent subreports from overlaping

Tue, 20 Oct 2020 04:16:37 GMT

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.

how to prevent subreports from overlaping

Mon, 19 Oct 2020 14:59:59 GMT

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

how to prevent subreports from overlaping

Mon, 19 Oct 2020 04:43:52 GMT

Are each of the sub-reports in their own section. They should not overlap if they are.