Hi,
I have SSRS paramter (Multivalue) which is being passed in DP class as a List Object. Now in the DP class, I want to filter a transaction table based on the values of List Object.
List Object is a Customer Account Number.
How do i effectively write the select statement to get the result based on above requirement? I want to avoid iteration from List. Is it possible?
Has anyone faced this before?
*This post is locked for comments
No, it's not possible without iterating the list.
You can iterate the items and add a query range for each of them:
Share
Report
All responses (
Answers (
ListEnumerator enumerator = list.getEnumerator();
while (enumerator.moveNext())
{
qbds.addRange(...).value(queryValue(enumerator.current()));
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156