Subgrouping differently under subsequest "instances" of a group

[Guest]

Quick question regarding grouping differently in different sections:

Is it possible to group by one field/expression in one "instance" of a
section of a report, and group by a different field/expression in another
"instance" of that section?

For example:

Section 1, first "instance" (1st grouping level A)
(Group by "Trip ID" here...)
Trip ID 1a (2nd grouping level A)
Trip ID 1a Detail 1
Trip ID 1a Detail 2
Trip ID 1b
Trip ID 1b Detail 1
Trip ID 1b Detail 2
Section 1, second "instance") (1st grouping level B)
(Group by "Trip NAME" here...)
Trip NAME 1a (2nd grouping level B)
Trip NAME 1a Detail 1
Trip NAME 1a Detail 2
Trip NAME 1b
Trip NAME 1b Detail 1
Trip NAME 1b Detail 2

In section 1, first "instance", group by Trip ID.
In section 1, second "instance", group by Trip NAME.

If this is possible, perhaps point me in the general direction of how to go
about this.

Thank you so much in advance for your assistance.

 

[Guest]

Sorting and grouping is calculated before the report runs, and
the report query is modified to do the sorting and grouping, so
it can't be changed after the report is started.

But if you really want to, you can use a subreport. The subreport
can probably be re-grouped for each instance, and if not, you can
just have two subreports on top of each other, and make one
invisible each time the section is formatted.

(david)

 

[Guest]

Thanks you, both for the clarification of how reports go about "assembling"
themselves, and the tip. The subreport will probably work. Thanks again!