Showing posts with label control. Show all posts
Showing posts with label control. Show all posts

Wednesday, March 28, 2012

Report Web Viewer Control Error - SQL2005 September CTP

I am trying to use the Report Viewer Control in an ASPX page but getting the following error :- "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. ". This is with the SQL Server 2005 September CTP. Is there any option that i should turn on or off?...

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrowsql

Report Web Viewer Control Error - SQL2005 September CTP

I am trying to use the Report Viewer Control in an ASPX page but getting the following error :- "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. ". This is with the SQL Server 2005 September CTP. Is there any option that i should turn on or off?...

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrow

Report Viewer/Authentication

Hello,
We are trying to avoid the login pop-up when using the report viewer control
from an internet facing solution. Sorry it is long, but here is the scenario.
ServerA (the webserver, windows 2000 server, v1.1 framework) is serving a
legacy ASP application that we have added an ASP.NET page that uses the
report viewer control to connect to ServerB.
ServerB (the report server, windows 2003 server SP1, RS Standard Edition
SP2) there is a public IP that is Nat's to a local IP of ServerB. This is
what the report viewer control uses from ServerA. ServerB has a local user
that has full access to the reports that need to be delivered.
When you first try to access the report server (ServerB) from the internet
it prompts for a username and password. Once the local user's credentials
from ServerB have been entered we are able to view all reports until the
browser is closed. We have RS 2000 Standard Edition so there is no option for
a custom security extension.
Is there anyway that we can avoid forcing the web users to type in the
username and password that was setup on ServerB? I have tried everything I
can think of and have had no success. There are many security issues with
making that RS login public using URL access and even more security issues by
making the report server allow anonymous access. I need a solution!
Any help would be greatly appreciated.
Thanks in advance!how your users are authenticated on the serverA?
(form authentication or basic authentication?)
The reportviewer webcontrol is a ASP.Net 2.0 control.
do you use another version?
the .Net 2 version is great, because this version will do what you want to
do!
in .Net 1.1...
To solve your issue, you have to intercept and process the reports using
your own webpages and not authorize the user to access your report server
directly.
(the user must go through your own pages, so you control which credential
will be used to access reportserver instead of prompting the user)
"Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
> Hello,
> We are trying to avoid the login pop-up when using the report viewer
> control
> from an internet facing solution. Sorry it is long, but here is the
> scenario.
> ServerA (the webserver, windows 2000 server, v1.1 framework) is serving a
> legacy ASP application that we have added an ASP.NET page that uses the
> report viewer control to connect to ServerB.
> ServerB (the report server, windows 2003 server SP1, RS Standard Edition
> SP2) there is a public IP that is Nat's to a local IP of ServerB. This is
> what the report viewer control uses from ServerA. ServerB has a local
> user
> that has full access to the reports that need to be delivered.
> When you first try to access the report server (ServerB) from the internet
> it prompts for a username and password. Once the local user's credentials
> from ServerB have been entered we are able to view all reports until the
> browser is closed. We have RS 2000 Standard Edition so there is no option
> for
> a custom security extension.
> Is there anyway that we can avoid forcing the web users to type in the
> username and password that was setup on ServerB? I have tried everything
> I
> can think of and have had no success. There are many security issues with
> making that RS login public using URL access and even more security issues
> by
> making the report server allow anonymous access. I need a solution!
> Any help would be greatly appreciated.
> Thanks in advance!|||Users on serverA are authenticated with a custom SQL login from the ASP
pages. The entire site on serverA is classic ASP. We are trying to add the
ASPX page with the report viewer control. We are able to determine if the
users are authenticated once they hit the ASPX/Report Viewer page.
We are using the 1.1 version of the report viewer control that came with SP1
or SP2 for RS 2000.
Once the web user accesses our ASPX page with the report viewer control how
do we set the credentials that access the report server via URL? That is
were everything stops working as planned and the standard login pop-up shows.
You can type the credentials of the user we want them to access with and
everything works fine from that point forward. But we want to set the
credentials in the code-behind of the page and not make the credentials
publicly available.
Any help you could provide to set the credentials that will be used by the
report viewer control would be greatly appreciated. I have poured many hours
into these reports and the integration with the classic ASP site. The
reports use custom assemblies to dynamically build the SQL statements, etc.
but now I can't get internet access to them using the report viewer without
manually typing in the credentials!
Thank you very much.
"Jéjé" wrote:
> how your users are authenticated on the serverA?
> (form authentication or basic authentication?)
> The reportviewer webcontrol is a ASP.Net 2.0 control.
> do you use another version?
> the .Net 2 version is great, because this version will do what you want to
> do!
> in .Net 1.1...
> To solve your issue, you have to intercept and process the reports using
> your own webpages and not authorize the user to access your report server
> directly.
> (the user must go through your own pages, so you control which credential
> will be used to access reportserver instead of prompting the user)
>
> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
> > Hello,
> >
> > We are trying to avoid the login pop-up when using the report viewer
> > control
> > from an internet facing solution. Sorry it is long, but here is the
> > scenario.
> >
> > ServerA (the webserver, windows 2000 server, v1.1 framework) is serving a
> > legacy ASP application that we have added an ASP.NET page that uses the
> > report viewer control to connect to ServerB.
> >
> > ServerB (the report server, windows 2003 server SP1, RS Standard Edition
> > SP2) there is a public IP that is Nat's to a local IP of ServerB. This is
> > what the report viewer control uses from ServerA. ServerB has a local
> > user
> > that has full access to the reports that need to be delivered.
> >
> > When you first try to access the report server (ServerB) from the internet
> > it prompts for a username and password. Once the local user's credentials
> > from ServerB have been entered we are able to view all reports until the
> > browser is closed. We have RS 2000 Standard Edition so there is no option
> > for
> > a custom security extension.
> >
> > Is there anyway that we can avoid forcing the web users to type in the
> > username and password that was setup on ServerB? I have tried everything
> > I
> > can think of and have had no success. There are many security issues with
> > making that RS login public using URL access and even more security issues
> > by
> > making the report server allow anonymous access. I need a solution!
> >
> > Any help would be greatly appreciated.
> >
> > Thanks in advance!
>
>|||this control use an IFrame to render the report.
this IFrame "redirect" the user to RS directly.
To override this issue you have to open your pages on the ServerA web site
and disallow the users to access the serverb directly.
To do this, you have to render the reports by yourself using your own ASPX
page(s) (you have to call the SOAP API and not use the URL access)
another way...
look at this reverse proxy tool:
http://www.saltypickle.com/Home/16
"Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
> Users on serverA are authenticated with a custom SQL login from the ASP
> pages. The entire site on serverA is classic ASP. We are trying to add
> the
> ASPX page with the report viewer control. We are able to determine if the
> users are authenticated once they hit the ASPX/Report Viewer page.
> We are using the 1.1 version of the report viewer control that came with
> SP1
> or SP2 for RS 2000.
> Once the web user accesses our ASPX page with the report viewer control
> how
> do we set the credentials that access the report server via URL? That is
> were everything stops working as planned and the standard login pop-up
> shows.
> You can type the credentials of the user we want them to access with and
> everything works fine from that point forward. But we want to set the
> credentials in the code-behind of the page and not make the credentials
> publicly available.
> Any help you could provide to set the credentials that will be used by the
> report viewer control would be greatly appreciated. I have poured many
> hours
> into these reports and the integration with the classic ASP site. The
> reports use custom assemblies to dynamically build the SQL statements,
> etc.
> but now I can't get internet access to them using the report viewer
> without
> manually typing in the credentials!
> Thank you very much.
>
> "Jéjé" wrote:
>> how your users are authenticated on the serverA?
>> (form authentication or basic authentication?)
>> The reportviewer webcontrol is a ASP.Net 2.0 control.
>> do you use another version?
>> the .Net 2 version is great, because this version will do what you want
>> to
>> do!
>> in .Net 1.1...
>> To solve your issue, you have to intercept and process the reports using
>> your own webpages and not authorize the user to access your report server
>> directly.
>> (the user must go through your own pages, so you control which credential
>> will be used to access reportserver instead of prompting the user)
>>
>> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
>> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
>> > Hello,
>> >
>> > We are trying to avoid the login pop-up when using the report viewer
>> > control
>> > from an internet facing solution. Sorry it is long, but here is the
>> > scenario.
>> >
>> > ServerA (the webserver, windows 2000 server, v1.1 framework) is serving
>> > a
>> > legacy ASP application that we have added an ASP.NET page that uses the
>> > report viewer control to connect to ServerB.
>> >
>> > ServerB (the report server, windows 2003 server SP1, RS Standard
>> > Edition
>> > SP2) there is a public IP that is Nat's to a local IP of ServerB. This
>> > is
>> > what the report viewer control uses from ServerA. ServerB has a local
>> > user
>> > that has full access to the reports that need to be delivered.
>> >
>> > When you first try to access the report server (ServerB) from the
>> > internet
>> > it prompts for a username and password. Once the local user's
>> > credentials
>> > from ServerB have been entered we are able to view all reports until
>> > the
>> > browser is closed. We have RS 2000 Standard Edition so there is no
>> > option
>> > for
>> > a custom security extension.
>> >
>> > Is there anyway that we can avoid forcing the web users to type in the
>> > username and password that was setup on ServerB? I have tried
>> > everything
>> > I
>> > can think of and have had no success. There are many security issues
>> > with
>> > making that RS login public using URL access and even more security
>> > issues
>> > by
>> > making the report server allow anonymous access. I need a solution!
>> >
>> > Any help would be greatly appreciated.
>> >
>> > Thanks in advance!
>>|||Hello,
Do you have links to any samples using the SOAP API? Do you still have the
option to show the toolbar, hide parameters, etc. like the URL access?
Thanks!
"Jéjé" wrote:
> this control use an IFrame to render the report.
> this IFrame "redirect" the user to RS directly.
> To override this issue you have to open your pages on the ServerA web site
> and disallow the users to access the serverb directly.
> To do this, you have to render the reports by yourself using your own ASPX
> page(s) (you have to call the SOAP API and not use the URL access)
> another way...
> look at this reverse proxy tool:
> http://www.saltypickle.com/Home/16
>
> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
> > Users on serverA are authenticated with a custom SQL login from the ASP
> > pages. The entire site on serverA is classic ASP. We are trying to add
> > the
> > ASPX page with the report viewer control. We are able to determine if the
> > users are authenticated once they hit the ASPX/Report Viewer page.
> >
> > We are using the 1.1 version of the report viewer control that came with
> > SP1
> > or SP2 for RS 2000.
> >
> > Once the web user accesses our ASPX page with the report viewer control
> > how
> > do we set the credentials that access the report server via URL? That is
> > were everything stops working as planned and the standard login pop-up
> > shows.
> > You can type the credentials of the user we want them to access with and
> > everything works fine from that point forward. But we want to set the
> > credentials in the code-behind of the page and not make the credentials
> > publicly available.
> >
> > Any help you could provide to set the credentials that will be used by the
> > report viewer control would be greatly appreciated. I have poured many
> > hours
> > into these reports and the integration with the classic ASP site. The
> > reports use custom assemblies to dynamically build the SQL statements,
> > etc.
> > but now I can't get internet access to them using the report viewer
> > without
> > manually typing in the credentials!
> >
> > Thank you very much.
> >
> >
> > "Jéjé" wrote:
> >
> >> how your users are authenticated on the serverA?
> >> (form authentication or basic authentication?)
> >>
> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
> >> do you use another version?
> >> the .Net 2 version is great, because this version will do what you want
> >> to
> >> do!
> >>
> >> in .Net 1.1...
> >> To solve your issue, you have to intercept and process the reports using
> >> your own webpages and not authorize the user to access your report server
> >> directly.
> >> (the user must go through your own pages, so you control which credential
> >> will be used to access reportserver instead of prompting the user)
> >>
> >>
> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
> >> > Hello,
> >> >
> >> > We are trying to avoid the login pop-up when using the report viewer
> >> > control
> >> > from an internet facing solution. Sorry it is long, but here is the
> >> > scenario.
> >> >
> >> > ServerA (the webserver, windows 2000 server, v1.1 framework) is serving
> >> > a
> >> > legacy ASP application that we have added an ASP.NET page that uses the
> >> > report viewer control to connect to ServerB.
> >> >
> >> > ServerB (the report server, windows 2003 server SP1, RS Standard
> >> > Edition
> >> > SP2) there is a public IP that is Nat's to a local IP of ServerB. This
> >> > is
> >> > what the report viewer control uses from ServerA. ServerB has a local
> >> > user
> >> > that has full access to the reports that need to be delivered.
> >> >
> >> > When you first try to access the report server (ServerB) from the
> >> > internet
> >> > it prompts for a username and password. Once the local user's
> >> > credentials
> >> > from ServerB have been entered we are able to view all reports until
> >> > the
> >> > browser is closed. We have RS 2000 Standard Edition so there is no
> >> > option
> >> > for
> >> > a custom security extension.
> >> >
> >> > Is there anyway that we can avoid forcing the web users to type in the
> >> > username and password that was setup on ServerB? I have tried
> >> > everything
> >> > I
> >> > can think of and have had no success. There are many security issues
> >> > with
> >> > making that RS login public using URL access and even more security
> >> > issues
> >> > by
> >> > making the report server allow anonymous access. I need a solution!
> >> >
> >> > Any help would be greatly appreciated.
> >> >
> >> > Thanks in advance!
> >>
> >>
> >>
>
>|||you have to develop the parameters interface.
there is samples on the web and in RS books
a good sample:
http://www.codeproject.com/aspnet/SQLRSViewer.asp
"Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
news:3687F13F-9CE3-4B3A-9F50-CB942D5CEF2C@.microsoft.com...
> Hello,
> Do you have links to any samples using the SOAP API? Do you still have
> the
> option to show the toolbar, hide parameters, etc. like the URL access?
> Thanks!
> "Jéjé" wrote:
>> this control use an IFrame to render the report.
>> this IFrame "redirect" the user to RS directly.
>> To override this issue you have to open your pages on the ServerA web
>> site
>> and disallow the users to access the serverb directly.
>> To do this, you have to render the reports by yourself using your own
>> ASPX
>> page(s) (you have to call the SOAP API and not use the URL access)
>> another way...
>> look at this reverse proxy tool:
>> http://www.saltypickle.com/Home/16
>>
>> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
>> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
>> > Users on serverA are authenticated with a custom SQL login from the ASP
>> > pages. The entire site on serverA is classic ASP. We are trying to
>> > add
>> > the
>> > ASPX page with the report viewer control. We are able to determine if
>> > the
>> > users are authenticated once they hit the ASPX/Report Viewer page.
>> >
>> > We are using the 1.1 version of the report viewer control that came
>> > with
>> > SP1
>> > or SP2 for RS 2000.
>> >
>> > Once the web user accesses our ASPX page with the report viewer control
>> > how
>> > do we set the credentials that access the report server via URL? That
>> > is
>> > were everything stops working as planned and the standard login pop-up
>> > shows.
>> > You can type the credentials of the user we want them to access with
>> > and
>> > everything works fine from that point forward. But we want to set the
>> > credentials in the code-behind of the page and not make the credentials
>> > publicly available.
>> >
>> > Any help you could provide to set the credentials that will be used by
>> > the
>> > report viewer control would be greatly appreciated. I have poured many
>> > hours
>> > into these reports and the integration with the classic ASP site. The
>> > reports use custom assemblies to dynamically build the SQL statements,
>> > etc.
>> > but now I can't get internet access to them using the report viewer
>> > without
>> > manually typing in the credentials!
>> >
>> > Thank you very much.
>> >
>> >
>> > "Jéjé" wrote:
>> >
>> >> how your users are authenticated on the serverA?
>> >> (form authentication or basic authentication?)
>> >>
>> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
>> >> do you use another version?
>> >> the .Net 2 version is great, because this version will do what you
>> >> want
>> >> to
>> >> do!
>> >>
>> >> in .Net 1.1...
>> >> To solve your issue, you have to intercept and process the reports
>> >> using
>> >> your own webpages and not authorize the user to access your report
>> >> server
>> >> directly.
>> >> (the user must go through your own pages, so you control which
>> >> credential
>> >> will be used to access reportserver instead of prompting the user)
>> >>
>> >>
>> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > We are trying to avoid the login pop-up when using the report viewer
>> >> > control
>> >> > from an internet facing solution. Sorry it is long, but here is the
>> >> > scenario.
>> >> >
>> >> > ServerA (the webserver, windows 2000 server, v1.1 framework) is
>> >> > serving
>> >> > a
>> >> > legacy ASP application that we have added an ASP.NET page that uses
>> >> > the
>> >> > report viewer control to connect to ServerB.
>> >> >
>> >> > ServerB (the report server, windows 2003 server SP1, RS Standard
>> >> > Edition
>> >> > SP2) there is a public IP that is Nat's to a local IP of ServerB.
>> >> > This
>> >> > is
>> >> > what the report viewer control uses from ServerA. ServerB has a
>> >> > local
>> >> > user
>> >> > that has full access to the reports that need to be delivered.
>> >> >
>> >> > When you first try to access the report server (ServerB) from the
>> >> > internet
>> >> > it prompts for a username and password. Once the local user's
>> >> > credentials
>> >> > from ServerB have been entered we are able to view all reports until
>> >> > the
>> >> > browser is closed. We have RS 2000 Standard Edition so there is no
>> >> > option
>> >> > for
>> >> > a custom security extension.
>> >> >
>> >> > Is there anyway that we can avoid forcing the web users to type in
>> >> > the
>> >> > username and password that was setup on ServerB? I have tried
>> >> > everything
>> >> > I
>> >> > can think of and have had no success. There are many security
>> >> > issues
>> >> > with
>> >> > making that RS login public using URL access and even more security
>> >> > issues
>> >> > by
>> >> > making the report server allow anonymous access. I need a solution!
>> >> >
>> >> > Any help would be greatly appreciated.
>> >> >
>> >> > Thanks in advance!
>> >>
>> >>
>> >>
>>|||Hello,
I just wanted to confirm that there will be no limitations using the SOAP
API with the Standard version of reporting services. The reason I ask is
that in many of the different solutions I have tried the "this is not
supported in this version" has come up. I tried the logonuser method
connecting to the web service and received a similar error. I was trying to
connect and logon prior to connecting with the report viewer control hoping
that would save the authentication like manually typing in the credentials
does. You only have to manually type them in once, but that is too many!
The sad thing about it is that with all the hours wasted trying to get the
Standard Edition to work we probably could have simply purchased the
Enterprise Edition, used forms authentication and deployed the solution
months ago!
Thanks for all your assistance!
"Jéjé" wrote:
> you have to develop the parameters interface.
> there is samples on the web and in RS books
> a good sample:
> http://www.codeproject.com/aspnet/SQLRSViewer.asp
>
> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> news:3687F13F-9CE3-4B3A-9F50-CB942D5CEF2C@.microsoft.com...
> > Hello,
> >
> > Do you have links to any samples using the SOAP API? Do you still have
> > the
> > option to show the toolbar, hide parameters, etc. like the URL access?
> >
> > Thanks!
> >
> > "Jéjé" wrote:
> >
> >> this control use an IFrame to render the report.
> >> this IFrame "redirect" the user to RS directly.
> >>
> >> To override this issue you have to open your pages on the ServerA web
> >> site
> >> and disallow the users to access the serverb directly.
> >> To do this, you have to render the reports by yourself using your own
> >> ASPX
> >> page(s) (you have to call the SOAP API and not use the URL access)
> >>
> >> another way...
> >> look at this reverse proxy tool:
> >> http://www.saltypickle.com/Home/16
> >>
> >>
> >>
> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> >> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
> >> > Users on serverA are authenticated with a custom SQL login from the ASP
> >> > pages. The entire site on serverA is classic ASP. We are trying to
> >> > add
> >> > the
> >> > ASPX page with the report viewer control. We are able to determine if
> >> > the
> >> > users are authenticated once they hit the ASPX/Report Viewer page.
> >> >
> >> > We are using the 1.1 version of the report viewer control that came
> >> > with
> >> > SP1
> >> > or SP2 for RS 2000.
> >> >
> >> > Once the web user accesses our ASPX page with the report viewer control
> >> > how
> >> > do we set the credentials that access the report server via URL? That
> >> > is
> >> > were everything stops working as planned and the standard login pop-up
> >> > shows.
> >> > You can type the credentials of the user we want them to access with
> >> > and
> >> > everything works fine from that point forward. But we want to set the
> >> > credentials in the code-behind of the page and not make the credentials
> >> > publicly available.
> >> >
> >> > Any help you could provide to set the credentials that will be used by
> >> > the
> >> > report viewer control would be greatly appreciated. I have poured many
> >> > hours
> >> > into these reports and the integration with the classic ASP site. The
> >> > reports use custom assemblies to dynamically build the SQL statements,
> >> > etc.
> >> > but now I can't get internet access to them using the report viewer
> >> > without
> >> > manually typing in the credentials!
> >> >
> >> > Thank you very much.
> >> >
> >> >
> >> > "Jéjé" wrote:
> >> >
> >> >> how your users are authenticated on the serverA?
> >> >> (form authentication or basic authentication?)
> >> >>
> >> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
> >> >> do you use another version?
> >> >> the .Net 2 version is great, because this version will do what you
> >> >> want
> >> >> to
> >> >> do!
> >> >>
> >> >> in .Net 1.1...
> >> >> To solve your issue, you have to intercept and process the reports
> >> >> using
> >> >> your own webpages and not authorize the user to access your report
> >> >> server
> >> >> directly.
> >> >> (the user must go through your own pages, so you control which
> >> >> credential
> >> >> will be used to access reportserver instead of prompting the user)
> >> >>
> >> >>
> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
> >> >> > Hello,
> >> >> >
> >> >> > We are trying to avoid the login pop-up when using the report viewer
> >> >> > control
> >> >> > from an internet facing solution. Sorry it is long, but here is the
> >> >> > scenario.
> >> >> >
> >> >> > ServerA (the webserver, windows 2000 server, v1.1 framework) is
> >> >> > serving
> >> >> > a
> >> >> > legacy ASP application that we have added an ASP.NET page that uses
> >> >> > the
> >> >> > report viewer control to connect to ServerB.
> >> >> >
> >> >> > ServerB (the report server, windows 2003 server SP1, RS Standard
> >> >> > Edition
> >> >> > SP2) there is a public IP that is Nat's to a local IP of ServerB.
> >> >> > This
> >> >> > is
> >> >> > what the report viewer control uses from ServerA. ServerB has a
> >> >> > local
> >> >> > user
> >> >> > that has full access to the reports that need to be delivered.
> >> >> >
> >> >> > When you first try to access the report server (ServerB) from the
> >> >> > internet
> >> >> > it prompts for a username and password. Once the local user's
> >> >> > credentials
> >> >> > from ServerB have been entered we are able to view all reports until
> >> >> > the
> >> >> > browser is closed. We have RS 2000 Standard Edition so there is no
> >> >> > option
> >> >> > for
> >> >> > a custom security extension.
> >> >> >
> >> >> > Is there anyway that we can avoid forcing the web users to type in
> >> >> > the
> >> >> > username and password that was setup on ServerB? I have tried
> >> >> > everything
> >> >> > I
> >> >> > can think of and have had no success. There are many security
> >> >> > issues
> >> >> > with
> >> >> > making that RS login public using URL access and even more security
> >> >> > issues
> >> >> > by
> >> >> > making the report server allow anonymous access. I need a solution!
> >> >> >
> >> >> > Any help would be greatly appreciated.
> >> >> >
> >> >> > Thanks in advance!
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||the SOAP API is available in any edition.
the link sent to you can be used with any version of RS
when you call the RS webservice, create a specific credential or use the
impersonate account setup in the web.config file
read this:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch10.asp
(the section called "Using specific credentials")
so your application continue to use your own authentication system and
you'll control all the access to RS through your application.
The only limitation:
you can't use the User!UserID in your reports, you have to change this by a
a standard report parameter and fill this parameter in your web application
without displaying this parameter to the end user.
"Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
news:C3FA0554-12EA-4AC3-893C-4DD5AD99A517@.microsoft.com...
> Hello,
> I just wanted to confirm that there will be no limitations using the SOAP
> API with the Standard version of reporting services. The reason I ask is
> that in many of the different solutions I have tried the "this is not
> supported in this version" has come up. I tried the logonuser method
> connecting to the web service and received a similar error. I was trying
> to
> connect and logon prior to connecting with the report viewer control
> hoping
> that would save the authentication like manually typing in the credentials
> does. You only have to manually type them in once, but that is too many!
> The sad thing about it is that with all the hours wasted trying to get the
> Standard Edition to work we probably could have simply purchased the
> Enterprise Edition, used forms authentication and deployed the solution
> months ago!
> Thanks for all your assistance!
>
> "Jéjé" wrote:
>> you have to develop the parameters interface.
>> there is samples on the web and in RS books
>> a good sample:
>> http://www.codeproject.com/aspnet/SQLRSViewer.asp
>>
>> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
>> news:3687F13F-9CE3-4B3A-9F50-CB942D5CEF2C@.microsoft.com...
>> > Hello,
>> >
>> > Do you have links to any samples using the SOAP API? Do you still have
>> > the
>> > option to show the toolbar, hide parameters, etc. like the URL access?
>> >
>> > Thanks!
>> >
>> > "Jéjé" wrote:
>> >
>> >> this control use an IFrame to render the report.
>> >> this IFrame "redirect" the user to RS directly.
>> >>
>> >> To override this issue you have to open your pages on the ServerA web
>> >> site
>> >> and disallow the users to access the serverb directly.
>> >> To do this, you have to render the reports by yourself using your own
>> >> ASPX
>> >> page(s) (you have to call the SOAP API and not use the URL access)
>> >>
>> >> another way...
>> >> look at this reverse proxy tool:
>> >> http://www.saltypickle.com/Home/16
>> >>
>> >>
>> >>
>> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
>> >> > Users on serverA are authenticated with a custom SQL login from the
>> >> > ASP
>> >> > pages. The entire site on serverA is classic ASP. We are trying to
>> >> > add
>> >> > the
>> >> > ASPX page with the report viewer control. We are able to determine
>> >> > if
>> >> > the
>> >> > users are authenticated once they hit the ASPX/Report Viewer page.
>> >> >
>> >> > We are using the 1.1 version of the report viewer control that came
>> >> > with
>> >> > SP1
>> >> > or SP2 for RS 2000.
>> >> >
>> >> > Once the web user accesses our ASPX page with the report viewer
>> >> > control
>> >> > how
>> >> > do we set the credentials that access the report server via URL?
>> >> > That
>> >> > is
>> >> > were everything stops working as planned and the standard login
>> >> > pop-up
>> >> > shows.
>> >> > You can type the credentials of the user we want them to access with
>> >> > and
>> >> > everything works fine from that point forward. But we want to set
>> >> > the
>> >> > credentials in the code-behind of the page and not make the
>> >> > credentials
>> >> > publicly available.
>> >> >
>> >> > Any help you could provide to set the credentials that will be used
>> >> > by
>> >> > the
>> >> > report viewer control would be greatly appreciated. I have poured
>> >> > many
>> >> > hours
>> >> > into these reports and the integration with the classic ASP site.
>> >> > The
>> >> > reports use custom assemblies to dynamically build the SQL
>> >> > statements,
>> >> > etc.
>> >> > but now I can't get internet access to them using the report viewer
>> >> > without
>> >> > manually typing in the credentials!
>> >> >
>> >> > Thank you very much.
>> >> >
>> >> >
>> >> > "Jéjé" wrote:
>> >> >
>> >> >> how your users are authenticated on the serverA?
>> >> >> (form authentication or basic authentication?)
>> >> >>
>> >> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
>> >> >> do you use another version?
>> >> >> the .Net 2 version is great, because this version will do what you
>> >> >> want
>> >> >> to
>> >> >> do!
>> >> >>
>> >> >> in .Net 1.1...
>> >> >> To solve your issue, you have to intercept and process the reports
>> >> >> using
>> >> >> your own webpages and not authorize the user to access your report
>> >> >> server
>> >> >> directly.
>> >> >> (the user must go through your own pages, so you control which
>> >> >> credential
>> >> >> will be used to access reportserver instead of prompting the user)
>> >> >>
>> >> >>
>> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
>> >> >> > Hello,
>> >> >> >
>> >> >> > We are trying to avoid the login pop-up when using the report
>> >> >> > viewer
>> >> >> > control
>> >> >> > from an internet facing solution. Sorry it is long, but here is
>> >> >> > the
>> >> >> > scenario.
>> >> >> >
>> >> >> > ServerA (the webserver, windows 2000 server, v1.1 framework) is
>> >> >> > serving
>> >> >> > a
>> >> >> > legacy ASP application that we have added an ASP.NET page that
>> >> >> > uses
>> >> >> > the
>> >> >> > report viewer control to connect to ServerB.
>> >> >> >
>> >> >> > ServerB (the report server, windows 2003 server SP1, RS Standard
>> >> >> > Edition
>> >> >> > SP2) there is a public IP that is Nat's to a local IP of ServerB.
>> >> >> > This
>> >> >> > is
>> >> >> > what the report viewer control uses from ServerA. ServerB has a
>> >> >> > local
>> >> >> > user
>> >> >> > that has full access to the reports that need to be delivered.
>> >> >> >
>> >> >> > When you first try to access the report server (ServerB) from the
>> >> >> > internet
>> >> >> > it prompts for a username and password. Once the local user's
>> >> >> > credentials
>> >> >> > from ServerB have been entered we are able to view all reports
>> >> >> > until
>> >> >> > the
>> >> >> > browser is closed. We have RS 2000 Standard Edition so there is
>> >> >> > no
>> >> >> > option
>> >> >> > for
>> >> >> > a custom security extension.
>> >> >> >
>> >> >> > Is there anyway that we can avoid forcing the web users to type
>> >> >> > in
>> >> >> > the
>> >> >> > username and password that was setup on ServerB? I have tried
>> >> >> > everything
>> >> >> > I
>> >> >> > can think of and have had no success. There are many security
>> >> >> > issues
>> >> >> > with
>> >> >> > making that RS login public using URL access and even more
>> >> >> > security
>> >> >> > issues
>> >> >> > by
>> >> >> > making the report server allow anonymous access. I need a
>> >> >> > solution!
>> >> >> >
>> >> >> > Any help would be greatly appreciated.
>> >> >> >
>> >> >> > Thanks in advance!
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks again for all your help!
"Jéjé" wrote:
> the SOAP API is available in any edition.
> the link sent to you can be used with any version of RS
> when you call the RS webservice, create a specific credential or use the
> impersonate account setup in the web.config file
> read this:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch10.asp
> (the section called "Using specific credentials")
> so your application continue to use your own authentication system and
> you'll control all the access to RS through your application.
> The only limitation:
> you can't use the User!UserID in your reports, you have to change this by a
> a standard report parameter and fill this parameter in your web application
> without displaying this parameter to the end user.
>
> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> news:C3FA0554-12EA-4AC3-893C-4DD5AD99A517@.microsoft.com...
> > Hello,
> >
> > I just wanted to confirm that there will be no limitations using the SOAP
> > API with the Standard version of reporting services. The reason I ask is
> > that in many of the different solutions I have tried the "this is not
> > supported in this version" has come up. I tried the logonuser method
> > connecting to the web service and received a similar error. I was trying
> > to
> > connect and logon prior to connecting with the report viewer control
> > hoping
> > that would save the authentication like manually typing in the credentials
> > does. You only have to manually type them in once, but that is too many!
> >
> > The sad thing about it is that with all the hours wasted trying to get the
> > Standard Edition to work we probably could have simply purchased the
> > Enterprise Edition, used forms authentication and deployed the solution
> > months ago!
> >
> > Thanks for all your assistance!
> >
> >
> > "Jéjé" wrote:
> >
> >> you have to develop the parameters interface.
> >>
> >> there is samples on the web and in RS books
> >>
> >> a good sample:
> >> http://www.codeproject.com/aspnet/SQLRSViewer.asp
> >>
> >>
> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
> >> news:3687F13F-9CE3-4B3A-9F50-CB942D5CEF2C@.microsoft.com...
> >> > Hello,
> >> >
> >> > Do you have links to any samples using the SOAP API? Do you still have
> >> > the
> >> > option to show the toolbar, hide parameters, etc. like the URL access?
> >> >
> >> > Thanks!
> >> >
> >> > "Jéjé" wrote:
> >> >
> >> >> this control use an IFrame to render the report.
> >> >> this IFrame "redirect" the user to RS directly.
> >> >>
> >> >> To override this issue you have to open your pages on the ServerA web
> >> >> site
> >> >> and disallow the users to access the serverb directly.
> >> >> To do this, you have to render the reports by yourself using your own
> >> >> ASPX
> >> >> page(s) (you have to call the SOAP API and not use the URL access)
> >> >>
> >> >> another way...
> >> >> look at this reverse proxy tool:
> >> >> http://www.saltypickle.com/Home/16
> >> >>
> >> >>
> >> >>
> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
> >> >> > Users on serverA are authenticated with a custom SQL login from the
> >> >> > ASP
> >> >> > pages. The entire site on serverA is classic ASP. We are trying to
> >> >> > add
> >> >> > the
> >> >> > ASPX page with the report viewer control. We are able to determine
> >> >> > if
> >> >> > the
> >> >> > users are authenticated once they hit the ASPX/Report Viewer page.
> >> >> >
> >> >> > We are using the 1.1 version of the report viewer control that came
> >> >> > with
> >> >> > SP1
> >> >> > or SP2 for RS 2000.
> >> >> >
> >> >> > Once the web user accesses our ASPX page with the report viewer
> >> >> > control
> >> >> > how
> >> >> > do we set the credentials that access the report server via URL?
> >> >> > That
> >> >> > is
> >> >> > were everything stops working as planned and the standard login
> >> >> > pop-up
> >> >> > shows.
> >> >> > You can type the credentials of the user we want them to access with
> >> >> > and
> >> >> > everything works fine from that point forward. But we want to set
> >> >> > the
> >> >> > credentials in the code-behind of the page and not make the
> >> >> > credentials
> >> >> > publicly available.
> >> >> >
> >> >> > Any help you could provide to set the credentials that will be used
> >> >> > by
> >> >> > the
> >> >> > report viewer control would be greatly appreciated. I have poured
> >> >> > many
> >> >> > hours
> >> >> > into these reports and the integration with the classic ASP site.
> >> >> > The
> >> >> > reports use custom assemblies to dynamically build the SQL
> >> >> > statements,
> >> >> > etc.
> >> >> > but now I can't get internet access to them using the report viewer
> >> >> > without
> >> >> > manually typing in the credentials!
> >> >> >
> >> >> > Thank you very much.
> >> >> >
> >> >> >
> >> >> > "Jéjé" wrote:
> >> >> >
> >> >> >> how your users are authenticated on the serverA?
> >> >> >> (form authentication or basic authentication?)
> >> >> >>
> >> >> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
> >> >> >> do you use another version?
> >> >> >> the .Net 2 version is great, because this version will do what you
> >> >> >> want
> >> >> >> to
> >> >> >> do!
> >> >> >>
> >> >> >> in .Net 1.1...
> >> >> >> To solve your issue, you have to intercept and process the reports
> >> >> >> using
> >> >> >> your own webpages and not authorize the user to access your report
> >> >> >> server
> >> >> >> directly.
> >> >> >> (the user must go through your own pages, so you control which
> >> >> >> credential
> >> >> >> will be used to access reportserver instead of prompting the user)
> >> >> >>
> >> >> >>
> >> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
> >> >> >> > Hello,
> >> >> >> >
> >> >> >> > We are trying to avoid the login pop-up when using the report
> >> >> >> > viewer
> >> >> >> > control
> >> >> >> > from an internet facing solution. Sorry it is long, but here is
> >> >> >> > the
> >> >> >> > scenario.
> >> >> >> >
> >> >> >> > ServerA (the webserver, windows 2000 server, v1.1 framework) is
> >> >> >> > serving
> >> >> >> > a
> >> >> >> > legacy ASP application that we have added an ASP.NET page that
> >> >> >> > uses
> >> >> >> > the
> >> >> >> > report viewer control to connect to ServerB.
> >> >> >> >
> >> >> >> > ServerB (the report server, windows 2003 server SP1, RS Standard
> >> >> >> > Edition
> >> >> >> > SP2) there is a public IP that is Nat's to a local IP of ServerB.
> >> >> >> > This
> >> >> >> > is
> >> >> >> > what the report viewer control uses from ServerA. ServerB has a
> >> >> >> > local
> >> >> >> > user
> >> >> >> > that has full access to the reports that need to be delivered.
> >> >> >> >
> >> >> >> > When you first try to access the report server (ServerB) from the
> >> >> >> > internet
> >> >> >> > it prompts for a username and password. Once the local user's
> >> >> >> > credentials
> >> >> >> > from ServerB have been entered we are able to view all reports
> >> >> >> > until
> >> >> >> > the
> >> >> >> > browser is closed. We have RS 2000 Standard Edition so there is
> >> >> >> > no
> >> >> >> > option
> >> >> >> > for
> >> >> >> > a custom security extension.
> >> >> >> >
> >> >> >> > Is there anyway that we can avoid forcing the web users to type
> >> >> >> > in
> >> >> >> > the
> >> >> >> > username and password that was setup on ServerB? I have tried
> >> >> >> > everything
> >> >> >> > I
> >> >> >> > can think of and have had no success. There are many security
> >> >> >> > issues
> >> >> >> > with
> >> >> >> > making that RS login public using URL access and even more
> >> >> >> > security
> >> >> >> > issues
> >> >> >> > by
> >> >> >> > making the report server allow anonymous access. I need a
> >> >> >> > solution!
> >> >> >> >
> >> >> >> > Any help would be greatly appreciated.
> >> >> >> >
> >> >> >> > Thanks in advance!
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||A big setback with using SOAP API is that you lose the report toolbar.
"Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
news:68B042E6-912D-4F08-8C81-C77F2F9BDD82@.microsoft.com...
> Thanks again for all your help!
> "Jéjé" wrote:
>> the SOAP API is available in any edition.
>> the link sent to you can be used with any version of RS
>> when you call the RS webservice, create a specific credential or use the
>> impersonate account setup in the web.config file
>> read this:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch10.asp
>> (the section called "Using specific credentials")
>> so your application continue to use your own authentication system and
>> you'll control all the access to RS through your application.
>> The only limitation:
>> you can't use the User!UserID in your reports, you have to change this by
>> a
>> a standard report parameter and fill this parameter in your web
>> application
>> without displaying this parameter to the end user.
>>
>> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in message
>> news:C3FA0554-12EA-4AC3-893C-4DD5AD99A517@.microsoft.com...
>> > Hello,
>> >
>> > I just wanted to confirm that there will be no limitations using the
>> > SOAP
>> > API with the Standard version of reporting services. The reason I ask
>> > is
>> > that in many of the different solutions I have tried the "this is not
>> > supported in this version" has come up. I tried the logonuser method
>> > connecting to the web service and received a similar error. I was
>> > trying
>> > to
>> > connect and logon prior to connecting with the report viewer control
>> > hoping
>> > that would save the authentication like manually typing in the
>> > credentials
>> > does. You only have to manually type them in once, but that is too
>> > many!
>> >
>> > The sad thing about it is that with all the hours wasted trying to get
>> > the
>> > Standard Edition to work we probably could have simply purchased the
>> > Enterprise Edition, used forms authentication and deployed the solution
>> > months ago!
>> >
>> > Thanks for all your assistance!
>> >
>> >
>> > "Jéjé" wrote:
>> >
>> >> you have to develop the parameters interface.
>> >>
>> >> there is samples on the web and in RS books
>> >>
>> >> a good sample:
>> >> http://www.codeproject.com/aspnet/SQLRSViewer.asp
>> >>
>> >>
>> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:3687F13F-9CE3-4B3A-9F50-CB942D5CEF2C@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > Do you have links to any samples using the SOAP API? Do you still
>> >> > have
>> >> > the
>> >> > option to show the toolbar, hide parameters, etc. like the URL
>> >> > access?
>> >> >
>> >> > Thanks!
>> >> >
>> >> > "Jéjé" wrote:
>> >> >
>> >> >> this control use an IFrame to render the report.
>> >> >> this IFrame "redirect" the user to RS directly.
>> >> >>
>> >> >> To override this issue you have to open your pages on the ServerA
>> >> >> web
>> >> >> site
>> >> >> and disallow the users to access the serverb directly.
>> >> >> To do this, you have to render the reports by yourself using your
>> >> >> own
>> >> >> ASPX
>> >> >> page(s) (you have to call the SOAP API and not use the URL access)
>> >> >>
>> >> >> another way...
>> >> >> look at this reverse proxy tool:
>> >> >> http://www.saltypickle.com/Home/16
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:059772D9-D2AF-4725-A036-D8AB78B9CE04@.microsoft.com...
>> >> >> > Users on serverA are authenticated with a custom SQL login from
>> >> >> > the
>> >> >> > ASP
>> >> >> > pages. The entire site on serverA is classic ASP. We are trying
>> >> >> > to
>> >> >> > add
>> >> >> > the
>> >> >> > ASPX page with the report viewer control. We are able to
>> >> >> > determine
>> >> >> > if
>> >> >> > the
>> >> >> > users are authenticated once they hit the ASPX/Report Viewer
>> >> >> > page.
>> >> >> >
>> >> >> > We are using the 1.1 version of the report viewer control that
>> >> >> > came
>> >> >> > with
>> >> >> > SP1
>> >> >> > or SP2 for RS 2000.
>> >> >> >
>> >> >> > Once the web user accesses our ASPX page with the report viewer
>> >> >> > control
>> >> >> > how
>> >> >> > do we set the credentials that access the report server via URL?
>> >> >> > That
>> >> >> > is
>> >> >> > were everything stops working as planned and the standard login
>> >> >> > pop-up
>> >> >> > shows.
>> >> >> > You can type the credentials of the user we want them to access
>> >> >> > with
>> >> >> > and
>> >> >> > everything works fine from that point forward. But we want to
>> >> >> > set
>> >> >> > the
>> >> >> > credentials in the code-behind of the page and not make the
>> >> >> > credentials
>> >> >> > publicly available.
>> >> >> >
>> >> >> > Any help you could provide to set the credentials that will be
>> >> >> > used
>> >> >> > by
>> >> >> > the
>> >> >> > report viewer control would be greatly appreciated. I have
>> >> >> > poured
>> >> >> > many
>> >> >> > hours
>> >> >> > into these reports and the integration with the classic ASP site.
>> >> >> > The
>> >> >> > reports use custom assemblies to dynamically build the SQL
>> >> >> > statements,
>> >> >> > etc.
>> >> >> > but now I can't get internet access to them using the report
>> >> >> > viewer
>> >> >> > without
>> >> >> > manually typing in the credentials!
>> >> >> >
>> >> >> > Thank you very much.
>> >> >> >
>> >> >> >
>> >> >> > "Jéjé" wrote:
>> >> >> >
>> >> >> >> how your users are authenticated on the serverA?
>> >> >> >> (form authentication or basic authentication?)
>> >> >> >>
>> >> >> >> The reportviewer webcontrol is a ASP.Net 2.0 control.
>> >> >> >> do you use another version?
>> >> >> >> the .Net 2 version is great, because this version will do what
>> >> >> >> you
>> >> >> >> want
>> >> >> >> to
>> >> >> >> do!
>> >> >> >>
>> >> >> >> in .Net 1.1...
>> >> >> >> To solve your issue, you have to intercept and process the
>> >> >> >> reports
>> >> >> >> using
>> >> >> >> your own webpages and not authorize the user to access your
>> >> >> >> report
>> >> >> >> server
>> >> >> >> directly.
>> >> >> >> (the user must go through your own pages, so you control which
>> >> >> >> credential
>> >> >> >> will be used to access reportserver instead of prompting the
>> >> >> >> user)
>> >> >> >>
>> >> >> >>
>> >> >> >> "Chris_CamSoft" <ChrisCamSoft@.discussions.microsoft.com> wrote
>> >> >> >> in
>> >> >> >> message
>> >> >> >> news:96843F84-0BB8-46B4-8BF8-A9488F25A122@.microsoft.com...
>> >> >> >> > Hello,
>> >> >> >> >
>> >> >> >> > We are trying to avoid the login pop-up when using the report
>> >> >> >> > viewer
>> >> >> >> > control
>> >> >> >> > from an internet facing solution. Sorry it is long, but here
>> >> >> >> > is
>> >> >> >> > the
>> >> >> >> > scenario.
>> >> >> >> >
>> >> >> >> > ServerA (the webserver, windows 2000 server, v1.1 framework)
>> >> >> >> > is
>> >> >> >> > serving
>> >> >> >> > a
>> >> >> >> > legacy ASP application that we have added an ASP.NET page that
>> >> >> >> > uses
>> >> >> >> > the
>> >> >> >> > report viewer control to connect to ServerB.
>> >> >> >> >
>> >> >> >> > ServerB (the report server, windows 2003 server SP1, RS
>> >> >> >> > Standard
>> >> >> >> > Edition
>> >> >> >> > SP2) there is a public IP that is Nat's to a local IP of
>> >> >> >> > ServerB.
>> >> >> >> > This
>> >> >> >> > is
>> >> >> >> > what the report viewer control uses from ServerA. ServerB has
>> >> >> >> > a
>> >> >> >> > local
>> >> >> >> > user
>> >> >> >> > that has full access to the reports that need to be delivered.
>> >> >> >> >
>> >> >> >> > When you first try to access the report server (ServerB) from
>> >> >> >> > the
>> >> >> >> > internet
>> >> >> >> > it prompts for a username and password. Once the local user's
>> >> >> >> > credentials
>> >> >> >> > from ServerB have been entered we are able to view all reports
>> >> >> >> > until
>> >> >> >> > the
>> >> >> >> > browser is closed. We have RS 2000 Standard Edition so there
>> >> >> >> > is
>> >> >> >> > no
>> >> >> >> > option
>> >> >> >> > for
>> >> >> >> > a custom security extension.
>> >> >> >> >
>> >> >> >> > Is there anyway that we can avoid forcing the web users to
>> >> >> >> > type
>> >> >> >> > in
>> >> >> >> > the
>> >> >> >> > username and password that was setup on ServerB? I have tried
>> >> >> >> > everything
>> >> >> >> > I
>> >> >> >> > can think of and have had no success. There are many security
>> >> >> >> > issues
>> >> >> >> > with
>> >> >> >> > making that RS login public using URL access and even more
>> >> >> >> > security
>> >> >> >> > issues
>> >> >> >> > by
>> >> >> >> > making the report server allow anonymous access. I need a
>> >> >> >> > solution!
>> >> >> >> >
>> >> >> >> > Any help would be greatly appreciated.
>> >> >> >> >
>> >> >> >> > Thanks in advance!
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

