Master Detail relation utility?

[lutin7812]

Hi, can someone enlighten me:
in a master detail report with SQL Server, I tried first to use the relation component to filter detail with master.
I can't make it work, detail is not filtered from master I get all the detail records.

However, If I use a parameter link between master/detail (ie. put a where clause in the detail query (where fkcol = prm), report run fine, detail is well filtered from master.
So what is the use for relation component? Is it only for in memory filtering on the client?
Is it mandatory to specify "manual" parameter for filtering master-detail with SQL DB?
Thank's for some light.
Olivier

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.