Within Report Studio, other than the usual "Master Detail Relationships" interface, is there another way to view and modify the relationship? Is there a way to create a conditional Master-Detail relationship?
I have 2 queries, one's the master and the other's the detail. Using the "Master Detail Relationships" interface, I am joining these two queries with one relationship. I would like to create a one to many relationship therefore I created a relationship where one column in the master is pointing to 2 columns over on the detail side. The problem is that the relationship is very rigid and it requires that the 2 columns on the detail side to be of the same value. These relationship is similar to any logic using an "AND" operator as oppose to an "OR' operator.
then, i feel you need to have values of both the columns in a single column..in other words, union of both columns..