How to print detail from TWO tables, VFP, CR11

[CCSVermont]

I need to report detail from TWO tables.

One is ticket detail, and the other is tender detail.

For each TICKET, there may be multiple TENDERS.

I want all the TICKET detail in one section (items, prices), and then all the TENDER detail below that (payment types, amounts).

I don't know how to get all the records for the TENDER section.

Can someone point me in the right direction?

Thanks.

 

[lbass]

Since you want all of one set of details followed by all of the other, you will need to use a subreport. Use the ticket table in the main report, and the tender table in the subreport.

It is unclear whether you mean you want all of one and all of the other per ticket. If so, then insert a group on ticket number in the main report and then link the subreport to the main report on ticket number and place the subreport in the group footer.

-LB

 

[CCSVermont]

Yes, that worked great. Right after I posted this, I saw another post on subreports.

It's working great!

Thanks for your quick reply.