rsAccessDenied with Forms Authentication

I have implemented custom forms authentication with Reporting Services and
everything worked fine. I was able able to deploy reports from Visual
Studio 2003, VS would prompt me to enter a valid UserID and Password.
Recently, I have changed workstations and installed a new copy of visual
studio 2003. When I try to deploy a report to the same report server, I get
the following error:
The permissions granted to user '' are insufficient for performing this
operation.
VS does not prompt me to enter a userID and password and simply fails to
authenticate. I am still able to login direcly to report manager and
report server directly without any problems.
I am running:
** Workstation
OS: Windows XP Pro
Visual Studio 2003
** Server:
Windows 2000 Server SP 4
Reporting Services with Service Pack 1
Could someone please give some hints on what went wrong?
Thanks,
- Adil -Was the original install of Visual Studio on the same box as the server?
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> I have implemented custom forms authentication with Reporting Services and
> everything worked fine. I was able able to deploy reports from Visual
> Studio 2003, VS would prompt me to enter a valid UserID and Password.
> Recently, I have changed workstations and installed a new copy of visual
> studio 2003. When I try to deploy a report to the same report server, I
get
> the following error:
> The permissions granted to user '' are insufficient for performing this
> operation.
> VS does not prompt me to enter a userID and password and simply fails to
> authenticate. I am still able to login direcly to report manager and
> report server directly without any problems.
> I am running:
> ** Workstation
> OS: Windows XP Pro
> Visual Studio 2003
> ** Server:
> Windows 2000 Server SP 4
> Reporting Services with Service Pack 1
> Could someone please give some hints on what went wrong?
> Thanks,
> - Adil -
>
>|||Bryan,
No, the original installation of Visual studio was not on the Server. It was
on a Windows 2000 Workstation.
- Adil -
"Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> Was the original install of Visual Studio on the same box as the server?
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > I have implemented custom forms authentication with Reporting Services
and
> > everything worked fine. I was able able to deploy reports from Visual
> > Studio 2003, VS would prompt me to enter a valid UserID and Password.
> > Recently, I have changed workstations and installed a new copy of visual
> > studio 2003. When I try to deploy a report to the same report server, I
> get
> > the following error:
> >
> > The permissions granted to user '' are insufficient for performing this
> > operation.
> >
> > VS does not prompt me to enter a userID and password and simply fails to
> > authenticate. I am still able to login direcly to report manager and
> > report server directly without any problems.
> >
> > I am running:
> > ** Workstation
> > OS: Windows XP Pro
> > Visual Studio 2003
> >
> > ** Server:
> > Windows 2000 Server SP 4
> > Reporting Services with Service Pack 1
> >
> > Could someone please give some hints on what went wrong?
> >
> > Thanks,
> > - Adil -
> >
> >
> >
>|||Okay, VS should prompt for credentials when using Forms auth. You obviously
reinstalled the Designer on the new VS box correct? Are you using a report
project from the old install? If so, try deleting the .user and .suo files
for your project and deploying again.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> Bryan,
> No, the original installation of Visual studio was not on the Server. It
was
> on a Windows 2000 Workstation.
> - Adil -
> "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > Was the original install of Visual Studio on the same box as the server?
> >
> > --
> > Bryan Keller
> > Developer Documentation
> > SQL Server Reporting Services
> >
> > A friendly reminder that this posting is provided "AS IS" with no
> > warranties, and confers no rights.
> >
> >
> > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > I have implemented custom forms authentication with Reporting Services
> and
> > > everything worked fine. I was able able to deploy reports from Visual
> > > Studio 2003, VS would prompt me to enter a valid UserID and Password.
> > > Recently, I have changed workstations and installed a new copy of
visual
> > > studio 2003. When I try to deploy a report to the same report server,
I
> > get
> > > the following error:
> > >
> > > The permissions granted to user '' are insufficient for performing
this
> > > operation.
> > >
> > > VS does not prompt me to enter a userID and password and simply fails
to
> > > authenticate. I am still able to login direcly to report manager and
> > > report server directly without any problems.
> > >
> > > I am running:
> > > ** Workstation
> > > OS: Windows XP Pro
> > > Visual Studio 2003
> > >
> > > ** Server:
> > > Windows 2000 Server SP 4
> > > Reporting Services with Service Pack 1
> > >
> > > Could someone please give some hints on what went wrong?
> > >
> > > Thanks,
> > > - Adil -
> > >
> > >
> > >
> >
> >
>|||Bryan,
Thanks for the help. I found the bug and it was in my code! (<-- Very rare!
:))
Apparently, it seems that when you try to deploy from VS for the first time,
VS sends a blank UserID and Password to ReportServer. This call normally
fails and the Login dialog box is therefore displayed.
In my case, the LogonUser method returned a boolean true for a blank
UserName and Password (<-- Bug in security extension), so VS moved on to the
Authorization phase which failed because no permissions have been assigned
to the blank user. Hence the error message:
"The permissions granted to user '' are insufficient for performing
this operation."
The problem disapeared as soon as I set the LogonUser method of the security
extension to return a "false" when the userName is blank.
- Adil -
"Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
news:OHlkL08eEHA.3028@.TK2MSFTNGP12.phx.gbl...
> Okay, VS should prompt for credentials when using Forms auth. You
obviously
> reinstalled the Designer on the new VS box correct? Are you using a report
> project from the old install? If so, try deleting the .user and .suo files
> for your project and deploying again.
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> > Bryan,
> >
> > No, the original installation of Visual studio was not on the Server. It
> was
> > on a Windows 2000 Workstation.
> >
> > - Adil -
> >
> > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > > Was the original install of Visual Studio on the same box as the
server?
> > >
> > > --
> > > Bryan Keller
> > > Developer Documentation
> > > SQL Server Reporting Services
> > >
> > > A friendly reminder that this posting is provided "AS IS" with no
> > > warranties, and confers no rights.
> > >
> > >
> > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > > I have implemented custom forms authentication with Reporting
Services
> > and
> > > > everything worked fine. I was able able to deploy reports from
Visual
> > > > Studio 2003, VS would prompt me to enter a valid UserID and
Password.
> > > > Recently, I have changed workstations and installed a new copy of
> visual
> > > > studio 2003. When I try to deploy a report to the same report
server,
> I
> > > get
> > > > the following error:
> > > >
> > > > The permissions granted to user '' are insufficient for performing
> this
> > > > operation.
> > > >
> > > > VS does not prompt me to enter a userID and password and simply
fails
> to
> > > > authenticate. I am still able to login direcly to report manager
and
> > > > report server directly without any problems.
> > > >
> > > > I am running:
> > > > ** Workstation
> > > > OS: Windows XP Pro
> > > > Visual Studio 2003
> > > >
> > > > ** Server:
> > > > Windows 2000 Server SP 4
> > > > Reporting Services with Service Pack 1
> > > >
> > > > Could someone please give some hints on what went wrong?
> > > >
> > > > Thanks,
> > > > - Adil -
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Great news. I'm glad you tracked that down.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
news:ulz671ZfEHA.1048@.tk2msftngp13.phx.gbl...
> Bryan,
> Thanks for the help. I found the bug and it was in my code! (<-- Very
rare!
> :))
> Apparently, it seems that when you try to deploy from VS for the first
time,
> VS sends a blank UserID and Password to ReportServer. This call normally
> fails and the Login dialog box is therefore displayed.
> In my case, the LogonUser method returned a boolean true for a blank
> UserName and Password (<-- Bug in security extension), so VS moved on to
the
> Authorization phase which failed because no permissions have been assigned
> to the blank user. Hence the error message:
> "The permissions granted to user '' are insufficient for
performing
> this operation."
> The problem disapeared as soon as I set the LogonUser method of the
security
> extension to return a "false" when the userName is blank.
> - Adil -
> "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> news:OHlkL08eEHA.3028@.TK2MSFTNGP12.phx.gbl...
> > Okay, VS should prompt for credentials when using Forms auth. You
> obviously
> > reinstalled the Designer on the new VS box correct? Are you using a
report
> > project from the old install? If so, try deleting the .user and .suo
files
> > for your project and deploying again.
> > --
> > Bryan Keller
> > Developer Documentation
> > SQL Server Reporting Services
> >
> > A friendly reminder that this posting is provided "AS IS" with no
> > warranties, and confers no rights.
> >
> >
> > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> > > Bryan,
> > >
> > > No, the original installation of Visual studio was not on the Server.
It
> > was
> > > on a Windows 2000 Workstation.
> > >
> > > - Adil -
> > >
> > > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > > news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > > > Was the original install of Visual Studio on the same box as the
> server?
> > > >
> > > > --
> > > > Bryan Keller
> > > > Developer Documentation
> > > > SQL Server Reporting Services
> > > >
> > > > A friendly reminder that this posting is provided "AS IS" with no
> > > > warranties, and confers no rights.
> > > >
> > > >
> > > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > > > I have implemented custom forms authentication with Reporting
> Services
> > > and
> > > > > everything worked fine. I was able able to deploy reports from
> Visual
> > > > > Studio 2003, VS would prompt me to enter a valid UserID and
> Password.
> > > > > Recently, I have changed workstations and installed a new copy of
> > visual
> > > > > studio 2003. When I try to deploy a report to the same report
> server,
> > I
> > > > get
> > > > > the following error:
> > > > >
> > > > > The permissions granted to user '' are insufficient for
performing
> > this
> > > > > operation.
> > > > >
> > > > > VS does not prompt me to enter a userID and password and simply
> fails
> > to
> > > > > authenticate. I am still able to login direcly to report manager
> and
> > > > > report server directly without any problems.
> > > > >
> > > > > I am running:
> > > > > ** Workstation
> > > > > OS: Windows XP Pro
> > > > > Visual Studio 2003
> > > > >
> > > > > ** Server:
> > > > > Windows 2000 Server SP 4
> > > > > Reporting Services with Service Pack 1
> > > > >
> > > > > Could someone please give some hints on what went wrong?
> > > > >
> > > > > Thanks,
> > > > > - Adil -
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||I too am having this exact problem. I'm trying to publish my reports using
the batch rs method. Where do I set my logon credentials there, I never see
a pop-up.
Thanks,
Gabe
"Bryan Keller [MSFT]" wrote:
> Great news. I'm glad you tracked that down.
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> news:ulz671ZfEHA.1048@.tk2msftngp13.phx.gbl...
> > Bryan,
> > Thanks for the help. I found the bug and it was in my code! (<-- Very
> rare!
> > :))
> > Apparently, it seems that when you try to deploy from VS for the first
> time,
> > VS sends a blank UserID and Password to ReportServer. This call normally
> > fails and the Login dialog box is therefore displayed.
> > In my case, the LogonUser method returned a boolean true for a blank
> > UserName and Password (<-- Bug in security extension), so VS moved on to
> the
> > Authorization phase which failed because no permissions have been assigned
> > to the blank user. Hence the error message:
> > "The permissions granted to user '' are insufficient for
> performing
> > this operation."
> >
> > The problem disapeared as soon as I set the LogonUser method of the
> security
> > extension to return a "false" when the userName is blank.
> >
> > - Adil -
> >
> > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > news:OHlkL08eEHA.3028@.TK2MSFTNGP12.phx.gbl...
> > > Okay, VS should prompt for credentials when using Forms auth. You
> > obviously
> > > reinstalled the Designer on the new VS box correct? Are you using a
> report
> > > project from the old install? If so, try deleting the .user and .suo
> files
> > > for your project and deploying again.
> > > --
> > > Bryan Keller
> > > Developer Documentation
> > > SQL Server Reporting Services
> > >
> > > A friendly reminder that this posting is provided "AS IS" with no
> > > warranties, and confers no rights.
> > >
> > >
> > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > news:ew3XA%23yeEHA.1100@.TK2MSFTNGP10.phx.gbl...
> > > > Bryan,
> > > >
> > > > No, the original installation of Visual studio was not on the Server.
> It
> > > was
> > > > on a Windows 2000 Workstation.
> > > >
> > > > - Adil -
> > > >
> > > > "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
> > > > news:%23Njq%23WjeEHA.1652@.TK2MSFTNGP10.phx.gbl...
> > > > > Was the original install of Visual Studio on the same box as the
> > server?
> > > > >
> > > > > --
> > > > > Bryan Keller
> > > > > Developer Documentation
> > > > > SQL Server Reporting Services
> > > > >
> > > > > A friendly reminder that this posting is provided "AS IS" with no
> > > > > warranties, and confers no rights.
> > > > >
> > > > >
> > > > > "Adil Elkhiyari" <adil1@.transinfo.com> wrote in message
> > > > > news:eGmMtNKeEHA.3744@.TK2MSFTNGP12.phx.gbl...
> > > > > > I have implemented custom forms authentication with Reporting
> > Services
> > > > and
> > > > > > everything worked fine. I was able able to deploy reports from
> > Visual
> > > > > > Studio 2003, VS would prompt me to enter a valid UserID and
> > Password.
> > > > > > Recently, I have changed workstations and installed a new copy of
> > > visual
> > > > > > studio 2003. When I try to deploy a report to the same report
> > server,
> > > I
> > > > > get
> > > > > > the following error:
> > > > > >
> > > > > > The permissions granted to user '' are insufficient for
> performing
> > > this
> > > > > > operation.
> > > > > >
> > > > > > VS does not prompt me to enter a userID and password and simply
> > fails
> > > to
> > > > > > authenticate. I am still able to login direcly to report manager
> > and
> > > > > > report server directly without any problems.
> > > > > >
> > > > > > I am running:
> > > > > > ** Workstation
> > > > > > OS: Windows XP Pro
> > > > > > Visual Studio 2003
> > > > > >
> > > > > > ** Server:
> > > > > > Windows 2000 Server SP 4
> > > > > > Reporting Services with Service Pack 1
> > > > > >
> > > > > > Could someone please give some hints on what went wrong?
> > > > > >
> > > > > > Thanks,
> > > > > > - Adil -
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

