Groups and order

rbuser

Hello,

I'm creating a billing report.
I want to group the products by code products and then calc the totals by
product.
But the products are not order by code product and then some products can
not apear grouped.

Is there any way to do this funcionality without change the products order?

Thanks in advance,

Ladrillo

nicocizik

Ladrillo,

Try calculating the totals in a new dataset and retrieving the totals from
there, or simply ordering by the actual products in your original dataset.
Then you can group by product as you need in the report and perform the
calculations in the group bands.

--

rbuser

Hello,

Thanks for your answer.

I'm working inside the end-user aplication and I can't change the datasets.
Is posible to add a Query on DADE and link it master-slave (or something
like that) with the original bills dataset?

Ladrillo

nicocizik

Ladrillo,

Yes this is possible. Below are links to a couple examples that show how to
link a standard Delphi dataset to and from a DADE dataview.

- Example 1: DADE Dataview is the Master.

http://www.digital-metaphors.com/tips/LinkDADEPipeToStandardPipe.zip

- Example 2: Standard Delphi Pipeline is the Master.

http://www.digital-metaphors.com/tips/LinkStandardPipeToDADEPipe.zip

--

rbuser

Hello,

Is it possible to do it from RAP?
I'm making the report from my end-users application and I can't adapt the
exe file for each report.

Thanks in advance,

Ladrillo

nicocizik

Ladrillo,

This is not a standard method of linking datasets in ReportBuilder. We
recommend you keep all datasets either on a form or in a template. Using
RAP, you could create a pass thru function performing a similar task as the
example I sent you but you will still need to modify the .exe to make this
work.

--