What is the best way to deal with creating a report that contains a subreport (What I would love to then include a subreport in the subreport - which you cannot do in Crystal reports).
Or maybe there is a better way to do a report?
I have a table called flights that has one or more requests (requests table). And each request has one or more passengers (passenger table).
How do I report for all flights the requests and passengers?
fltid links the flights and requests table and reqid links passenger table to requests table.