RS2005 visual studio design tool

RS2005 ships with a version of visual studio 2005 for report development.
What if I have visual studio 2005 on my local machine. How can I add the
rs2005 shell locally? Are they any license issues?
ThanksI found that if I install VS 2005 after the report designer I lost the
report designer. My suggestion is to first install VS 2005. Then using the
setup for SQL Server 2005 install the Reporting Services client tools (i.e.
the report designer). This will cause the designer to be installed and
integrated with the VS that you already have installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tcs" <tcs@.discussions.microsoft.com> wrote in message
news:AB535062-7477-4798-8027-AC82209C7A1C@.microsoft.com...
> RS2005 ships with a version of visual studio 2005 for report development.
> What if I have visual studio 2005 on my local machine. How can I add the
> rs2005 shell locally? Are they any license issues?
> Thanks|||Fortunatly, I had VS installed already so did not come across this issue.
After installing sql, the report projects are right there in VS and work
well. Damn fine work on this RS stuff - hat off to MS.
--
William Stacey [MVP]
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eFLBnAGAGHA.140@.TK2MSFTNGP12.phx.gbl...
>I found that if I install VS 2005 after the report designer I lost the
>report designer. My suggestion is to first install VS 2005. Then using the
>setup for SQL Server 2005 install the Reporting Services client tools (i.e.
>the report designer). This will cause the designer to be installed and
>integrated with the VS that you already have installed.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "tcs" <tcs@.discussions.microsoft.com> wrote in message
> news:AB535062-7477-4798-8027-AC82209C7A1C@.microsoft.com...
>> RS2005 ships with a version of visual studio 2005 for report development.
>> What if I have visual studio 2005 on my local machine. How can I add the
>> rs2005 shell locally? Are they any license issues?
>> Thanks
>|||Thanks to you both
"William Stacey [MVP]" wrote:
> Fortunatly, I had VS installed already so did not come across this issue.
> After installing sql, the report projects are right there in VS and work
> well. Damn fine work on this RS stuff - hat off to MS.
> --
> William Stacey [MVP]
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eFLBnAGAGHA.140@.TK2MSFTNGP12.phx.gbl...
> >I found that if I install VS 2005 after the report designer I lost the
> >report designer. My suggestion is to first install VS 2005. Then using the
> >setup for SQL Server 2005 install the Reporting Services client tools (i.e.
> >the report designer). This will cause the designer to be installed and
> >integrated with the VS that you already have installed.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "tcs" <tcs@.discussions.microsoft.com> wrote in message
> > news:AB535062-7477-4798-8027-AC82209C7A1C@.microsoft.com...
> >> RS2005 ships with a version of visual studio 2005 for report development.
> >> What if I have visual studio 2005 on my local machine. How can I add the
> >> rs2005 shell locally? Are they any license issues?
> >>
> >> Thanks
> >
> >
>
>

