RS2005 Standard install error..

I am installing SQL 2005 and RS 2005 on a new W2k3 server. I have tried to
install to a default instance and to a named instance and continue to get the
following error when I try to retrieve the reports page or connect to the
reporting services thru Microsoft SQL server Management Studio.
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
In the Log file ReportServerWebApp__01_03_2006_13_51_00.log I see:
w3wp!ui!7!1/3/2006-12:01:32:: e ERROR: The attempt to connect to the report
server failed. Check your connection information and that the report server
is a compatible version.
w3wp!ui!7!1/3/2006-12:01:33:: e ERROR: HTTP status code --> 500
--Details--
Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version. -->
System.Net.WebException: The request failed with HTTP status 404: Not Found.
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
-- End of inner exception stack trace --
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!7!1/3/2006-12:01:34:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)Did anyone find a solutions to this issue, i have encountered the same
problem, and cannot seem to get it to work.
Thanks
Jim wrote:
> I am installing SQL 2005 and RS 2005 on a new W2k3 server. I have tried to
> install to a default instance and to a named instance and continue to get the
> following error when I try to retrieve the reports page or connect to the
> reporting services thru Microsoft SQL server Management Studio.
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.
>
> In the Log file ReportServerWebApp__01_03_2006_13_51_00.log I see:
>
> w3wp!ui!7!1/3/2006-12:01:32:: e ERROR: The attempt to connect to the report
> server failed. Check your connection information and that the report server
> is a compatible version.
> w3wp!ui!7!1/3/2006-12:01:33:: e ERROR: HTTP status code --> 500
> --Details--
> Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException:
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version. -->
> System.Net.WebException: The request failed with HTTP status 404: Not Found.
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> -- End of inner exception stack trace --
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Page.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> w3wp!ui!7!1/3/2006-12:01:34:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)|||I'm experiencing the same problems, you might think it has something to do
with SSL, but it is not necessary to use it, is it?
I would be very pleased with some help regarding this subject!|||Why are no microsoft people responding to these posts? Thought that was the
deal with this support option via msdn?
I'm having the same issue and have yet to get report manager to work via
http://servername/reports.
--
Thanks,
Chris.
"Ruud0011" wrote:
> I'm experiencing the same problems, you might think it has something to do
> with SSL, but it is not necessary to use it, is it?
> I would be very pleased with some help regarding this subject!|||I've had this same issue. I installed RS2005 and VS2005 on a new Windows
2003 server. This was not an upgrade. I am using an SSL certificate and
edited the C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportManager\RSWebApplication.config file by removing the entry for
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>.
The ReportURL entry looks like this
ReportServerUrl>https://localhost/reportserver</ReportServerUrl> -- Note that
it says "reportserver" and not reports which is why I kept getting the same
error. The C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportServer\RSReportServer.config file was edited to reflect the
SecureConnectionLevel Value 3 and the URLRoot was
https://localhost/reportserver
All is well. No more error messages.
WMH
"whoopdaddy" wrote:
> Why are no microsoft people responding to these posts? Thought that was the
> deal with this support option via msdn?
> I'm having the same issue and have yet to get report manager to work via
> http://servername/reports.
> --
> Thanks,
> Chris.
>
> "Ruud0011" wrote:
> > I'm experiencing the same problems, you might think it has something to do
> > with SSL, but it is not necessary to use it, is it?
> >
> > I would be very pleased with some help regarding this subject!|||Thanks WMH - I had same problem - just spent a few very frustrating days
trying to fix this until I spotted your advice.
Paddy
"WMH" wrote:
> I've had this same issue. I installed RS2005 and VS2005 on a new Windows
> 2003 server. This was not an upgrade. I am using an SSL certificate and
> edited the C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportManager\RSWebApplication.config file by removing the entry for
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>.
> The ReportURL entry looks like this
> ReportServerUrl>https://localhost/reportserver</ReportServerUrl> -- Note that
> it says "reportserver" and not reports which is why I kept getting the same
> error. The C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportServer\RSReportServer.config file was edited to reflect the
> SecureConnectionLevel Value 3 and the URLRoot was
> https://localhost/reportserver
> All is well. No more error messages.
> WMH
>
> "whoopdaddy" wrote:
> > Why are no microsoft people responding to these posts? Thought that was the
> > deal with this support option via msdn?
> >
> > I'm having the same issue and have yet to get report manager to work via
> > http://servername/reports.
> > --
> > Thanks,
> > Chris.
> >
> >
> > "Ruud0011" wrote:
> >
> > > I'm experiencing the same problems, you might think it has something to do
> > > with SSL, but it is not necessary to use it, is it?
> > >
> > > I would be very pleased with some help regarding this subject!|||I feel certain that I missed some important documentation that Microsoft
provided us on this issue, but your "removing the entry for
<ReportServerVirtualDirectory>" is the best information on this error
message. I don't have SSL and the Configuration Tool doesn't fix this problem
when you move the virtual directories to another website. I have wasted
entirely too many hours on this and have actually reloaded our 2003 server
twice. Simply remove the <ReportServerVirtualDirectory> tag and all is well.
Thank you very much for your post!!!
Thanks,
Chris
"WMH" wrote:
> I've had this same issue. I installed RS2005 and VS2005 on a new Windows
> 2003 server. This was not an upgrade. I am using an SSL certificate and
> edited the C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportManager\RSWebApplication.config file by removing the entry for
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>.
> The ReportURL entry looks like this
> ReportServerUrl>https://localhost/reportserver</ReportServerUrl> -- Note that
> it says "reportserver" and not reports which is why I kept getting the same
> error. The C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportServer\RSReportServer.config file was edited to reflect the
> SecureConnectionLevel Value 3 and the URLRoot was
> https://localhost/reportserver
> All is well. No more error messages.
> WMH
>
> "whoopdaddy" wrote:
> > Why are no microsoft people responding to these posts? Thought that was the
> > deal with this support option via msdn?
> >
> > I'm having the same issue and have yet to get report manager to work via
> > http://servername/reports.
> > --
> > Thanks,
> > Chris.
> >
> >
> > "Ruud0011" wrote:
> >
> > > I'm experiencing the same problems, you might think it has something to do
> > > with SSL, but it is not necessary to use it, is it?
> > >
> > > I would be very pleased with some help regarding this subject!

