Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Details and more details in a report

Status
Not open for further replies.

BMKanun

Technical User
Sep 27, 2010
20
MK
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top