RS2005 viewer control connection problem.

I am using the reporting services reportviewer control from Visual Studio®
2005 Beta 2.
When I run a repmote report I get the following error:
[WebException: The request was aborted: The connection was closed
unexpectedly.]
I can access the report from my browser doing a straight url access.
I am using RS2005 (did not install anything other than that from SQLServer
2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a different
machine for RS engine.
The report data source is on the same SQL server machine as the RS database.
can anyone explain what is happening.
Thanks Fred
--
FredI'm having the same problem here.
VS 2005 Beta 2, SQL 2005 April CTP.
Have you found what was causing the problem?
Anderson
Fred escreveu:
> I am using the reporting services reportviewer control from Visual Studio==AE
> 2005 Beta 2.
> When I run a repmote report I get the following error:
> [WebException: The request was aborted: The connection was closed
> unexpectedly.]
> I can access the report from my browser doing a straight url access.
> I am using RS2005 (did not install anything other than that from SQLServer
> 2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a diffe=rent
> machine for RS engine.
> The report data source is on the same SQL server machine as the RS databa=se.
> can anyone explain what is happening.
> > Thanks Fred
> > > > > > > -- > Fred|||No,
due to other we may actually not user RS2005 anyway, so not such a burnig
issue for the moment.
I still would like to know what's going on though.
I'm using SQLServer 2000 as the RS backend, the datasource is on the same
machine as SQL2000. RS sits on its own machine.
--
Fred
"Anderson dos Santos Pimentel" wrote:
> I'm having the same problem here.
> VS 2005 Beta 2, SQL 2005 April CTP.
> Have you found what was causing the problem?
>
> Anderson
>
> Fred escreveu:
> > I am using the reporting services reportviewer control from Visual Studio®
> > 2005 Beta 2.
> >
> > When I run a repmote report I get the following error:
> >
> > [WebException: The request was aborted: The connection was closed
> > unexpectedly.]
> >
> > I can access the report from my browser doing a straight url access.
> >
> > I am using RS2005 (did not install anything other than that from SQLServer
> > 2005 cd) on Windows 2003 server, and a SQLserver 2000 back end on a different
> > machine for RS engine.
> >
> > The report data source is on the same SQL server machine as the RS database.
> >
> > can anyone explain what is happening.
> >
> > Thanks Fred
> >
> >
> >
> >
> >
> >
> > --
> > Fred
>|||I've finally found the problem.
I was dumb enough to mistype the server's name... :-)
Now, it's OK!
Andersonsql

RS2000/VS2003 RS2005 Viewer control

We have reports written using Visual Studio 2003, and deployed on a server
running Reporting services 2000. This is OK and working.
Is it possible to write a web page using Visual Studio 2005, and the new
ReportViewer control (Microsoft.Reporting.WebForms.ReportViewer
) to render these reports.
I'm setting the ReportPath and ReportServerUrl but I'm getting the following
error.
Using VS2003 and the RS2000 webservice with the same values worked...
[WebException: The request failed with HTTP status 404: Not Found.]
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +242
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +86
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname) +33
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +68
[MissingEndpointException: The attempt to connect to the report server
failed. Check your connection information and that the report server is a
compatible version.]
Microsoft.SqlServer.ReportingServices2005.Execution.MissingEndpointException.ThrowIfEndpointMissing(WebException e) +129
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +147
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean
useCurrentValues) +137
Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +184
System.Web.UI.Control.PreRenderRecursiveInternal() +148
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5036
Any help appreciated.
--
FredThe Report Viewer control requires running against RS2005.
There are Server side changes that RS2000 does not have.
--
| Thread-Topic: RS2000/VS2003 RS2005 Viewer control
| thread-index: AcWol1mSmeVTJhrpSOyD8QdgJNzP3g==| X-WBNR-Posting-Host: 62.188.58.81
| From: "=?Utf-8?B?RnJlZA==?=" <Fred@.discussions.microsoft.com>
| Subject: RS2000/VS2003 RS2005 Viewer control
| Date: Wed, 24 Aug 2005 03:34:04 -0700
| Lines: 50
| Message-ID: <2E7C722F-2A27-4176-816E-10517D4B25DC@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:51025
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| We have reports written using Visual Studio 2003, and deployed on a
server
| running Reporting services 2000. This is OK and working.
|
| Is it possible to write a web page using Visual Studio 2005, and the new
| ReportViewer control (Microsoft.Reporting.WebForms.ReportViewer
| ) to render these reports.
|
|
| I'm setting the ReportPath and ReportServerUrl but I'm getting the
following
| error.
|
| Using VS2003 and the RS2000 webservice with the same values worked...
|
|
|
| [WebException: The request failed with HTTP status 404: Not Found.]
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Ge
tSecureMethods() +242
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Is
SecureMethod(String methodname) +86
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Se
tConnectionSSLForMethod(String methodname) +33
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Lo
adReport(String Report, String HistoryID) +68
|
| [MissingEndpointException: The attempt to connect to the report server
| failed. Check your connection information and that the report server is
a
| compatible version.]
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.MissingEndpointException
ThrowIfEndpointMissing(WebException e) +129
|
|
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.Lo
adReport(String Report, String HistoryID) +147
| Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +249
| Microsoft.Reporting.WebForms.ServerReport.GetParameters() +40
|
Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean
| useCurrentValues) +137
| Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e) +184
| System.Web.UI.Control.PreRenderRecursiveInternal() +148
| System.Web.UI.Control.PreRenderRecursiveInternal() +233
| System.Web.UI.Control.PreRenderRecursiveInternal() +233
| System.Web.UI.Page.ProcessRequestMain(Boolean
| includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5036
|
|
|
|
| Any help appreciated.
|
| --
| Fred
|

RS: does not work without Visual Studio?

Hello,
i've installed Reporting Services on "Windows 2000 Server" and "SQL Server
2000 SP3a".
During the setup a window popped up with the "System Check Results" showing
a warning that "Visual Studio .net 2003" is not installed.
I've continued the setup process without any other warnings.
Then I've tried to find RS.. it is not in the program menu, there is only
"Reporting Services Books online - english".
There is also nothing in the menuebar of "Enterprise Manager".
Is it really necessary to install Visual Studio on a server'
I hope somebody can help me.
Greetings
Hendrik
--
Message posted via http://www.sqlmonster.comHendrik,
You should be able to access the reports server on your server machine at
the following address:
http://<servername>/reports
This should take you to the Reports Manager. You only need VS2003 installed
on a machine that you are going to use to design and develop the reports on.
Regards,
DF
"Hendrik Schulz via SQLMonster.com" wrote:
> Hello,
> i've installed Reporting Services on "Windows 2000 Server" and "SQL Server
> 2000 SP3a".
> During the setup a window popped up with the "System Check Results" showing
> a warning that "Visual Studio .net 2003" is not installed.
> I've continued the setup process without any other warnings.
> Then I've tried to find RS.. it is not in the program menu, there is only
> "Reporting Services Books online - english".
> There is also nothing in the menuebar of "Enterprise Manager".
> Is it really necessary to install Visual Studio on a server'
> I hope somebody can help me.
> Greetings
> Hendrik
> --
> Message posted via http://www.sqlmonster.com
>|||One other point to help explain why you are not seeing anything. Reporting
Services is an asp.net application. That is why you do not see anything in
the different places you looked. Just like any other website/asp.net
application. Only IIS knows about it.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Fell" <DanFell@.discussions.microsoft.com> wrote in message
news:6B5CBEDA-D6E4-4E0A-A79F-B41B00D310EF@.microsoft.com...
> Hendrik,
> You should be able to access the reports server on your server machine at
> the following address:
> http://<servername>/reports
> This should take you to the Reports Manager. You only need VS2003
installed
> on a machine that you are going to use to design and develop the reports
on.
> Regards,
> DF
> "Hendrik Schulz via SQLMonster.com" wrote:
> > Hello,
> >
> > i've installed Reporting Services on "Windows 2000 Server" and "SQL
Server
> > 2000 SP3a".
> > During the setup a window popped up with the "System Check Results"
showing
> > a warning that "Visual Studio .net 2003" is not installed.
> > I've continued the setup process without any other warnings.
> > Then I've tried to find RS.. it is not in the program menu, there is
only
> > "Reporting Services Books online - english".
> > There is also nothing in the menuebar of "Enterprise Manager".
> >
> > Is it really necessary to install Visual Studio on a server'
> >
> > I hope somebody can help me.
> >
> > Greetings
> > Hendrik
> >
> > --
> > Message posted via http://www.sqlmonster.com
> >|||Thank you all very much, now it works und looks really good!
--
Message posted via http://www.sqlmonster.com

RS OLAP Connection Problem

I have a stand alone win2k3 reporting services server(i.e. SQL is not on the
box). RS SP1 is installed.
I have a SQLRS report developed in visual studio (on the same box) that runs
MDX against an analysis services cube. I am using the OLE DB provider for
OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting
services server to get the pivot table service and 8.0 provider to be
available)
I can successfully connect to Analysis Services and preview the report in
visual studio.
When I run the report in Report Manger, the report bombs with...
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'ServerNameBlahBlah'.
(rsErrorOpeningConnection) Get Online Help
Database 'CubeNameBlahBlah' does not exist.
I have a AS database role setup that should allow the stored
credentials to successfully authenticate.
HELP !!!!That is what you get when you don't have rights to the AS datasource. Open
Visual Studio Report Designer by right-clicking and choosing "Run as" and
choose the same credentials you are using as stored credentials for the AS
datasource. See if you can then preview the report, you will probably get a
similar error.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"James" <carbonc@.carbonc.com> wrote in message
news:e8X%231pbJFHA.3928@.TK2MSFTNGP09.phx.gbl...
>I have a stand alone win2k3 reporting services server(i.e. SQL is not on
>the
> box). RS SP1 is installed.
> I have a SQLRS report developed in visual studio (on the same box) that
> runs
> MDX against an analysis services cube. I am using the OLE DB provider for
> OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting
> services server to get the pivot table service and 8.0 provider to be
> available)
> I can successfully connect to Analysis Services and preview the report in
> visual studio.
> When I run the report in Report Manger, the report bombs with...
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'ServerNameBlahBlah'.
> (rsErrorOpeningConnection) Get Online Help
> Database 'CubeNameBlahBlah' does not exist.
> I have a AS database role setup that should allow the stored
> credentials to successfully authenticate.
>
> HELP !!!!
>

