Report with two detail sections (Closed)

[divined]

Hello everybody

I would like to create a report, which would look roughly like the one below :


A REPORT


repair_number Repair_cost

spare_part_number spare_part_cost

"repair_record_just_one (number & cost)"

"spare_part_records (number & cost)"
......................
......................

sum(spare_part_cost)

sum(total_cost_of_repair = repair_cost + spare_part_cost)


I don`t know if it is very clear. What is happening is that there are several repair records and every repair can use some spare parts. The whole idea is that I want a report where for every repair_record I can get the all the spare_parts printed and calculate the total cost. The total cost is equal to the fee of the repair plus the price of every spare part.

I have created two detail sections in my form but get no results in the preview section. Any guidelines as to how I can procede?

thx, in advance

George Papadopoulos