report viewer web.config settings for remote mode without session state

Hi
I am using the new report viewer control that comes with VS2005. My
application does not use session state as it is clustered and so I have been
following the Microsoft article for implementing the IReportViewerConnection
and then adding a key for the ReportServerConnection in the web.config file.
http://msdn2.microsoft.com/en-us/library/ms251661.aspx
My implementation of the interface is called ReportServerConnection and is
within a namespace called eNate.ESP.ESPWeb.
In my web.cofig file I have the following key
<add key="ReportViewerServerConnection"
value="eNate.ESP.ESPWeb.ReportServerConnection, ReportServerConnection" />
When I try to load the asp.net page which contains the report viewer control
I get the following error message
Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type
eNate.ESP.ESPWeb.ReportServerConnection,
eNate.ESP.ESPWeb.ReportServerConnection does not implement
IReportServerConnection or could not be found.
I am definately implementing the interface but which ever way I try to
reference the class in the web.config key I always get this error.
The documentation about how to add this key file is not very clear and I
have not seen any other posts about this subject.
Could somebody please let me know how to reference this class correctly as I
think that is causing the error.
Thanks
Lewis Holmes
eNateHi Lewis,
Welcome to the MSDN newsgroup.
As for the custom IReportServerConnection class, we need to specify the
AssemblyQualified name which include the Class's full name, assembly name,
version, culture and publickeytoken info. For example:
<add key="ReportViewerServerConnection"
value="ControLibrary.SimpleReportServerConnection, ControLibrary,
Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"/>
You can printout the class's assemblyQualified name through the below code:
Response.Write("<br/>" +
typeof(ControLibrary.SimpleReportServerConnection).AssemblyQualifiedName);
In addition, I agree that the document about the ReportViewer web.config
interfaces is not quite complete and sufficient. I suggest you also submit
this to the msdn product feedback center:
http://lab.msdn.microsoft.com/productfeedback/default.aspx
If there is anything else we can help, please feel free to post here.
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Thanks so much Steven!
I have got it to work now.
Regards
Lewis Holmes
eNate
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:ZYha8E$RGHA.6904@.TK2MSFTNGXA03.phx.gbl...
> Hi Lewis,
> Welcome to the MSDN newsgroup.
> As for the custom IReportServerConnection class, we need to specify the
> AssemblyQualified name which include the Class's full name, assembly name,
> version, culture and publickeytoken info. For example:
> <add key="ReportViewerServerConnection"
> value="ControLibrary.SimpleReportServerConnection, ControLibrary,
> Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"/>
> You can printout the class's assemblyQualified name through the below
> code:
> Response.Write("<br/>" +
> typeof(ControLibrary.SimpleReportServerConnection).AssemblyQualifiedName);
> In addition, I agree that the document about the ReportViewer web.config
> interfaces is not quite complete and sufficient. I suggest you also submit
> this to the msdn product feedback center:
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
> If there is anything else we can help, please feel free to post here.
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
>sql