RS Layout and Preview Tab - SLOW

Hello, I have been working with Reporting Services for several months and really like it. I am using Visual Studio .net for developing reports. I have noticed a long delay when changing between the 'Layout Tab' and the 'Preview Tab'. The delay is between 10 and 15 seconds which may not seem like much but adds up over time. Does anyone know if this is an issue with RS or the .net environment? Are there settings to change to make this change quicker? I know each time you change from one tab to another a new .rdl file has to be built but I have witnessed several demos from Microsoft and their setups appear to be instantaneous. Any ideas would be helpful!!! Thanks, Dave
--
Message posted via http://www.sqlmonster.comIf you report has paramters then you are just seeing building the report, no
parameters then it is also executing the report. Once it has executed it
though, it then caches the data (look in your directory and you will see
reportname.rdl.data). Even a pretty complicated report takes only a couple
of seconds to build the report. Ususally a second or less. How much RAM do
you have. It seems to me like you might be getting some thrashing going on.
"David Cymbala via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:b664fdd433c94909a44639deb1c12d91@.SQLMonster.com...
> Hello, I have been working with Reporting Services for several months and
really like it. I am using Visual Studio .net for developing reports. I
have noticed a long delay when changing between the 'Layout Tab' and the
'Preview Tab'. The delay is between 10 and 15 seconds which may not seem
like much but adds up over time. Does anyone know if this is an issue with
RS or the .net environment? Are there settings to change to make this
change quicker? I know each time you change from one tab to another a new
.rdl file has to be built but I have witnessed several demos from Microsoft
and their setups appear to be instantaneous. Any ideas would be helpful!!!
Thanks, Dave
> --
> Message posted via http://www.sqlmonster.com|||Thank you for your response. My client station is a 3Ghz Pentium with 256 megs of ram. I consistently see this delay regardless of whether the report has parameters or not. The delay occurs before the 'Processing Report...' dialogue appears. The same query in query analyzer takes fractions of a second to complete. Any additional insight would be greatly appreciated. Thanks, Dave
--
Message posted via http://www.sqlmonster.com|||That is faster than my machine but I have 512MB more RAM than you. Besides
adding RAM if you can, how do you have your data source setup, is it a
shared datasource or are you doing it per report. I use shared data source.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Cymbala via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8c91c4a235784ec4b6a9e8de4b04f06d@.SQLMonster.com...
> Thank you for your response. My client station is a 3Ghz Pentium with 256
megs of ram. I consistently see this delay regardless of whether the report
has parameters or not. The delay occurs before the 'Processing Report...'
dialogue appears. The same query in query analyzer takes fractions of a
second to complete. Any additional insight would be greatly appreciated.
Thanks, Dave
> --
> Message posted via http://www.sqlmonster.com|||I am using a shared datasource. I wish I knew if increasing memory would solve this problem before upgrading. Thanks for your responses. Dave
--
Message posted via http://www.sqlmonster.com|||I don't know what else it could be. I have a slower computer and don't see
this. Do you have SQL Server and IIS locally as well? If so then SQL Server,
IIS, VS is a lot in 256 MB. Bring up task manager and see what is going on,
you should be able to see memory usage.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Cymbala via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:d3fba556874c4760b739831eb8e33089@.SQLMonster.com...
> I am using a shared datasource. I wish I knew if increasing memory would
solve this problem before upgrading. Thanks for your responses. Dave
> --
> Message posted via http://www.sqlmonster.com

