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
283 Views
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

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)

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
Question by:anidac
1 Comment

LVL 77

Accepted Solution

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

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. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…