Monday, March 26, 2012

Report Viewer Question

I am using rs on a SQL 2000 DB and have an application built using VWDE 2005
to display reports. I installed the ReportViewer control and set the
appropriate URL and report path. When I open the page, I first get a popup
to enter the password (is there a way to avoid this?) and then I get what
looks like a report manager window on the screen. I have to navigate to my
reports, select the one I want and then click on the "Full Screen" icon to
see the report.
How can I get a page to simply present the report when opened?
WayneIs the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going to
use the new controls to display reports you need to have RS 2005 installed
(which can use a SQL Server 2000 DB, that is what I am doing).
If you want it hardcode during design then using the for Report Path (click
on the upper right of the control to fill in the report tasks) put in
something like this: /MyFolder/MyReport not sure if case sensitive but it
could be. For your server this is what I have: http://Myserver/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>I am using rs on a SQL 2000 DB and have an application built using VWDE
>2005 to display reports. I installed the ReportViewer control and set the
>appropriate URL and report path. When I open the page, I first get a popup
>to enter the password (is there a way to avoid this?) and then I get what
>looks like a report manager window on the screen. I have to navigate to my
>reports, select the one I want and then click on the "Full Screen" icon to
>see the report.
> How can I get a page to simply present the report when opened?
> Wayne
>|||The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I don't
own the server.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going to
> use the new controls to display reports you need to have RS 2005 installed
> (which can use a SQL Server 2000 DB, that is what I am doing).
> If you want it hardcode during design then using the for Report Path
> (click on the upper right of the control to fill in the report tasks) put
> in something like this: /MyFolder/MyReport not sure if case sensitive
> but it could be. For your server this is what I have:
> http://Myserver/ReportServer
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set the
>>appropriate URL and report path. When I open the page, I first get a popup
>>to enter the password (is there a way to avoid this?) and then I get what
>>looks like a report manager window on the screen. I have to navigate to my
>>reports, select the one I want and then click on the "Full Screen" icon to
>>see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>|||I am pretty sure that the server needs to be RS2005. Looking at the info on
the controls it specifies RS 2005 for the server report. If you service
upgrades to RS 2005, they can continue to host RS 2000 reports. RS 2005 is
supposed to be backward compatible.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:OGU9aOd%23FHA.2300@.TK2MSFTNGP10.phx.gbl...
> The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I don't
> own the server.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
>> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going
>> to use the new controls to display reports you need to have RS 2005
>> installed (which can use a SQL Server 2000 DB, that is what I am doing).
>> If you want it hardcode during design then using the for Report Path
>> (click on the upper right of the control to fill in the report tasks) put
>> in something like this: /MyFolder/MyReport not sure if case sensitive
>> but it could be. For your server this is what I have:
>> http://Myserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set the
>>appropriate URL and report path. When I open the page, I first get a
>>popup to enter the password (is there a way to avoid this?) and then I
>>get what looks like a report manager window on the screen. I have to
>>navigate to my reports, select the one I want and then click on the "Full
>>Screen" icon to see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>>
>|||Thanks for the information - I'll check with my service provider.
Wayne
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23GcxKud%23FHA.160@.TK2MSFTNGP12.phx.gbl...
>I am pretty sure that the server needs to be RS2005. Looking at the info on
>the controls it specifies RS 2005 for the server report. If you service
>upgrades to RS 2005, they can continue to host RS 2000 reports. RS 2005 is
>supposed to be backward compatible.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:OGU9aOd%23FHA.2300@.TK2MSFTNGP10.phx.gbl...
>> The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I
>> don't own the server.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
>> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going
>> to use the new controls to display reports you need to have RS 2005
>> installed (which can use a SQL Server 2000 DB, that is what I am doing).
>> If you want it hardcode during design then using the for Report Path
>> (click on the upper right of the control to fill in the report tasks)
>> put in something like this: /MyFolder/MyReport not sure if case
>> sensitive but it could be. For your server this is what I have:
>> http://Myserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set
>>the appropriate URL and report path. When I open the page, I first get a
>>popup to enter the password (is there a way to avoid this?) and then I
>>get what looks like a report manager window on the screen. I have to
>>navigate to my reports, select the one I want and then click on the
>>"Full Screen" icon to see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>>
>>
>

