Details grouping

Hi,
what is the details grouping for? Like, we have the ability to set up
groups, why do we also need details grouping?
thanks
MattMatt,
You may not want to show the lowest level of detail returned by your
query, say you returned order lines in your query, but you only want to
show order totals. Instead of having an order group and a detail
section that needs to be hidden, you could just have detail section
grouped on order.
You may say that's actually quite inefficient as you should change the
query to just return order totals, and you'd be right, but consider if
that grouping was parameter driven. You might want to group on sales
rep, customer or product. This is when this scenario makes sense.
Hope that helps.
Cheers
Chris
Matt wrote:
> Hi,
> what is the details grouping for? Like, we have the ability to set up
> groups, why do we also need details grouping?
> thanks
> Matt|||Ah I see. Thanks Chris - for taking the time to write a nice clear
explanation
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:e6XfTURiFHA.1204@.TK2MSFTNGP12.phx.gbl...
> Matt,
> You may not want to show the lowest level of detail returned by your
> query, say you returned order lines in your query, but you only want to
> show order totals. Instead of having an order group and a detail
> section that needs to be hidden, you could just have detail section
> grouped on order.
> You may say that's actually quite inefficient as you should change the
> query to just return order totals, and you'd be right, but consider if
> that grouping was parameter driven. You might want to group on sales
> rep, customer or product. This is when this scenario makes sense.
> Hope that helps.
> Cheers
> Chris
>
> Matt wrote:
> > Hi,
> >
> > what is the details grouping for? Like, we have the ability to set up
> > groups, why do we also need details grouping?
> >
> > thanks
> >
> > Matt
>