how to make report with seperated item
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
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
Comments
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).