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!

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.