RS Installation

I have successfully installed RS. However during the installation I was
advised that Visual Studio was a prerequisite on the RS server. I am just
wondering if there is a way that the required components from Visual Studio
can be installed without installing the whole thing.
Any links to documentation or general advice would be greatly appreciated.
Thanks and regards,
Alex McKellarVS is not a prerequisite for the server components. Just ignore the message.
It confuses lots of people. VS is only required for the client tools.
Bruce L-C
"TriggerFish" <apples@.oranges.com> wrote in message
news:41329533$1@.info-mid...
> I have successfully installed RS. However during the installation I was
> advised that Visual Studio was a prerequisite on the RS server. I am just
> wondering if there is a way that the required components from Visual
Studio
> can be installed without installing the whole thing.
> Any links to documentation or general advice would be greatly appreciated.
> Thanks and regards,
> Alex McKellar
>|||Thankyou very much for your reply.
I think that I will have to revisit my installation and start from scratch.
I seem to remember being prompted and choosing not to install VS and then
being booted out of the installation. Definately time to try and go from
the start.
Thanks again,
Alex.
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:#G5ri0jjEHA.1656@.TK2MSFTNGP09.phx.gbl...
> VS is not a prerequisite for the server components. Just ignore the
message.
> It confuses lots of people. VS is only required for the client tools.
> Bruce L-C
> "TriggerFish" <apples@.oranges.com> wrote in message
> news:41329533$1@.info-mid...
> > I have successfully installed RS. However during the installation I was
> > advised that Visual Studio was a prerequisite on the RS server. I am
just
> > wondering if there is a way that the required components from Visual
> Studio
> > can be installed without installing the whole thing.
> >
> > Any links to documentation or general advice would be greatly
appreciated.
> >
> > Thanks and regards,
> >
> > Alex McKellar
> >
> >
>|||Just wanted to thankyou for you reply again and let you know that it was all
good this time. I just hit next at the prerequisite warning screen and
everything installed fine. No doubt you already knew that anyway :-).
Cheers,
Alex.
"TriggerFish" <apples@.oranges.com> wrote in message
news:4132b73e$1@.info-mid...
> Thankyou very much for your reply.
> I think that I will have to revisit my installation and start from
scratch.
> I seem to remember being prompted and choosing not to install VS and then
> being booted out of the installation. Definately time to try and go from
> the start.
> Thanks again,
> Alex.
>
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:#G5ri0jjEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > VS is not a prerequisite for the server components. Just ignore the
> message.
> > It confuses lots of people. VS is only required for the client tools.
> >
> > Bruce L-C
> >
> > "TriggerFish" <apples@.oranges.com> wrote in message
> > news:41329533$1@.info-mid...
> > > I have successfully installed RS. However during the installation I
was
> > > advised that Visual Studio was a prerequisite on the RS server. I am
> just
> > > wondering if there is a way that the required components from Visual
> > Studio
> > > can be installed without installing the whole thing.
> > >
> > > Any links to documentation or general advice would be greatly
> appreciated.
> > >
> > > Thanks and regards,
> > >
> > > Alex McKellar
> > >
> > >
> >
> >
>

