Menu
How can I use multiple groups — which are not nested — in Crystal Reports?
A little Example of what I want to do:
-hire car header --rentals header (group) ---rental from 01-02-2008 to 01-06-2008 ---rental from 01-08-2008 to 01-09-2008 ---rental from 01-12-2008 to 01-15-2008 --rentals footer --repairs header (group) ---repair from 02-02-2008 to 02-05-2009 --repairs footer -hire car footer
hire car is the normal report, and rentals and repairs are the groups. The groups are not nested. My current problem is that I can't really create something like that, and I can't change the structure to solve this problem...
I'm totally new to crystal reports.
337
In crystal report, if you want to have two different group, then you have only one option: 1> create one group 2> after that create different sub-reports and in sub-reports insert groups.
Grouping by More than One Field Data will be grouped by that field first. The next field that you select to group by will be the secondary grouping. In other words, Crystal Reports will group your data by the first field you select for grouping, then it will group your data by the second field you select for grouping.
Now place net sales and net revenue in detail and right click and got to insert summary and create summary for all 3 groups. Go to group1 and create a sub section for group 1 using option insert a section below now place group 1 summary there, In the same way acheive all summaries.
That's a good question. I would call that a double one-to-many. You have "hire car" which can have many rentals and/or many repairs.
One solution would be to use two sub-reports for the rentals and repairs.
Another solution would be to union together the repairs and rentals. Then have crystal group on the column that specifies if the row is rental or repair data. You would also have to show/suppress the correct labels, fields, etc. This get's very clunky so your best bet is to go the sub-report route.
181
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
