Master View problem

rbuser

Hi,

Sometimes i have a problem with a Master/View report.
Example:

first Dataset : Haulier Code / Name / Street / City ...
Data - 001 / Hans / Street 2 / NY
002 / Jim / Street 3 / LA
second Dataset : Vehicle Code / Haulier Code / License plate...
110 / 001 / A127845
120 / 001 / B45V56
130 / 001 / C78G89
140 / 002 / D78K45
150 / 002 / D89564

You can see : a haulier has many Vehicles.

I get this result in my report:

Haulier : 001 Hans
Vehicles :
110 / 001 / A127845
120 / 001 / B45V56
130 / 001 / C78G89
140 / 002 / D78K45
???
150 / 002 / D89564
???

Haulier: 002 Jim
Vehicles :

There are records from haulier 002 that is shown by haulier 001 !!!
That can't be right, you know !

My Detailpipeline has a link with my Masterpipeline (Field_HAULIER_CODE =
Field_HAULIER_CODE)
For my vehicles i use a subreport (Pipeline assigend with Vehicle-Pipeline).
My Haulier-data is placed on the Headerband en my subreport(Vehicle-Data) is
placed on my detailband.
I have one group (F_HAULIER_CODE - groupheader and footer).
I have build a fiew master-detail reports and normaly it work, but sometimes
not !
I know its a difficult question because you don't see the code but maybey
i'm lucky today.
Any idea ??


Greetz Els

digitalmetaphors

Are you using datapipelines on the form? If so, then you'll have to create
the detail dataset so that it is ordered by the master's order by and the
key linking field.

If you are using parameterized queries or table linking, then do not use the
datapipeline's linking properties. These are not compatible. First, have you
run through the master detail reports section in our developer's guide pdf?
It is located in the installation directory. If you do not want to use
standarad Delphi component linking, then here is an example which uses the
pipeline linking approach on carefully ordered datasets:
http://www.digital-metaphors.com/tips/MagicMasterDetail.zip


Cheers,

Jim Bennett
Digital Metaphors