I am having an issue with a report currently under development.
Basically, we have several filters so that the user can filter on various fields.
I am having an issue where-by if I set 2 datasources against the master table, the filters do not work.
One of the child datasources is a 1:1 Inner Join, the other is a 1:N Outer Join - when I set a filter against the child table on the 1:1 the data is valid, however when I then set a filter against the 1:N child table it does not work and data is missing or sporadic.
Is there a way to code in ranges based on a “where” clause?