Rather Ripped (Select All in Service Pack 1)

SSRS: errores en selecci?n de par?metros (SP2) | hilpers

SSRS: errores en selecci?n de par?metros (SP2) | hilpers — Tue, 20 Jan 2009 22:53:02 GMT

PingBack from http://www.hilpers-esp.com/408018-ssrs-errores-en-seleccion-de

re: Rather Ripped (Select All in Service Pack 1)

anaylor01 — Tue, 25 Dec 2007 23:41:38 GMT

When I try to use Select All I get This "Incorrect syntax near ','

At the End of Paths Taken (Modifying Where Clause when All Parameter Values are Selected)

Direct Reports (Brian Welcker's Weblog) — Tue, 22 May 2007 19:27:55 GMT

With the return of “Select All” in Service Pack 2, all multi-value parameters allow the user to pick

re: Rather Ripped (Select All in Service Pack 1)

Jan Morten — Thu, 10 May 2007 10:06:53 GMT

Is it possible to hide (select all)? I want to do that because when we have large drop down lists the performance is not very good.

Thanks!

Jan Morten

re: Rather Ripped (Select All in Service Pack 1)

Lasantha — Mon, 23 Apr 2007 09:37:15 GMT

Hi all,

Finally can any one tell how to pass multi value parameters to a stored procedure. example would be great.

Thanks in advance

Select All option for Multi-valued parameters

My thoughts — Fri, 20 Apr 2007 23:02:41 GMT

The 'Select All' option in the multi-valued parameter is again back with SP2. Yeah...it was released

The curious saga of “(Select All)” and multi-valued parameters in Reporting Services

Russell Christopher's Semi-Useful BI Musings — Mon, 09 Apr 2007 21:15:33 GMT

The back- story: Once upon a time, when Reporting Services 2005 was just barely gold, one was able to

re: Rather Ripped (Select All in Service Pack 1)

Brian Welcker — Wed, 21 Mar 2007 10:03:07 GMT

Chris, I understand your reluctance to update to SP2 because of the change. It was a very hard decision and in the end, we went with the direction that we thought most people would be happy with. I hope that we can provide a more granular choice in the future.

re: Rather Ripped (Select All in Service Pack 1)

Chris McGuigan — Tue, 20 Mar 2007 21:50:56 GMT

Hi Brian,

I'm coming in a bit late on this thread but just so you get some feedback.

I'm not whining about this reversal on the 'All' feature - I've done that on the MS forum a while ago ;-)

But it does mean that I will not be updating to SP2 because this one thing has such a significant impact in so many reports.

Now I'm use to it, I can really see the sense of taking the feature out in SP1. It really allows us to implement an 'All' option as efficiently as possible. However, I see the flipside, whilst I am an accomplished SQL programmer, many are not and would probably find implementing this themselves quite a task.

Cheers

Chris

re: Rather Ripped (Select All in Service Pack 1)

sam — Sat, 03 Mar 2007 04:53:01 GMT

Here is how I built my param list:

SELECT * FROM

(

SELECT Fieldname FROM table WHERE yada yada )

UNION

(

SELECT ' <SELECT ALL>' AS Fieldname FROM table WHERE recodid = 1

)

) BINS

ORDER BY BINS. BINADDR

And this is in the WHERE criteria of the report query:

AND (BIN.BINADDR IN (:Bin) OR ' <SELECT ALL>' IN (:Bin) )

Its a little cheezy but it works.

Question for the masters here:

I need to use a very large parameter list such as customer list, product list where there are thousands of records. Is it possible that yall can make the dropdown lists for parameters MUCH larger in the report manager. It is pretty frustrating to to have screen resolution of 1200 x 1200 and then have this little tiny list to work from showing you six of the three thousand or so records you have to select from. Also, search as you type would be most helpful, auto-fill-in for the address bar in IE.