Solved

Peter's solution worked great.  Now I need to roll the results up to show the sub-totals of the records meeting the Group Selection conditions for each DealerID in the Group 1 level.

Posted on 2003-10-24
1
284 Views
Last Modified: 2010-08-05
Comment from anidac
Date: 10/24/2003 12:07AM EDT  Author Comment  

Opps...  I forgot a Group.  It's like this...

GROUP 1: DealerID-1433
  GROUP 2: SiteID-91234
    SiteID      ServiceOrderID         Date Compete      Service Order Type     Status          DealerID       InstallerID
    91234      846541                    01/15/2003          Install                        Complete     1442             5857
    91234      847987                    02/10/2003          Repair                       Complete     1442             5857
    91234      848912                    02/22/2003          Repair                       Complete     1442             5857
    91234      849235                    04/30/2003          Repair                       Complete     1442             5857
        SUMMARY:  Total Service Orders = 4     Install Count = 1      Repair Count = 3
GROUP 1: DealerID-2987
  GROUP 2: SiteID-64567
    SiteID      ServiceOrderID         Date Compete      Service Order Type     Status          DealerID       InstallerID
    64567      845675                    02/10/2003          Repair                       Complete     6459             1987
    64567      845819                    02/22/2003          Repair                       Complete     6459             1987
    64567      866702                    04/30/2003          Repair                       Complete     6459             1987
        SUMMARY:  Total Service Orders = 3     Install Count = 0      Repair Count = 3


 
Accepted Answer from peter57r
Date: 10/24/2003 03:32AM EDT  Accepted Answer  

Create formula field :

@InstallCount
if serviceordertype = "install" then 1 else 0


@RepairCount
if serviceordertype = "repair" then 1 else 0

In the Group2 footer insert summary fields:

Sum(@InstallCount)
Sum(@RepairCount)

In Report(menu) >Selection>Group Selection

if Sum ({@installcount}, {Tablename.SiteId})>0 and Sum ({@RepairCount}, {Tablename.SiteId})>0 then true else false

Pete




 
Comment from anidac
Date: 10/24/2003 12:29PM EDT  Author Comment  

Peter's solution worked great.  Now I need to roll the results up to show the sub-totals of the records meeting the Group Selection conditions for each DealerID in the Group 1 level.  Any Ideas?
 
0
Comment
Question by:anidac
1 Comment
 
LVL 77

Accepted Solution

by:
peter57r earned 250 total points
ID: 9615909
Sorry I've posted the solutoion back in the original thread.

http://www.experts-exchange.com/Databases/Crystal_Reports/Q_20776580.html

Pete
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now