Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Crystal Reports Grouping

Posted on 2011-09-26
Medium Priority
293 Views
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
Question by:Genius123
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 4
• 4

LVL 101

Expert Comment

ID: 36600859
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

Author Comment

ID: 36600959
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

LVL 14

Expert Comment

ID: 36601173
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

LVL 101

Expert Comment

ID: 36648310
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

LVL 101

Accepted Solution

mlmcc earned 750 total points
ID: 36656043
Or building on Lin's idea

Look at the start of the cross tabs

mlmcc
COQ-For-ExpertsRev2.rpt
0

Author Closing Comment

ID: 36710906
Thanks for your help.  This will get me started.
0

Author Comment

ID: 36714581
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

LVL 101

Expert Comment

ID: 36717354
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

Author Comment

ID: 36718037
Thanks mlmcc.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customerâ€™s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. â€¦
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirementsâ€¦
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as formâ€¦
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increasedâ€¦
###### Suggested Courses
Course of the Month4 days, 19 hours left to enroll