RS2005 Parameter value persists

I have a simple RS2005 report with 2 parameters, one with a default value
defined and one without.
When the report is viewed in designer "Preview" mode the second parameter
must be selected before "View Report" will run.
When deployed and viewed through Report Manager and IE6, the second
parameter comes up with the old value and the report fills automatically (I
can then select another value for the parameter and things work OK).
I've cleared temp files, restarted, etc. to no avail.
How can I get the deployed version to forget the default value?OK-I seem to have solved this.
Looking in SQL Server's Report Server database, table dbo.Catalog, in the
row for my report, in the Parameter field, I found the erroneous default
value stored. Changing the Default Value in the Report Parameters screen had
no effect on this SQL Server value. Only after removing the parameter,
re-deploying, adding the parameter back and deploying again could I remove
the erroneous default value.
"Paul" wrote:
> I have a simple RS2005 report with 2 parameters, one with a default value
> defined and one without.
> When the report is viewed in designer "Preview" mode the second parameter
> must be selected before "View Report" will run.
> When deployed and viewed through Report Manager and IE6, the second
> parameter comes up with the old value and the report fills automatically (I
> can then select another value for the parameter and things work OK).
> I've cleared temp files, restarted, etc. to no avail.
> How can I get the deployed version to forget the default value?

RS SP2; the link is already there

