Group results of an Array

[jemsmom]

I’m using Crystal XI with Oracle 10g

I need to create a summary report of the total number of procedures done in combination or as a single procedure. I’ve read several postings on arrays, but can’t figure out if I can group by the results.

The procedure data looks like this:

PatientID Procedure
34814 PHACOEMULSIFICATION
35002 PHACOEMULSIFICATION
35002 TRABECULECTOMY
35844 PHACOEMULSIFICATION
39432 TRABECULECTOMY

I need the summary to look like this:

Procedure Count
PHACOEMULSIFICATION 2
PHACOEMULSIFICATION, TRABECULECTOMY 1
TRABECULECTOMY 1

Thank you.

 

[Madawc]

I don't think you can in Crystal. Not if you have a large number of groups: if the number is small, you might manage it with running totals.

With Crystal + SQL, you could write an SQL Command that would collect and classify the data. For Oracle I'm not sure.

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

 

[lbass]

You can't group on a result like that, since you would need to use a variable to accumulate the values across records in order to display the result. You could, however, use additional variables to collect the count of instances of these results and then display the counts in the report footer.

-LB

 

[jemsmom]

Thank you lbass for your reply. I'm not sure how to set up the variables to collect the count of instances, off hand do you know of an existing thread I can refer to as an example?

 

[lbass]

Just do an advanced search on arrays. I have trouble with arrays, so can't respond right now.

-LB

 

[RCA147]

I may have got the wrong end of your problem, Looking at this from a very simple perspective....but if you can use a group..then that might work...Suppress the details and just show the groups...

Or use a Cross Tab...where the Summarised field is the count of the Array details.....I have not tried it but it seems logical to me.