Comparing subreport elements 1

[AvgMoJoe]

Scenario: I want to compare subreports for consistancy across multiple organizations.

Each Org has multiple ExamCodes. ExamCodes are consistant across Orgs (each have uniqueID though). Each ExamCode has multiple Charges. These should be consistant, but I know some are not.

I want to make sure that ExamCode 'ExamX' at Org 'OrgA' has the same charges as ExamCode 'ExamX' at Org 'OrgB' and Org 'OrgC'

I would like to display only those ExamCodes with ChargeCodes which are discrepent.

<group = ExamX>
OrgA ExamX
Charge1
Charge2
OrgB ExamX
Charge1
Charge2
ChargeZ

 

[lbass]

Please explain why you are using subreports. Are you working with more than one table? What are they?

Where are the subreports located (what report section?)?

-LB

 

[Madawc]

I'd suggest another subreport. Access all of the ExamCodes for all the Orgs. Group by ExamCodes. Suppress group header and details. Show the group footer if the minimum and maximum for a particular charge are not the same.

You could do something with Shared Variables, but they are inconvenient if you have a lot of data.

As lbass says, best to avoid subreports when you can. But it's not possible to avoid them if you want to group the same data several different ways and Crosstab is not suitable.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[AvgMoJoe]

(Crystal 9)

2 Tables -
A view of All ExamCodes with corresponding Orgs
and a linked table (by ExamCode) of Charges

 

[lbass]

Please answer ALL questions. Thanks.

-LB

 

[AvgMoJoe]

Oops sorry. I think I may be approaching it from the wrong angle. Currently I had an Exam report with subreports for ChargeCodes for each exam. I could instead grab both tables in a main report and use grouping. Just trying to figure out how to show only those exams from different orgs where the charge codes do not match.

 

[AvgMoJoe]

I think I may have found a solution here:

http://www.oreillynet.com/pub/a/network/2002/04/08/compsets.html

 

[lbass]

You could link the tables by exam code and then group on exam code and organization and then go to report->selection criteria->GROUP and enter:

distinctcount({table.charge},{table.examcode}) <> distinctcount({table.charge},{table.organization})

This would return those organizations with missing charges, instead of those with "extra" charges, but would at least show the exam codes where there are discrepancies.

-LB

 

[AvgMoJoe]

Now that worked like a charm!