hi

I have some data in tabel sales. it's look like this :

code Unit qty Price
A01 pcs 2 2000
A02 prs 1 1000
B01 grm 2 1500

i want to make the report from that table. it's look like this :

code | qty | Price | Total
pcs|prs|grm

A01 2 2000 4000
A02 1 1000 1000
B01 2 1500 3000

can you help me how to make report like that? (the column will be code, qty - have child (pcs,prs,grm) price, total)

thank's
yudi

This is a standard table.
code | qty | Price | Total (total = Price * qty ) - master band
pcs|prs|grm - subreport plaсed under 'qty' memo, or a detail band (depend on dataset structure).

You can do it via DBCross component , code | qty | Price | - columns , pcs|prs|grm - sub columns , this is described in User manual.