Report Viewer Parameter Dropdown width

Does anyone know how to control the width of the parameter dropdownlist? If you select "Multi-value" for the parameter (non-sp1 version) the parameter list is in a dropdownlist that is manageable in size. If you do not use the multi-value parameter, it looks like the width of the dropdownlist is determined by the width of the longest text of the returned parameters.

Is there any way to control the width of the dropdown?

Thanks

Rob

pretty sure there is no way to do this|||

I spent some time "fighting" with this problem. The only way this might be achieved is to play with the customizable style sheets for the Report Manager.

I solved my problem by making the text in the multi-value dropdown smaller.

|||

Hi

Where can I find this style sheet?
I've had this problem since I started using
SSRS 4 months ago.

Thanks

G

|||

here you can find all the info you need: http://msdn2.microsoft.com/en-us/library/ms345247.aspx.

Also, maybe you'll find this post useful: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1084925&SiteID=1

|||

Thanks alot!

I only now saw your other post...
Marked as hepfull

G

sql

Report Viewer Parameter Dropdown width

Does anyone know how to control the width of the parameter dropdownlist? If you select "Multi-value" for the parameter (non-sp1 version) the parameter list is in a dropdownlist that is manageable in size. If you do not use the multi-value parameter, it looks like the width of the dropdownlist is determined by the width of the longest text of the returned parameters.

