This question is locked. New answers and comments are not allowed.
This is a rather advanced option, but is there or does someone have a good working suggestion, for filtering with the OADS using an IN or WITHIN type of statement?
I have a RadGrid that reads ObjectA via an OADS, but it needs to read ObjectA WHERE ObjectA.OwnerPerson NOT IN (ObjectB).
ObjectB just represents a LIST of people that the OwnerPerson is avoiding.
I can accomplish this easily in MS SQL Queries, and SSRS has this invaluable feature. Is it easier than I'm making it out to be?
I don't want to rewrite a bunch of things, but if I can just put this in the OpenAccessDataSource1_Selecting event, that would suit me just fine.
I have a RadGrid that reads ObjectA via an OADS, but it needs to read ObjectA WHERE ObjectA.OwnerPerson NOT IN (ObjectB).
ObjectB just represents a LIST of people that the OwnerPerson is avoiding.
I can accomplish this easily in MS SQL Queries, and SSRS has this invaluable feature. Is it easier than I'm making it out to be?
I don't want to rewrite a bunch of things, but if I can just put this in the OpenAccessDataSource1_Selecting event, that would suit me just fine.