How to create this kind of report

notice on the excel sheet there is a regular programs header, now see database on products, if allocationtype is checked then itll show on the regular programs header

notice the programs 1, 2, 3 on the division below... and its details, the programs 1, 2, 3 will be gathered / record individually on the program table (example of programs are M.D. Covering, Fetal Care Seminar. instead of Program 1, it will show a record on the table... now the details below it is the product and promo mat with their corresponding familiar keys (progid, prodid)

how can i imitate the excel sample with the following records through crystal reports?

sample on excel attachment...

reference on intermed.mdb