Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Master Detail Not Displaying Properly using Datapipe Linking

edited October 2005 in Subreports
Hi
I have been attempting to set up my first master detail repot using
Datapipeline linking and 2 queries
I have now gotten to the point where my display is almost showing correctly.
My problem is that my first first master record prints off all territories
in the detail, not just the ones that link with the corresponding territory
that is being printed in the master query. All the other master records
that are being printed display the correc detail

I am not sure if I have a setting incorrect and why the very first master
record displays the entire "detail" dataset as its detail.
i have a report the detail is grouped by territory, the subreport is placed
in the detail of the main report and both queries are ordered by territory

My master query is select * from table where report_type='TT' order by
territory,report_type My detail query is select * from table where
report_type='HO' or report_type ='BB" order by territory,report_type

For every one territory in the master, the detail query contains 2
corresponding records that contain the same territory
The field layouts of both queries are identical, just the numbers/characters
are different inside the fields.

For example Master Table which contains total sales records
Territory 1234 Record_type=TT'

Detail Table which contains breakout of total sales records
Territory 1234 Record_type='BB'
Territory 1234 Record_type='HO

Any help would be appreciated as I am on a tight deadline and not familiar
with doing master detail reports
Thanks
Kara

Comments

This discussion has been closed.