Is there any way to control the width of the dropdown?

Thanks

Rob

pretty sure there is no way to do this|||

I spent some time "fighting" with this problem. The only way this might be achieved is to play with the customizable style sheets for the Report Manager.

I solved my problem by making the text in the multi-value dropdown smaller.

|||

Hi

Where can I find this style sheet?
I've had this problem since I started using
SSRS 4 months ago.

Thanks

G

|||

here you can find all the info you need: http://msdn2.microsoft.com/en-us/library/ms345247.aspx.

Also, maybe you'll find this post useful: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1084925&SiteID=1

|||

Thanks alot!

I only now saw your other post...
Marked as hepfull

G

Report Viewer on Internet Site

Hi, I am developing a website that will use the VS Report Viewer control to display some business reports.....The website will be on the internet, but the report viewer will need to access an internal report server that the internet users don't have access to? Is this possible, or the correct way to do this? Any ideas / suggestions would be appreciated!

Cheers
Chris

If you use anonymous access then the user who is accessing the report from the internet does not have to authenticate any type of username to the server.

However, you probably don't want just ANYONE to see your reports, so you may want to develop a secure front-end with Visual Studio to authenticate the user in that fashion. Sort of like a portal on a website. If you go this route, be sure to use a stored procedure and possibly encryption for your password I/O.

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

