Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT
Course Of The Month
10 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Crystal Reports Grouping
Posted on 2011-09-26
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
[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
- Learn & ask questions
4-
4
9 Comments
Active today
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
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
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.
![[Webinar] Learn How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/21/e0b7778f-e79e-4b5d-9ec6-5496e40be42e.png)
Active today
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?
Featured Post
![[Webinar] How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/20/3315d9d8-8110-4d52-be94-a5aacdd83e4b.png)
Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT
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…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 3 hours left to enroll
624 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.