Crystal Report 2011 Grouping

[former_member217682]

Hi Guys,

I'm trying to create group reports but i'm having problem sorting them properly.

i have 3 different groups.

Group A, Group B and Group C

i want the report to appear like this-

Group A

Group A

Group A

Group B

Group B

Group B

Group C

Group C

Group C

But my report doesn't seem to appear like that. My report is showing as :

Group A

Group B

Group C

Group A

Group B

Group C

Group A

Group B

Group C

How can i fix this?

Thank you very much in advance.

[Former Member · Accepted solution]

Looking at the final output, it seems that subreport is the only option if you want to display 3 separate groups one below the other in a single report,

The analogy of Country > rRegion > City is best viewed in this situation. In a group on Country > Region > City,  Crystal will not list all countries first , then the Cities and then finally the Reqions. It will always list the first Country > then the Regions belonging to that Country > and then the Cities that are in that Region.

-Prathamesh

[abhilash_kumar]

Hi Adrian,

When you say 3 different groups, do you mean you've grouped on 3 different database fields - A, B and C?

I'm guessing you'll need atleast 2 Subreports if the above is true.

-Abhilash

[former_member217682]

Hi Abhilash,

Yes that's right. Is there any other way besides using sub reports?

Thank you.

[abhilash_kumar]

Maybe you could create a SQL query that lists one group after another using the UNION operator?

-Abhilash