Hi

I am trying to display Microsoft Reporting Service Reports from windows application.

I have application window with Report viewer control.

I have assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports

Error is "

"The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed with HTTP status 404: Not Found.

Please help me..Do I need to set any credential for my reportviewer control? then how?

this.reportViewer1.ServerReport.DisplayName = "SampleReport";

this.reportViewer1.ServerReport.ReportPath = "/SampleReportFolder/SampleReport";

this.reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://laptop/reportserver", System.UriKind.Absolute);

thanks in advance.

KamalKamal,

What version of Report Server are you connecting to? The ReportViewer control is not compatible with SQL Server 2000 Reporting Services. You need the April CTP of Report Server. Your code looks OK otherwise.

Rajeev|||

I do have the same problem. My installation is:

- VS.NET 2003
- Sql Server 2000 Dev
- Reporting Services for Sql Server 2000 + SP1
- VS.NET 2005 Beta 2
- Sql Server 2005 CTP April 2005

I would like to use VS.NET 2005 Beta 2 under "Go live license" but need the Sql Server 2000 Reporting Services as my customer will not upgrade a existing Sql Server 2000 installation.

Is it possible to use this combination?

Thanks,
Dirk

|||

Please make sure your setting in your webconfig

[Thanks to Akilal_MSFT]

