Master Detail Report Question

Consider this query:

select count(*) as total, order_type, order_category,
order_subcategory...GROUP BY order_type, order_category,
order_subcategory

This SQL brings me a report sorted appropriately, albeit ugly in a
DataGrid.

Is there anyway to create a nice Master Detail *without* having to hit
the database again to get the totals?

In DataGrid1,

order_type

DataGrid1 onitemdatabound
DataGrid2 order_category
DataGrid2 onitemdatabound
DataGrid3 order_subcategory

I do not see how to eliminate the repeating rows this way, however;
Any thoughts? Thanks.Check out ActiveReports from DataDynamics, Inc.
http://www.datadynamics.com/Product...x?Product=ARNET

You generally get what you pay for... ActiveReports isn't cheap.

"jm" <john_20_28_2000@.yahoo.com> wrote in message
news:c67e4bdd.0405201321.7be8e377@.posting.google.c om...
> Consider this query:
> select count(*) as total, order_type, order_category,
> order_subcategory...GROUP BY order_type, order_category,
> order_subcategory
> This SQL brings me a report sorted appropriately, albeit ugly in a
> DataGrid.
> Is there anyway to create a nice Master Detail *without* having to hit
> the database again to get the totals?
> In DataGrid1,
> order_type
> DataGrid1 onitemdatabound
> DataGrid2 order_category
> DataGrid2 onitemdatabound
> DataGrid3 order_subcategory
> I do not see how to eliminate the repeating rows this way, however;
> Any thoughts? Thanks.
Thanks, but how does this help me?

"Ketchup Please" <GoodStuff@.Heinz57.com> wrote in message news:<#ubPXHrPEHA.2236@.TK2MSFTNGP10.phx.gbl>...
> Check out ActiveReports from DataDynamics, Inc.
> http://www.datadynamics.com/Product...x?Product=ARNET
> You generally get what you pay for... ActiveReports isn't cheap.
>
>
> "jm" <john_20_28_2000@.yahoo.com> wrote in message
> news:c67e4bdd.0405201321.7be8e377@.posting.google.c om...
> > Consider this query:
> > select count(*) as total, order_type, order_category,
> > order_subcategory...GROUP BY order_type, order_category,
> > order_subcategory
> > This SQL brings me a report sorted appropriately, albeit ugly in a
> > DataGrid.
> > Is there anyway to create a nice Master Detail *without* having to hit
> > the database again to get the totals?
> > In DataGrid1,
> > order_type
> > DataGrid1 onitemdatabound
> > DataGrid2 order_category
> > DataGrid2 onitemdatabound
> > DataGrid3 order_subcategory
> > I do not see how to eliminate the repeating rows this way, however;
> > Any thoughts? Thanks.