Thanks for the suggestion. I looked at and have carefully read the article
you gave me.

Using the built in aggregated fields is fine, but in the example at
{DELPHI}\Demos\Midas\Aggregate

only one summary field is displayed at a time: for example the total amount
by "Ship Via", so I get something like this:

DHL $10101.00

but in the current detail there is more than one group, so what I want is
something like that:

DHL $10101.00
UPS $40404.40
....

The question is: can the aggregate fields in tClientDataSet be connected for
example to a GRID which will display all the groups? it doesn't do much good
to see only one total at a time :(.

Best regards,
Dimitar Selensky

----- Original Message -----
From: "Sindu" <sindu@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, March 07, 2001 11:11 AM
Subject: Re: [ib-support] Master/Detail - Interbase


> Hi Dimitar,
>
> If you want a sum grouped by currency for the local data, actually
> TClientDataSet can do that automatically too. You just need to index the
> local data by currency, and then create an aggregate field with grouping
> level 1. To see more detail, check out the sample demo at
> {DELPHI}\Demos\Midas\Aggregate
>
> If it's more complex than that, I guess you'll have to do it manually.
>
> Hope this helps,
> Regards,
> Sindu
>
> On Wed, 7 Mar 2001, Dimitar Selensky wrote:
>
> > Cached updates, tClientDataSets - that's OK, thank you for the
suggestion
> > and the nice URL.
> >
> > BUT, still, that doesn't solve one problem: if I have a local copy of
the
> > data I'm editing, I can not run a query against it. What am I going to
do
> > about that?! If there are just simple sums, it's OK, but mine usually
are
> > grouped by currency and the sum is multi line. It works very well with a
> > query, but I'll have to write it manually I guess.
> >
> > Any solutions? It sounds funny that one can not have a summarizing query
> > whenever there's a master/detail table involved. At least not before the
> > final POST, which doesn't do much good.
> >
> > Thank you,
> > Best regards,
> > Dimitar Selensky
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>