- fix the ReportService.asmx error with replacing the <assemblies> section in the <system.web> section of the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config file:

<assemblies>
<clear />
<add assembly="ReportingServicesWebServer" />
<add assembly="mscorlib" />
<add assembly="System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</assemblies>

Make sure the web.config files for reportserver and reportmanager have full access:
Change the following line in both web.config files:
<trust level="Full" originUrl="" />
Location: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
and: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

|||

Hai,
I create a window application and i wish to use the report viewer to view the reports that published to the server. Here is my code in VB.NEt

ReportViewer1.ServerReport.DisplayName = "SampleReport"

ReportViewer1.ServerReport.ReportPath = "/SampleReport/Report1"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://localhost/reportserver")

Is there any problem to my code? why the report viewer didnt show anything and no error occured when i run the application?

the real path to show the report using report manager is as below:
http://localhost/ReportServer/Pages/ReportViewer.aspx?/SampleReport/Report1&rs:Command=Render
Am i need to change the reportpath same as above?

Another question is : Can i print the reports using my application? means i press a button print in my application and then the report can be print without using the report viewer.

Kindly wait for your reply.
Please email to me too if possible : elainelikim@.gmail.com

|||Did you find the solution to the above problem? I am having a similar issue. I add a reportviewer control in my webapp. I am using the ServerReprot and did specify report path etc. When I view the form, I can see the parameter page for the report fine but when I click on View report button, it basically does not do anything.
Thanks|||

