Nesting groups

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

ravenheart's picture
Joined: Jul 10 2013 - 5:12am
Last seen: 1 year 2 weeks ago

1 Answer:

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

C-Box's picture
11676
Joined: Jul 19 2006 - 5:58pm
Last seen: 2 months 3 weeks ago
Feedback