Multiple groupings in table details row

Is there a way to have multiple groupings for a single dataset in a table's
detail row? I need to be able to hide individual grouped data, but still
need to see the hidden data aggregated in the footer row of the table.
The purpose is to make the report easy to read for troubleshooting by hiding
issues that aren't that important but still need to be calculated. Any help
would be greatly appreciated.No
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"joelnbtx" <joelnbtx@.discussions.microsoft.com> wrote in message
news:9783877A-C8AA-4E51-A49F-4EB1D6CC2463@.microsoft.com...
> Is there a way to have multiple groupings for a single dataset in a
> table's
> detail row? I need to be able to hide individual grouped data, but still
> need to see the hidden data aggregated in the footer row of the table.
> The purpose is to make the report easy to read for troubleshooting by
> hiding
> issues that aren't that important but still need to be calculated. Any
> help
> would be greatly appreciated.sql

Multiple Detail Sections

I have created a report that is using a table with multiple groupings. My
main result set from a stored procedure populates the detail section of the
table. I have a secondary result set that I would like to populate based on a
value from the first result set. For example:
Detail 1 Customer 1
Detail 2 Order 1
Order 2
Order 3
Detail 2 is populated based on the customer id.
How can I accomplish this using the report authoring tool?
Any help would be appreciated.Assuming you are not trying to do a table with groupings, this can be
accomplished with nested "List" items (a list inside of a list) which allow
a free form layout. You just bind each list to the correct dataset for your
detail. See the Sample Reports for an example.
"Scott2624" <Scott2624@.discussions.microsoft.com> wrote in message
news:8411C050-B2FE-48B1-8E26-755220D4FD06@.microsoft.com...
>I have created a report that is using a table with multiple groupings. My
> main result set from a stored procedure populates the detail section of
> the
> table. I have a secondary result set that I would like to populate based
> on a
> value from the first result set. For example:
> Detail 1 Customer 1
> Detail 2 Order 1
> Order 2
> Order 3
> Detail 2 is populated based on the customer id.
> How can I accomplish this using the report authoring tool?
> Any help would be appreciated.
>