Details and more details in a report

[BMKanun]

Is it possible to get report like this:

Invoice: (date, nr. client etc..)

product (details) quantity price
A 1 Ap
B 1 Bp
Set C 1 Cp
('Set conteins)(more details)
product D 1
product E 1
product F 1
G 1 Gp

('And in group footer)
Total products 4 (not 7) Total price Sum(Ap+Bp+Cp+Gp)

thx
B

 

[MajP]

Should be, but there is little information to go with, and not discussion of your tables.

Group by invoice and a subreport in the detail section. Subreport links product to parent product/set. Set it to can grow and the height to 0 so as not to show when there is no data.

 

[BMKanun]

Thanks,
that will do the job.
B