Master-Detail-Detail Report
I've created a report that's based on 3 tables. It's like this: master dataset - data source, frx data source; detail1 dataset (a query using master datasource and parameter query); detail2 dataset (a query using master datasource and parameter query). I have one master band and 2 details. Each detail has a header and footer.
In design mode the report works great. The master matches up with the 2 detail dataset records and everything displays correctly.
In exe mode, when I preview the report the master appears at the top of each page of the report, but the detail never increments. Each page of the report repeats the same sets of detail records.
I was asked to create a sample to send to support but I thought I'd post this question here first to see if there's anyone that's run into a similar problem.
Thanks much!
In design mode the report works great. The master matches up with the 2 detail dataset records and everything displays correctly.
In exe mode, when I preview the report the master appears at the top of each page of the report, but the detail never increments. Each page of the report repeats the same sets of detail records.
I was asked to create a sample to send to support but I thought I'd post this question here first to see if there's anyone that's run into a similar problem.
Thanks much!