Nesting groups

[ravenheart]

This is going to be a little difficult to explain, but hopefully it gets the message across.

I want to nest two groups in a report, with the desired output being it produces every value in the inner group for every value in the outer group. 

Instead, it's producing every value in the outer group, for every value in the inner group. 

For illustration, I WANT it to do this:

GROUP 1 value 1

Group 2 value 1

Group 2 value 2

Group 2 value 3

------------------------

GROUP 1 value 2

Group 2 value 1

Group 2 value 2

Group 2 value 3

etc.

 

What it's actually doing:

GROUP 1 value 1

Group 2 value 1

---------------------------

GROUP 1 value 2

Group 2 value 1

--------------------------

GROUP 1 value 3

Group 2 value 1

------------------------

GROUP 1 value 1

Group 2 value 2

-----------------------

GROUP 1 value 2

Group 2 value 2

etc.

Any ideas welcome.

Thanks

[C-Box]

Hi,

as I don't know your query... did you ordered your records within the sql according to the required order of groups?

Or just post your query and the group expressions for master and slave group.

hth + regards

C-Box