RS in Visual Studio 2005: where are ?

Hi,
I've just installed VS 2005 Professional edition.
Reading on MS sites, they say that RS are included in VS 2005: ok, but where
are ?
In "new project" I don't find anything that seems RS: where can I find it ?
Thanks
AdrianoRS is NOT included in VS 2005. What is included in VS 2005 are two controls.
A webform and a winform control. If you put the control on a form it is
possible to create a report from within VS because these controls work both
standalone and with RS. When uses with RS it is quite easy. It is more
difficult in local mode, there is more that the developer has to handle
(subreports etc). Also, to test the report you have to run your app and view
the report that way, there is no preview. If you develop the report using
the RS designer that ships with SQL Server 2005, you can take a report
developed and rename it to use in local mode.
RS 2005 does not require VS to use the designer, it ships with a version of
VS to host the designer. If you have VS 2005 you can install the designer to
run within VS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adry" <adry@.ij_nospam.it> wrote in message
news:u%233oeUlLGHA.3424@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I've just installed VS 2005 Professional edition.
> Reading on MS sites, they say that RS are included in VS 2005: ok, but
> where are ?
> In "new project" I don't find anything that seems RS: where can I find it
> ?
>
> Thanks
> Adriano
>|||This is the first exception in the log file, a generic GDI+ error and then
it cascades from there...
ReportingServicesService!reportrendering!524!01/30/2006-04:00:13:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Runtime.InteropServices.ExternalException: A generic
error occurred in GDI+.
at System.Drawing.Graphics.MeasureString(String text, Font font, SizeF
layoutArea, StringFormat stringFormat)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasFont.LineHeight(Graphics
graphics, SizeF maxSizeF)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasBase.LineHeight(CanvasFont
font)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.CalculateItemMeasurement(Orientation
orientation)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItem.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!library!524!01/30/2006-04:00:13:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!notification!524!01/30/2006-04:00:13:: Notification
4a595bbc-4073-48ac-ac3c-e39b1aa50018 completed. Success: False, Status:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., DeliveryExtension: Printer Delivery Sample, Report: TMP
ExceptionConformance Report, Attempt 1
ReportingServicesService!dbpolling!524!01/30/2006-04:00:13::
NotificationPolling finished processing item
4a595bbc-4073-48ac-ac3c-e39b1aa50018
ReportingServicesService!reportrendering!1210!01/30/2006-04:00:18:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Runtime.InteropServices.ExternalException: A generic
error occurred in GDI+.
at System.Drawing.Graphics.MeasureString(String text, Font font, SizeF
layoutArea, StringFormat stringFormat)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasFont.LineHeight(Graphics
graphics, SizeF maxSizeF)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasBase.LineHeight(CanvasFont
font)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.CalculateItemMeasurement(Orientation
orientation)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItem.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!library!1210!01/30/2006-04:00:18:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!notification!1210!01/30/2006-04:00:18::
Notification d1ffd955-b678-4a68-83d2-dddfffa5fe9e completed. Success:
False, Status: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., DeliveryExtension: Printer Delivery Sample, Report: GWD
ExceptionConformance Report, Attempt 1
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eGDi0NnLGHA.500@.TK2MSFTNGP15.phx.gbl...
> RS is NOT included in VS 2005. What is included in VS 2005 are two
> controls. A webform and a winform control. If you put the control on a
> form it is possible to create a report from within VS because these
> controls work both standalone and with RS. When uses with RS it is quite
> easy. It is more difficult in local mode, there is more that the developer
> has to handle (subreports etc). Also, to test the report you have to run
> your app and view the report that way, there is no preview. If you develop
> the report using the RS designer that ships with SQL Server 2005, you can
> take a report developed and rename it to use in local mode.
> RS 2005 does not require VS to use the designer, it ships with a version
> of VS to host the designer. If you have VS 2005 you can install the
> designer to run within VS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Adry" <adry@.ij_nospam.it> wrote in message
> news:u%233oeUlLGHA.3424@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> I've just installed VS 2005 Professional edition.
>> Reading on MS sites, they say that RS are included in VS 2005: ok, but
>> where are ?
>> In "new project" I don't find anything that seems RS: where can I find it
>> ?
>>
>> Thanks
>> Adriano
>>
>

RS and Oracle

Hello everyone. Does any one knows if it is possible to create reports in MS
Reporting services connected to Oracle DB in Visual Basic 2005 Express
edition?
If any one has done it before a few simple instructions will be greatly
appreciated.
Thank you.> Hello everyone. Does any one knows if it is possible to create reports in
> MS Reporting services connected to Oracle DB in Visual Basic 2005 Express
> edition?
RS can report ON any OLEDB comptable DBMS, meaning Oracle is fine. However,
RS itself cannot be installed onto Oracle, it is a feature of SQL Server
2000/2005.
If you want to report data from an Oracle database, you just enter the valid
connection credentials when creating your report, RS will do the rest.
Kind Regards
Taz