I'm wishing to employ some "Not Exists" logic in a Report Studio report, and I'm looking for opinions on the best approach.
I know similar matters have been discussed in the forum in other threads, but I'm looking for some more practical advice than what I've already read, and something that operates most efficiently (because the datasets are large).
And please keep in mind that it has to be an RS based solution, I do not wish to include it in the FM model.
If we consider the simplified example:
Select * From TABLE1 Where NOT EXISTS ( Select 'x' from TABLE2 where TABLE1.KEY = TABLE2.KEY and TABLE2.DATE < ')
I've used one or two methods, but I'm wondering what advice would people give for doing the same in RS?