Ordering data in related datasets

[Jacco van der Pol]

I have two datasets with a master detail relation between them. In the queries a sort order is specified.

When I use the datasets individually (without relation) this order is visible in my report.

When I relatie the datasets, the order of both datasets is random (not like the order by clause).

Does anyone know why?

Jacco

[Edward]

If your report contains more than one Connection to data and relations between different Connections, then you need to set Report.CacheAllData property in true.
For this in the Designer please click in any place outside the page, in the Property Editor Report object will be selected, then you may set the property.

Thank you.