crystal-reportscrystal-reports-2008
I've got group: header and details section in subreport. The problem is: when the group is in the bottom of the page it make the gap – header is in the one page and deteis are in the next one. How to keep together both sections?
I've tried following:
Group Expert->Options-> Keep Group Together
It doesn't help.
And in this link, method two.
http://www.microassist.com/tips/crystal-reports-prevent-orphaned-group-header
But it doesn't help too.
Thank you for help.
Some more information about your data sources may help. Without that, I'll assume your data source is a single table with a Grouping field and a primary key.
Crystal thinks in terms of records, and without a record (even if it's just a placeholder), Crystal has no way of knowing a group exists. So the trick is to make a Helper/Index table and left join onto it.
Example: You want to group all your data by month, but you have no data for March. In your datasource (or possibly some other datasource. Crystal is versatile enough), add a Helper table that has 1 column with all 12 months listed. After you import this into your report, you can outer-join your real data table onto it. This gives you all of your actual data with a placeholder record for March.
What other questions do you have?
You have to reduce the whitespace in the details area [at Design Mode].
Every row gets the height of the details area, so that area should only be one row high.
Edit: Make the report footer the same as the details section, but without any data fields. This way the report will be filled from end of data to beginning of page footer if (when) the datarows does not fill up the last page.
Best Answer
This link that you posted helped me.
http://www.microassist.com/tips/crystal-reports-prevent-orphaned-group-header
Right click the group you don't want to be orphaned and choose change group then a small pop-up window opens, click options then check the Keep Group Together checkbox.
GoodLuck!