Creating Groups that are not mutually exclusive

[Michelle770]

Is there a way to create a group within CRYSTAL 8.5 and have the group not be mutually exclusive, hence data can show up in more than one group?

If it is not possible with the grouping functionality any hints on how to accomplish this would be great.

Thanks
Michelle770

 

[Turkbear]

Hi,
What are you trying to accomplish?
The concept of 'Grouping' implies a uniqueness of the 'Group By' item so having something that 'belongs' to multiple groups may be difficult to construct..
You could try creating a group based on some formula that would somehow allow this, but, offhand, I don't see how.

What do you want to do with this technique? Perhaps there is another way ( like sub-reports maybe?).

 

[Michelle770]

I am trying to display summary data. The summary data is not unique to the groups in which they are being displayed. Hence some data can belong to more than one group.

For example:
Product #1 is a priced product. All priced product contain two price components. Let's call them comp1 & comp2

Product #2 is an unpriced product. All unpriced products contain one price component. Let's call it comp1

Now I want to display two groups. One group with everything that has comp1 and one group with everything that contains comp2.

The current challenge is once product 1 shows up in one group it will not show up in the other group.

One way to accomplish this is to create several sub-reports and attach the sub reports. Since this is a very big report which takes a tremendous amount of time to run I was trying to accomplish this with only one sub-report. Open to any suggestion....

 

[Turkbear]

Hi,
Sorry but more info is needed:

What is the Group being built on?

How do the Products and their comp1 and comp2 fields
relate to the group item?

Perhaps a description of the table(s) involved and, if more than one, the relationships between them would help.

 

[Michelle770]

First, I want to thank you for looking into this for me. I really appreciate your time :0)

I am actually building the report off of a view. Every product can have many price components. They can have as many as 6 different components. Each product will have at east one component attached.

In the actual report I am trying to group by price component and display each product that has that component. The challenge is one product could be in all six of my groups.

 

[Turkbear]

Hi, I suspect that to do this, the views need to be built so that the Products are identified in such a way that they appear to be different, depending on the existance of multiple price components for that product.
Perhaps aliasing them in a UNION join could do this..?

 

[JohnEck]

Do you have a column for each compnoenet or is each component a seperate record with a clomn designating the price component. If the latter is the case use a cross tab report using the component colomn as the column grouping. That way if it has one component only one value shows up in the cross tab. I will give you a total and a breakdown of the components of the price.