Prev: chart options
Next: Read URL Address
From: peter feakins on 28 Apr 2010 16:43

I have the problem listed in this article:
https://connect.microsoft.com/SQLServer/feedback/details/249227/multi-value-select-all-parameter-in-reporting-services?wa=wsignin1.0


When SELECT ALL is chosen in a multi-select box every item in the
multi-select box is selected and the value of the parameter is a list of
every value (in my case customer id). Since we may have several thousand
customers its not practical from a performance standpoint to pass a query
with this list in an in clause.

Does someone have an approach to dealing with this?


--
peter feakins
From: Bruce L-C [MVP] on 29 Apr 2010 09:33
I assume your list is based on a query. Union the query and add the value of
All.

Next in your query do this sort of thing.

Select somefields from sometable where (afield in (@MyParam) or @MyParam =
'All')

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"peter feakins" <peterfeakins(a)discussions.microsoft.com> wrote in message
news:02EAA1E5-D74E-4F0D-AEAB-0430A24949A5(a)microsoft.com...
>
> I have the problem listed in this article:
> https://connect.microsoft.com/SQLServer/feedback/details/249227/multi-value-select-all-parameter-in-reporting-services?wa=wsignin1.0
>
>
> When SELECT ALL is chosen in a multi-select box every item in the
> multi-select box is selected and the value of the parameter is a list of
> every value (in my case customer id). Since we may have several thousand
> customers its not practical from a performance standpoint to pass a query
> with this list in an in clause.
>
> Does someone have an approach to dealing with this?
>
>
> --
> peter feakins

 | 
Pages: 1
Prev: chart options
Next: Read URL Address