• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • 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
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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