I'm trying to merge two reports using a ttx data file with a disconnected recordset as the data source. However I cannot get the second report to show any data.
When I use MS Access as the data source, I can merge two reports by placing the second report as a subreport in the first report footer, linking on a similar parameter. So its like the first report will cycle through all its records. Then at the report footer, the second report knows to cycle through all its records before being displayed -in effect giving me two merged reports.
However when I use a ttx file with a disconnected recordset as the data source. The first report dispalys all the records. But in the report footer no records are displayed for the second report. This scenario is actually what I expect, why will data appear in the second report with MS Access but not with a disconnected recordset?
I know I may not have been completely clear so any help on this would be appreciated.