Sub report header prints multiple times/page

rbuser

I have a report with two tables which are configured in a master detail
relationship. In the tppSubreport the heading of the sub-report will
occasionally print more than one time per master record, or will not print
at the top of the sub report. I have the tables in question linked in a
master detail manner. It appears that the sub-report is displaying detail
records that belong to subsequent Master records.
Any ideas?

digitalmetaphors

Are you using DADE or linking tables on a form? If you have data access
components on a form, then you hook the table datasources up to TDBGrids to
see the actual data that is coming through. Make sure this is correct. If
it is correct and the report is showing erroneous data for subrepors, then
can you create a demo project for us that shows this behavior and send it to
support@digital-metaphors.com


Cheers,

Jim Bennett
Digital Metaphors

rbuser

I have looked at this further, and the form that has the report component
displays the master record that is appropriate for the extra detail records
that are on the report.

Basically, the report seems to want to print enough detail records to fill
to the bottom of the
page (I'm not sure why). For example, the page I am looking at now has 3
master records worth of detail records, detail for the current record and
the two subsequent records. I can still see the form behind the report, and
master record in the grid is the second detail record. If I can figure out
why the report always fills to the end of the page with detail records I
think that I will know the answer.
If anything comes to mind let me know...

Thanks!

digitalmetaphors

There is one thing I forgot to mention. Make sure you do NOT set the
MasterDataPipeline and MasterFieldsLinks properties on the TppDBPipeline
components.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

I clear 'em, but after I close the report designer they are back!

digitalmetaphors

You have the datasets on the form or are you using DADE? If you are using
datasets on a form, then you should be able to delete the master field links
and master data pipeline property settings. Then save the form down and load
it back up and run it. In DADE, these properties are used internally by DADE
to support master detail linking, you should not have to set these at all.
They will be automatically set.


Cheers,

Jim Bennett
Digital Metaphors