Your question, your audience. Choose who sees your identity—and your question—with question security.
Crystal Reports Grouping
Hi,
I need to group something a certain way and just can't figure it out. Here's what it's doing now:
Total apples sold monday = 30
Red = 15
Green = 15
Total apples sold Tuesday = 50
Red = 20
Green = 30
--------------------------
I need it to do this:
Total apples sold monday = 30
Total apples sold Tuesday = 50
Red = 35
Green = 45
Thanks,
Joel
I need to group something a certain way and just can't figure it out. Here's what it's doing now:
Total apples sold monday = 30
Red = 15
Green = 15
Total apples sold Tuesday = 50
Red = 20
Green = 30
--------------------------
I need it to do this:
Total apples sold monday = 30
Total apples sold Tuesday = 50
Red = 35
Green = 45
Thanks,
Joel
Asked:
4-
4
1 Solution
That didn't seem to work. Basically, I'm trying to get Group 2 (by department) to go right below Group 1 (by date). Do you mind if I send you the file? I'll attach it. You'll see that my example was just an example and what I"m doing is more involved. COQ-For-Experts.rpt
Is your output flexible? If so, you might want to consider a couple of cross tabs. One cross tab giving totals by Date (grouped by Day if asked), and then a 2nd one giving totals by Color.
This does seem to really be a cross tab but it may not work well because the columns are all different.
Look at the attached report
Changes are in RED
mlmcc
COQ-For-ExpertsRev1.rpt
Look at the attached report
Changes are in RED
mlmcc
COQ-For-ExpertsRev1.rpt
In the report example posted on 09/26/11 06:33 PM, ID: 36656043 , I can't figure out how you got the column header in the cross tab to show the headers. Can you help me? Should I start a new post?
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
I assume you have a formula that determines the apple color for the counts
Suppress the detail and group footers
Put summaries of the color counters in the report footer
mlmcc