Calculation

rbuser

How to do a report like this one based on a DBF file

Product X Product Y .....
Date
01-Apr
02-Apr
...
30 Apr

Product X, Y... are stored in a file and should be set as groups, but I want
to print them in columns

And each day, I want to show the total amount that was sold, based on a
file that has many records containing all sales for all days.

Yours

Cintia

digitalmetaphors

Are the X and Y values in the same record, of are they values for a single
field? I assume you have one X or Y value in each record. Create two
datasets, and filter them on X or Y do that you have one dataset for the X
values, and one for the Y values. Then create an empty TppReport with two
TppSubreports in the detail band. Set the Autostop property to true in the
main report. Then set the ParentWidth property of each subreport to false
and resize them so that they are side by side subreports. Then connect each
subreport to a pipeline. The left subreport will print X records and the
right subreport will print the Y records.

If you have DBF files, you can use the BDE and a TTable or TQuery component.

TDataset -> TDatasource -> TppDBPipeline -> TppReport


Cheers,

Jim Bennett
Digital Metaphors