How do relations work?
Posted: Tue Mar 25, 2025 3:01 am
Hello,
I think I don't quite understand how relationships between tables work on the Designer.
I created relationships between the tables in my report, but by filtering the data in the Parent table, it still collects all the data from the Child table, and the relationship is also set as Active Relationship.
Shouldn't it also filter the Child table data accordingly?
Am I doing something wrong?
Thanks,
Dennis
I think I don't quite understand how relationships between tables work on the Designer.
I created relationships between the tables in my report, but by filtering the data in the Parent table, it still collects all the data from the Child table, and the relationship is also set as Active Relationship.
Shouldn't it also filter the Child table data accordingly?
Am I doing something wrong?
Thanks,
Dennis