data into mult. groups?

[canine]

Is it possible to create groups and have the data you are reporting on reside in more than one group. For example a report which details "new", "ongoing", and "closed" cases over the period of a month. A new case opened in the given month is either closed or still onging at the end of the time period. So that case would be in at least 2 groups, new, and either ongoing or closed.
I have created formulas which determine if a case has been created, closed on still ongoing during the given time period. I then assigned the following values to each formula (assigned a 0 if false):
new true = 4
closed true = 2
ongoing true = 1
Then added these numbers together which formed unique combinations (6 = new and closed, 5=new and ongoing, etc.)
Next I created a new group sorted on the value of all these numbers added together and sorted it in "specified order" in which the groups had multiple values( new = 4, 5, or 6; closed = 2 or 6, etc)But Crystal reports still appeard to only sort each case into only one group, even though the values the case have should place it in multiple groups. For example a new case closed in the give month has a value of 6, which should place it in both the new and closed groups, by the definations of each group.

I was hoping to avoid sub-reports. Is this possible?

Thanks in advance,

 

[rogar]

Every detail row in your report corresponds to one and only one record in the source data set. If you want a case record to appear more than once, you will have to either write a query that selects records multiple times or join multiple instances of the source table.

Subreports may be your best solution.

 

[chelseatech]

I'd echo rogar's suggestion.

Use a UNION join to create three records out each record out your original data, and have a new field which can have the value "New", "Ongoing" or "Closed" (with correctly selected records for each value). Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[kenhamady]

One alternative is to use subreports to select each group separately.

Or in some cases you can 'force' extra records by linking to a to an 'inflation' table. This technique is described in an article in a recent newsletter:

http://www.kenhamady.com/news0111.html

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[canine]

I just started using Crystal Reports and I appriciate all of your help.

Thanks.