The grouping problem in Crystal 9

[lana123]

Hi,people!
I have the really complicated Oracle tables on base of which I must create the reports with groups.
This is what I have:
Two different values stored in one field(Name).
We can differ them by their type, which is in another field in another table. The tables link by ID.
I have to make the grouping by one value and put another values in detail section of report.
For example:
Values:
Hospital, camp, school, nursing home stored in Name.
hospital has type:'Agency'
camp,school,nursing home have type 'Division'
These values have to group by value, which has type 'Agency'.
Another values have to be in Details.
The problem is that all these values in one field.
I'll appreciate any answer. Thanks in advance.
Lana.

 

[Turkbear]

Hi, given such a bad design, your only recourse may be to build a view ( or views ) , perhaps by using Oracle's DECODE functions to determine what values appear in what fields, and use the view(s) in your reports.
You could also try building a Stored Procedure that returns a REFCURSOR with the needed data, but that would be much more difficult, with that design.( Who built this beast anyway?)

 

[epergrem]

I have a similar situation with a database that I'm accessing. My solution was to utilize a UNION. The first select where the type=1, the second half where type=2. It solved my problem.