Your issue is because it is SQL 2k RS you are hitting.

I have the same issue and have not found the resolution yet.

Except I have read things suggesting the VS05 ReportViewer does not work with SQL 2000 RS. I suppose it seems right to me; I have resorted to a Web Browser control in WinForms as a temp fix to the issue.

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

Hi

I am trying to display Microsoft Reporting Service Reports from windows application.

I have application window with Report viewer control.

I have assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports

Error is "

"The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed with HTTP status 404: Not Found.

Please help me..Do I need to set any credential for my reportviewer control? then how?

this.reportViewer1.ServerReport.DisplayName = "SampleReport";

this.reportViewer1.ServerReport.ReportPath = "/SampleReportFolder/SampleReport";

this.reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://laptop/reportserver", System.UriKind.Absolute);

thanks in advance.

KamalKamal,

What version of Report Server are you connecting to? The ReportViewer control is not compatible with SQL Server 2000 Reporting Services. You need the April CTP of Report Server. Your code looks OK otherwise.

Rajeev
|||

I do have the same problem. My installation is:

- VS.NET 2003
- Sql Server 2000 Dev
- Reporting Services for Sql Server 2000 + SP1
- VS.NET 2005 Beta 2
- Sql Server 2005 CTP April 2005

I would like to use VS.NET 2005 Beta 2 under "Go live license" but need the Sql Server 2000 Reporting Services as my customer will not upgrade a existing Sql Server 2000 installation.

Is it possible to use this combination?

Thanks,
Dirk

|||

Please make sure your setting in your webconfig

[Thanks to Akilal_MSFT]

- fix the ReportService.asmx error with replacing the <assemblies> section in the <system.web> section of the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config file:

<assemblies>
<clear />
<add assembly="ReportingServicesWebServer" />
<add assembly="mscorlib" />
<add assembly="System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</assemblies>

Make sure the web.config files for reportserver and reportmanager have full access:
Change the following line in both web.config files:
<trust level="Full" originUrl="" />
Location: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
and: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

|||

Hai,
I create a window application and i wish to use the report viewer to view the reports that published to the server. Here is my code in VB.NEt

ReportViewer1.ServerReport.DisplayName = "SampleReport"

ReportViewer1.ServerReport.ReportPath = "/SampleReport/Report1"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://localhost/reportserver")

Is there any problem to my code? why the report viewer didnt show anything and no error occured when i run the application?

the real path to show the report using report manager is as below:
http://localhost/ReportServer/Pages/ReportViewer.aspx?/SampleReport/Report1&rs:Command=Render
Am i need to change the reportpath same as above?

Another question is : Can i print the reports using my application? means i press a button print in my application and then the report can be print without using the report viewer.

Kindly wait for your reply.
Please email to me too if possible : elainelikim@.gmail.com

|||Did you find the solution to the above problem? I am having a similar issue. I add a reportviewer control in my webapp. I am using the ServerReprot and did specify report path etc. When I view the form, I can see the parameter page for the report fine but when I click on View report button, it basically does not do anything.
Thanks
|||

Your issue is because it is SQL 2k RS you are hitting.

I have the same issue and have not found the resolution yet.

Except I have read things suggesting the VS05 ReportViewer does not work with SQL 2000 RS. I suppose it seems right to me; I have resorted to a Web Browser control in WinForms as a temp fix to the issue.