http://www.microsoft.com/windowsserversystem/default.mspx
"Download SQL Reporting Services SP2 and New Report Packs
Get the latest downloads for SQL Server Reporting Services, including
Service Pack
2 and new report packs for IIS and Great Plains."But not the SP2!!!!!
--
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
"Joerg" <Joerg@.discussions.microsoft.com> wrote in message
news:1E11120D-23DE-4A0C-B21C-942210C8F2F6@.microsoft.com...
> http://www.microsoft.com/windowsserversystem/default.mspx
> "Download SQL Reporting Services SP2 and New Report Packs
> Get the latest downloads for SQL Server Reporting Services, including
> Service Pack
> 2 and new report packs for IIS and Great Plains."
>
>
>|||Oops... looks like someone at MS posted the link a little too soon on
the Server home page since there is no mention of SP2 on the RS
homepage.|||It wouldn't be so bad...except that there is no SP and no news.
Somebody say something about it. Can I get a little count down timer?
Where is that magic 8 ball? Some guy is out there right now flipping
coins until his thumb rubs his index finger raw...and the only thing
we've got to go on is a typo of sorts on the server homepage.|||We MVPs are in the dark too. I really thought I would see it this month.
Hopefully it won't be too much longer.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Luke" <lukeguerrant@.gmail.com> wrote in message
news:1112222701.375010.249600@.z14g2000cwz.googlegroups.com...
> It wouldn't be so bad...except that there is no SP and no news.
> Somebody say something about it. Can I get a little count down timer?
> Where is that magic 8 ball? Some guy is out there right now flipping
> coins until his thumb rubs his index finger raw...and the only thing
> we've got to go on is a typo of sorts on the server homepage.
>|||I know that SP2 is out there somewhere.
Could I prevail on anyone to tell me where I can get a copy?
Thanks
"Bruce L-C [MVP]" wrote:
> We MVPs are in the dark too. I really thought I would see it this month.
> Hopefully it won't be too much longer.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Luke" <lukeguerrant@.gmail.com> wrote in message
> news:1112222701.375010.249600@.z14g2000cwz.googlegroups.com...
> > It wouldn't be so bad...except that there is no SP and no news.
> > Somebody say something about it. Can I get a little count down timer?
> > Where is that magic 8 ball? Some guy is out there right now flipping
> > coins until his thumb rubs his index finger raw...and the only thing
> > we've got to go on is a typo of sorts on the server homepage.
> >
>
>|||This link has been removed. I don't think that's a sign that they're about to
release it. But this is Microsoft. Have they ever released any software on
time?
"Joerg" wrote:
> http://www.microsoft.com/windowsserversystem/default.mspx
> "Download SQL Reporting Services SP2 and New Report Packs
> Get the latest downloads for SQL Server Reporting Services, including
> Service Pack
> 2 and new report packs for IIS and Great Plains."
>
>
>|||OK, here's the story. We are working very hard to finish up SP2. We had
planned to get it out by the end of March but we found a couple of issues
very late that we felt that we really needed to address. Couple this with
the fact that we are also the team that delivered the February Community
Technology preview of SQL Server 2005 Reporting Services and this means we
had to push back a little. We have now feel confident that SP2 will be out
by mid-April. Thank you for your patience and support.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"FritoBandido" <FritoBandido@.discussions.microsoft.com> wrote in message
news:945A4957-A365-4006-A7FF-3BA356280D13@.microsoft.com...
>I know that SP2 is out there somewhere.
> Could I prevail on anyone to tell me where I can get a copy?
> Thanks
> "Bruce L-C [MVP]" wrote:
>> We MVPs are in the dark too. I really thought I would see it this month.
>> Hopefully it won't be too much longer.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Luke" <lukeguerrant@.gmail.com> wrote in message
>> news:1112222701.375010.249600@.z14g2000cwz.googlegroups.com...
>> > It wouldn't be so bad...except that there is no SP and no news.
>> > Somebody say something about it. Can I get a little count down timer?
>> > Where is that magic 8 ball? Some guy is out there right now flipping
>> > coins until his thumb rubs his index finger raw...and the only thing
>> > we've got to go on is a typo of sorts on the server homepage.
>> >
>>|||On Thu, 31 Mar 2005 22:22:19 -0800, "Brian Welcker"
<bwelcker@.online.microsoft.com> wrote:
>OK, here's the story. We are working very hard to finish up SP2. We had
>planned to get it out by the end of March but we found a couple of issues
>very late that we felt that we really needed to address. Couple this with
>the fact that we are also the team that delivered the February Community
>Technology preview of SQL Server 2005 Reporting Services and this means we
>had to push back a little. We have now feel confident that SP2 will be out
>by mid-April. Thank you for your patience and support.
Good for you Brian. It's a hard choice and I'm glad I didn't have to
make it in this case, but ya done right in my opinion.
All you can do is all you can do. Hope you get some sleep some month
soon.
Highly Obscure|||I appreciate somebody saying SOMETHING. I mean...blow smoke, I am
alright with that even...as long as I have some kind of idea when to
expect the SP. Thank Brain...you are a stand up guy in my opinion. I
know that you guys want a good SP...as well as I. Just knowing when to
expect it makes my job easier.
I don't know about everyone else..but I am buying a whole server in
which to test SRS SP2...so having a time frame makes my life easier.|||can anyone confirm if rs-sp2 will have a report viewer control for winforms
and webforms ? - is this a pure .NET control or is it ActiveX
also where can i find a list of featuers/bugfixes for sp2?
thanks
"Joerg" wrote:
> http://www.microsoft.com/windowsserversystem/default.mspx
> "Download SQL Reporting Services SP2 and New Report Packs
> Get the latest downloads for SQL Server Reporting Services, including
> Service Pack
> 2 and new report packs for IIS and Great Plains."
>
>
>|||I can confirm that SP2 does not have the new webform/winform controls. That
will be coming out with the next beta of Widbey (next version of Visual
Studio).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ranga" <ranga@.discussions.microsoft.com> wrote in message
news:82EFEFC5-44F7-425D-84D9-90538A9BDA91@.microsoft.com...
> can anyone confirm if rs-sp2 will have a report viewer control for
winforms
> and webforms ? - is this a pure .NET control or is it ActiveX
> also where can i find a list of featuers/bugfixes for sp2?
> thanks
> "Joerg" wrote:
> > http://www.microsoft.com/windowsserversystem/default.mspx
> >
> > "Download SQL Reporting Services SP2 and New Report Packs
> > Get the latest downloads for SQL Server Reporting Services, including
> > Service Pack
> > 2 and new report packs for IIS and Great Plains."
> >
> >
> >
> >
> >
> >|||>> other posts in this group seem to indicate that client side printing is
one of
the major features of sp2 - have they pulled the plug on this feature for
sp2 ?
>> if client-side printing is not going to be in sp2, then what other alternative is there ? (using pdf is ok but getting adobe to start is a slow process ; popping up
a browser window in a winform app does not look clean; using a web browser
control in a windows-forms app is also not clean (the control does not have a
print button)
"Bruce L-C [MVP]" wrote:
> I can confirm that SP2 does not have the new webform/winform controls. That
> will be coming out with the next beta of Widbey (next version of Visual
> Studio).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ranga" <ranga@.discussions.microsoft.com> wrote in message
> news:82EFEFC5-44F7-425D-84D9-90538A9BDA91@.microsoft.com...
> > can anyone confirm if rs-sp2 will have a report viewer control for
> winforms
> > and webforms ? - is this a pure .NET control or is it ActiveX
> >
> > also where can i find a list of featuers/bugfixes for sp2?
> >
> > thanks
> >
> > "Joerg" wrote:
> >
> > > http://www.microsoft.com/windowsserversystem/default.mspx
> > >
> > > "Download SQL Reporting Services SP2 and New Report Packs
> > > Get the latest downloads for SQL Server Reporting Services, including
> > > Service Pack
> > > 2 and new report packs for IIS and Great Plains."
> > >
> > >
> > >
> > >
> > >
> > >
>
>|||Please look at the post that I responded to. It had nothing to do with
client side printing. I responded spefically about the new web and winform
report viewer controls.
SP2 WILL have the ability for client side printing. Two different things
here.
Also, in case you haven't seen, SP2 will be out mid month. It was delayed a
couple of weeks (originally they were targeting the end of March for
release).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ranga" <ranga@.discussions.microsoft.com> wrote in message
news:D03BC10F-F046-4EDA-8852-330ACD8BE054@.microsoft.com...
> >> other posts in this group seem to indicate that client side printing is
> one of
> the major features of sp2 - have they pulled the plug on this feature for
> sp2 ?
> >> if client-side printing is not going to be in sp2, then what other
alternative is there ? (using pdf is ok but getting adobe to start is a slow
process ; popping up
> a browser window in a winform app does not look clean; using a web browser
> control in a windows-forms app is also not clean (the control does not
have a
> print button)
>
> "Bruce L-C [MVP]" wrote:
> > I can confirm that SP2 does not have the new webform/winform controls.
That
> > will be coming out with the next beta of Widbey (next version of Visual
> > Studio).
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "ranga" <ranga@.discussions.microsoft.com> wrote in message
> > news:82EFEFC5-44F7-425D-84D9-90538A9BDA91@.microsoft.com...
> > > can anyone confirm if rs-sp2 will have a report viewer control for
> > winforms
> > > and webforms ? - is this a pure .NET control or is it ActiveX
> > >
> > > also where can i find a list of featuers/bugfixes for sp2?
> > >
> > > thanks
> > >
> > > "Joerg" wrote:
> > >
> > > > http://www.microsoft.com/windowsserversystem/default.mspx
> > > >
> > > > "Download SQL Reporting Services SP2 and New Report Packs
> > > > Get the latest downloads for SQL Server Reporting Services,
including
> > > > Service Pack
> > > > 2 and new report packs for IIS and Great Plains."
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> >
> >
> >|||How is the confidence graph looking? When does mid april end?
"Brian Welcker" wrote:
> OK, here's the story. We are working very hard to finish up SP2. We had
> planned to get it out by the end of March but we found a couple of issues
> very late that we felt that we really needed to address. Couple this with
> the fact that we are also the team that delivered the February Community
> Technology preview of SQL Server 2005 Reporting Services and this means we
> had to push back a little. We have now feel confident that SP2 will be out
> by mid-April. Thank you for your patience and support.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "FritoBandido" <FritoBandido@.discussions.microsoft.com> wrote in message
> news:945A4957-A365-4006-A7FF-3BA356280D13@.microsoft.com...
> >I know that SP2 is out there somewhere.
> > Could I prevail on anyone to tell me where I can get a copy?
> > Thanks
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> We MVPs are in the dark too. I really thought I would see it this month.
> >> Hopefully it won't be too much longer.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Luke" <lukeguerrant@.gmail.com> wrote in message
> >> news:1112222701.375010.249600@.z14g2000cwz.googlegroups.com...
> >> > It wouldn't be so bad...except that there is no SP and no news.
> >> > Somebody say something about it. Can I get a little count down timer?
> >> > Where is that magic 8 ball? Some guy is out there right now flipping
> >> > coins until his thumb rubs his index finger raw...and the only thing
> >> > we've got to go on is a typo of sorts on the server homepage.
> >> >
> >>
> >>
> >>
>
>|||Is there any update on when SP2 will actually be coming out? It's now April
21st & no SP2?
"Bruce L-C [MVP]" wrote:
> Please look at the post that I responded to. It had nothing to do with
> client side printing. I responded spefically about the new web and winform
> report viewer controls.
> SP2 WILL have the ability for client side printing. Two different things
> here.
> Also, in case you haven't seen, SP2 will be out mid month. It was delayed a
> couple of weeks (originally they were targeting the end of March for
> release).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ranga" <ranga@.discussions.microsoft.com> wrote in message
> news:D03BC10F-F046-4EDA-8852-330ACD8BE054@.microsoft.com...
> > >> other posts in this group seem to indicate that client side printing is
> > one of
> > the major features of sp2 - have they pulled the plug on this feature for
> > sp2 ?
> >
> > >> if client-side printing is not going to be in sp2, then what other
> alternative is there ? (using pdf is ok but getting adobe to start is a slow
> process ; popping up
> > a browser window in a winform app does not look clean; using a web browser
> > control in a windows-forms app is also not clean (the control does not
> have a
> > print button)
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > I can confirm that SP2 does not have the new webform/winform controls.
> That
> > > will be coming out with the next beta of Widbey (next version of Visual
> > > Studio).
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "ranga" <ranga@.discussions.microsoft.com> wrote in message
> > > news:82EFEFC5-44F7-425D-84D9-90538A9BDA91@.microsoft.com...
> > > > can anyone confirm if rs-sp2 will have a report viewer control for
> > > winforms
> > > > and webforms ? - is this a pure .NET control or is it ActiveX
> > > >
> > > > also where can i find a list of featuers/bugfixes for sp2?
> > > >
> > > > thanks
> > > >
> > > > "Joerg" wrote:
> > > >
> > > > > http://www.microsoft.com/windowsserversystem/default.mspx
> > > > >
> > > > > "Download SQL Reporting Services SP2 and New Report Packs
> > > > > Get the latest downloads for SQL Server Reporting Services,
> including
> > > > > Service Pack
> > > > > 2 and new report packs for IIS and Great Plains."
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||Last word was mid-month. Doesn't look like it made that. I am hoping before
the end of the month but I have no inside scoop. I am waiting for it as well
prior to my datamart going into production.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lori" <Lori@.discussions.microsoft.com> wrote in message
news:EDE271FC-2DB4-48C3-8831-B31A26ECDCFD@.microsoft.com...
> Is there any update on when SP2 will actually be coming out? It's now
> April
> 21st & no SP2?
> "Bruce L-C [MVP]" wrote:
>> Please look at the post that I responded to. It had nothing to do with
>> client side printing. I responded spefically about the new web and
>> winform
>> report viewer controls.
>> SP2 WILL have the ability for client side printing. Two different things
>> here.
>> Also, in case you haven't seen, SP2 will be out mid month. It was delayed
>> a
>> couple of weeks (originally they were targeting the end of March for
>> release).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ranga" <ranga@.discussions.microsoft.com> wrote in message
>> news:D03BC10F-F046-4EDA-8852-330ACD8BE054@.microsoft.com...
>> > >> other posts in this group seem to indicate that client side printing
>> > >> is
>> > one of
>> > the major features of sp2 - have they pulled the plug on this feature
>> > for
>> > sp2 ?
>> >
>> > >> if client-side printing is not going to be in sp2, then what other
>> alternative is there ? (using pdf is ok but getting adobe to start is a
>> slow
>> process ; popping up
>> > a browser window in a winform app does not look clean; using a web
>> > browser
>> > control in a windows-forms app is also not clean (the control does not
>> have a
>> > print button)
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> > > I can confirm that SP2 does not have the new webform/winform
>> > > controls.
>> That
>> > > will be coming out with the next beta of Widbey (next version of
>> > > Visual
>> > > Studio).
>> > >
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > >
>> > > "ranga" <ranga@.discussions.microsoft.com> wrote in message
>> > > news:82EFEFC5-44F7-425D-84D9-90538A9BDA91@.microsoft.com...
>> > > > can anyone confirm if rs-sp2 will have a report viewer control for
>> > > winforms
>> > > > and webforms ? - is this a pure .NET control or is it ActiveX
>> > > >
>> > > > also where can i find a list of featuers/bugfixes for sp2?
>> > > >
>> > > > thanks
>> > > >
>> > > > "Joerg" wrote:
>> > > >
>> > > > > http://www.microsoft.com/windowsserversystem/default.mspx
>> > > > >
>> > > > > "Download SQL Reporting Services SP2 and New Report Packs
>> > > > > Get the latest downloads for SQL Server Reporting Services,
>> including
>> > > > > Service Pack
>> > > > > 2 and new report packs for IIS and Great Plains."
>> > > > >
>> > > > >
>> > > > >
>> > > > >
>> > > > >
>> > > > >
>> > >
>> > >
>> > >
>>|||Thanks for the quick response Bruce! I will keep checking back here for
updates.
"Bruce L-C [MVP]" wrote:
> Last word was mid-month. Doesn't look like it made that. I am hoping before
> the end of the month but I have no inside scoop. I am waiting for it as well
> prior to my datamart going into production.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lori" <Lori@.discussions.microsoft.com> wrote in message
> news:EDE271FC-2DB4-48C3-8831-B31A26ECDCFD@.microsoft.com...
> > Is there any update on when SP2 will actually be coming out? It's now
> > April
> > 21st & no SP2?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Please look at the post that I responded to. It had nothing to do with
> >> client side printing. I responded spefically about the new web and
> >> winform
> >> report viewer controls.
> >>
> >> SP2 WILL have the ability for client side printing. Two different things
> >> here.
> >>
> >> Also, in case you haven't seen, SP2 will be out mid month. It was delayed
> >> a
> >> couple of weeks (originally they were targeting the end of March for
> >> release).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "ranga" <ranga@.discussions.microsoft.com> wrote in message
> >> news:D03BC10F-F046-4EDA-8852-330ACD8BE054@.microsoft.com...
> >> > >> other posts in this group seem to indicate that client side printing
> >> > >> is
> >> > one of
> >> > the major features of sp2 - have they pulled the plug on this feature
> >> > for
> >> > sp2 ?
> >> >
> >> > >> if client-side printing is not going to be in sp2, then what other
> >> alternative is there ? (using pdf is ok but getting adobe to start is a
> >> slow
> >> process ; popping up
> >> > a browser window in a winform app does not look clean; using a web
> >> > browser
> >> > control in a windows-forms app is also not clean (the control does not
> >> have a
> >> > print button)
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> > > I can confirm that SP2 does not have the new webform/winform
> >> > > controls.
> >> That
> >> > > will be coming out with the next beta of Widbey (next version of
> >> > > Visual
> >> > > Studio).
> >> > >
> >> > > --
> >> > > Bruce Loehle-Conger
> >> > > MVP SQL Server Reporting Services
> >> > >
> >> > > "ranga" <ranga@.discussions.microsoft.com> wrote in message
> >> > > news:82EFEFC5-44F7-425D-84D9-90538A9BDA91@.microsoft.com...
> >> > > > can anyone confirm if rs-sp2 will have a report viewer control for
> >> > > winforms
> >> > > > and webforms ? - is this a pure .NET control or is it ActiveX
> >> > > >
> >> > > > also where can i find a list of featuers/bugfixes for sp2?
> >> > > >
> >> > > > thanks
> >> > > >
> >> > > > "Joerg" wrote:
> >> > > >
> >> > > > > http://www.microsoft.com/windowsserversystem/default.mspx
> >> > > > >
> >> > > > > "Download SQL Reporting Services SP2 and New Report Packs
> >> > > > > Get the latest downloads for SQL Server Reporting Services,
> >> including
> >> > > > > Service Pack
> >> > > > > 2 and new report packs for IIS and Great Plains."
> >> > > > >
> >> > > > >
> >> > > > >
> >> > > > >
> >> > > > >
> >> > > > >
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>

RS and Netscape 7.0

I am having problems accessing the report manager with Netscape 7.0. I am
not exaclty sure why, but it is related to authentication. By default, the
IIS resource is configured for Windows authentication, which does not seem
to work with Netscape. I get an empty main page. I tried text
authentication, which make Netscape challange me for a user/password, but
still does not allow me to access the reports.
I assume that this should work? Thanks.I have some more information:
- I installed RS using the default settings for services account and
database access.
- My data source is configured to use integrated security.
- When I try to access the report manager with IE, it works
- When I try to access it with Netscape 7.02, I get an access denied error
- When I add basic auth to the IIS resource and access it with Netscape, I
get challanged
- When I provide my server credential (member of the admin group), I am
authenticated and I see the report manager's home page
- When I click on a report (IE), it renders fine
- When I click on a report (Netscape), I see the top navigation and an
otherwise empty page
"Christian Donner" <stealthcdonner@.stealthmolecular.comremovestealth> wrote
in message news:OvbIi8OlEHA.3544@.TK2MSFTNGP15.phx.gbl...
> I am having problems accessing the report manager with Netscape 7.0. I am
> not exaclty sure why, but it is related to authentication. By default, the
> IIS resource is configured for Windows authentication, which does not seem
> to work with Netscape. I get an empty main page. I tried text
> authentication, which make Netscape challange me for a user/password, but
> still does not allow me to access the reports.
> I assume that this should work? Thanks.
>|||And still more information:
I changed the data source authentication to SQL Server and provided an
account.
I am running the AdventureWorks Sales Reports sample.
The IFRAME that is supposed to show the report on the Report Manager page is
empty.
When I paste the report URL from the IFRAME statement into IE, I get to see
the report.
When I paste the same URL into Netscape, I get to see the report, but no
numbers (just the blue table structure). The table dimensions seem to be
correct, though. When I export from Netscape to PDF, the report is fine.
"Christian Donner" <stealthcdonner@.stealthmolecular.comremovestealth> wrote
in message news:%23XWD2cPlEHA.3392@.TK2MSFTNGP15.phx.gbl...
> I have some more information:
> - I installed RS using the default settings for services account and
> database access.
> - My data source is configured to use integrated security.
> - When I try to access the report manager with IE, it works
> - When I try to access it with Netscape 7.02, I get an access denied error
> - When I add basic auth to the IIS resource and access it with Netscape, I
> get challanged
> - When I provide my server credential (member of the admin group), I am
> authenticated and I see the report manager's home page
> - When I click on a report (IE), it renders fine
> - When I click on a report (Netscape), I see the top navigation and an
> otherwise empty page
> "Christian Donner" <stealthcdonner@.stealthmolecular.comremovestealth>
wrote
> in message news:OvbIi8OlEHA.3544@.TK2MSFTNGP15.phx.gbl...
> > I am having problems accessing the report manager with Netscape 7.0. I
am
> > not exaclty sure why, but it is related to authentication. By default,
the
> > IIS resource is configured for Windows authentication, which does not
seem
> > to work with Netscape. I get an empty main page. I tried text
> > authentication, which make Netscape challange me for a user/password,
but
> > still does not allow me to access the reports.
> > I assume that this should work? Thanks.
> >
> >
>

RS 2005 SP2 - Multivalue (Select All) I want to set it as Default

I am using a Reporting Services 2005 with the SP2.
I want to select as default (Select All) row on the multivalue dropdown
list, which is going to virtually select all my options on the dropdown list.
Is there any way to accomplish that?
Thanks a lot.On Oct 10, 10:17 am, Francisco Cruz <Francisco
C...@.discussions.microsoft.com> wrote:
> I am using a Reporting Services 2005 with the SP2.
> I want to select as default (Select All) row on the multivalue dropdown
> list, which is going to virtually select all my options on the dropdown list.
> Is there any way to accomplish that?
> Thanks a lot.
You should just be able to select 'Default values:' >> 'From query' as
part of the Report Parameters and set the Dataset and Value fields to
the same values as the 'Available values.' Also, make sure that the
Multi-value radio button is selected. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" wrote:
> On Oct 10, 10:17 am, Francisco Cruz <Francisco
> C...@.discussions.microsoft.com> wrote:
> > I am using a Reporting Services 2005 with the SP2.
> > I want to select as default (Select All) row on the multivalue dropdown
> > list, which is going to virtually select all my options on the dropdown list.
> > Is there any way to accomplish that?
> > Thanks a lot.
>
> You should just be able to select 'Default values:' >> 'From query' as
> part of the Report Parameters and set the Dataset and Value fields to
> the same values as the 'Available values.' Also, make sure that the
> Multi-value radio button is selected. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Thanks a lot Enrique,
It works great.
In other words, the Available Values Data Source must be used on the Default
Values as well.
This how I have it and it works, ***DepartmentDataSet*** is used twice
Report Parameters Window:
Properties
Name: pDepartment
Data Type: String
Prompt: Department
Multi Value: Check
Available Values
From Query:
Data Set: ***DepartmentDataSet***
Value Field: Department_Id
Label Field: Department_Name
Default Values
From Query:
Data Set: ***DepartmentDataSet***
Value Field: Department_Id