Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / October 2006

Tip: Looking for answers? Try searching our database.

Select All  parameter option missing on Report Mgr Website

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dan - 24 Oct 2006 15:21 GMT
I have designed a report that has a parameter that allows you to select
multiple customers.  When I preview the report in Visual Studio 05, the drop
down list has a checkbox at the top that says "select all". When I deploy the
report to the Report Mgr Website (SQL Server 2005 STD, SP1), everything
works, except there is no "select all" option in the list of clients.

Is there anything I can  do to fix this?
Kyriakos - 24 Oct 2006 15:52 GMT
Yes, install SP2.

Microsoft has removed the functionality in SP1.

> I have designed a report that has a parameter that allows you to select
> multiple customers.  When I preview the report in Visual Studio 05, the drop
[quoted text clipped - 3 lines]
>
> Is there anything I can  do to fix this?
Dan - 24 Oct 2006 17:14 GMT
SQL Server 2005 SP2 has not been released yet has it?

> Yes, install SP2.
>
[quoted text clipped - 7 lines]
> >
> > Is there anything I can  do to fix this?
Kyriakos - 24 Oct 2006 17:58 GMT
M... thought it was out, but it's probably not....

Another solution is uninstalling SP1, or start writing custom Sprocs -like I
do-

> SQL Server 2005 SP2 has not been released yet has it?
>
[quoted text clipped - 9 lines]
> > >
> > > Is there anything I can  do to fix this?
Chris Conner - 27 Oct 2006 18:35 GMT
There is a hotfix you can download...

I am trying to find the URL -> I was viewing a MS website where the project
lead was talking about the reasons they took it out and realized they should
have left it in.

=-Chris

>I have designed a report that has a parameter that allows you to select
> multiple customers.  When I preview the report in Visual Studio 05, the
[quoted text clipped - 5 lines]
>
> Is there anything I can  do to fix this?
Chris Conner - 27 Oct 2006 19:02 GMT
Here is the hotfix..

https://blogs.msdn.com/bwelcker/archive/2006/08/14/700189.aspx

> There is a hotfix you can download...
>
[quoted text clipped - 13 lines]
>>
>> Is there anything I can  do to fix this?
Bruce L-C  [MVP] - 30 Oct 2006 19:29 GMT
This hotfix is not necessary if you have SP1 installed. It is part of SP1
(RS 2005).

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Here is the hotfix..
>
[quoted text clipped - 17 lines]
>>>
>>> Is there anything I can  do to fix this?
mikesnp - 30 Oct 2006 23:40 GMT
I spoke to Microsoft support today regarding a ReportViewer problem,
which they believed would be resolved with an SP1 install. When I
explained that we have not installed SP1 because of the "Select All"
problem, I was told that there is a hot fix.

Mor information is available at...

http://support.microsoft.com/kb/919478/en-us

MS provided me a link and password to download the hotfix. Does anyone
have experience with this yet?

For my part, I'll post my findings after testing.

- Mike

http://www.seginusmd.com
Bruce L-C  [MVP] - 31 Oct 2006 16:13 GMT
I'm sorry. Got confused. I am running SP1. SP1 introduced the problem. I
have the hotfix installed and it is working as advertised.

I have been in production with it since it came out (the hotfix came out)
which has been months.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

>I spoke to Microsoft support today regarding a ReportViewer problem,
> which they believed would be resolved with an SP1 install. When I
[quoted text clipped - 13 lines]
>
> http://www.seginusmd.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.