• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

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
0
Genius123
Asked:
Genius123
  • 4
  • 4
1 Solution
 
mlmccCommented:
Depending on the data try this

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
0
 
Genius123Author Commented:
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
0
 
LinInDenverCommented:
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.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
mlmccCommented:
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
0
 
mlmccCommented:
Or building on Lin's idea

Look at the start of the cross tabs

mlmcc
COQ-For-ExpertsRev2.rpt
0
 
Genius123Author Commented:
Thanks for your help.  This will get me started.
0
 
Genius123Author Commented:
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?
0
 
mlmccCommented:
As stated in your other question, I put it in the DISPLAY STRING in the format object

You could just change the formula to have the same information

mlmcc
0
 
Genius123Author Commented:
Thanks mlmcc.
0
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

Featured Post

Free Tool: Port Scanner

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.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now