Master Detail relation utility?
Posted: Sat Jun 27, 2020 5:44 pm
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
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