Showing posts with label viewer. Show all posts
Showing posts with label viewer. 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/Explorer-WebPart missing under SharePoint v3+SQL Server 2005

Hello all,

I'm new with SP v3 and the Reporting Services of SQL Server 2005.

I did a prototyp report and show it with "SQL Reporting Services
Report"-WebPart, but I can't find the WebParts Report Viewer and
Explorer in the WebPart Gallery.

Please, could somebody give me a clue where the problem could be, or
how I could isolate the problem area.

Cheers
Marc

Salut Marc,

If you seach the keyword "web parts" in the help module you will find how to add the SSRS web parts ...

Try this dos command

--

C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN\STSADM.EXE -o addwppack -filename "C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint\RSWebParts.cab"

--

Regards

Ayzan

|||

Hello Ayzan,

thanks a lot for your help - works fine!

The only thing i wonder is that the stsadm-console-tool did deploy the webparts through the CAP-File, but neither do the webparts appear after the "add webparts" view nor do they reside in the webparts library under site settings.

When I do the stsadm -o enumwppacks command the webparts are listed!

So did I miss something...is there another procedure now in SP v3, or is it a further security setting?

Thanks again!

Cheers,

Marc

|||

You did not miss something ... Bill did ;-)

Click on "Modify the workspace" and 'Add Wep Parts".

When the right zone appears click on "Create Lists" and "Browse".

Choose "Virtual Server Gallery" ... and it should be there ...

Regards

Ayzan

|||

Hey Ayzan,

I got it...really amazing usability...its all so intuitive...good effort, Bill :D!

U are the man:)

Have a nice day,

Marc

|||

Sorry, I forgot to ask you if you already have a documentation for Sharepoint v3, or some useful links?

Cheers

Marc

|||

Nop, we are working on a test platform, so we didn't spend time on writing a documentation. But you can post your questions, I will try answer.

Regards

Ayzan

|||

Hello Ayzan,

how are you?

For me, I'm still not sure about the most reasonable way to go, although I'm dealing with SSRS for about 3 weeks.

The requirements for the our reporting system are:

1.-Reports depend on the current user (e.g. choice of report parameter, rights)
2.-Reports consist of a comprehensive collection of different paramater types
3.-OLAP/Cubes will be applied
4.-Ad-Hoc Reports should be offered (Report-Builder might be to complex and too less user-friendly for users)

My outcome for now:

Report Viewer Control looks like a possible "out-of-the-box" solution, but

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

Thanks a lot for any help!

Cheers,
Marc

|||

Hi Marc,

First of all, don't think that I am a Sql 2005 expert, I am just a project manager. My team and I, have been working on Sql 2005 for 3 months now, so as to build dashboard portal prototype, using SSAS for the cubes, SSRS for reporting, and Sharepoint services as web framework.

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

We manage security and access to dimension occurrences through SSAS roles.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

Good question, if you find how, please tell me ;-)). I know that some new features will be implemented with the SP1, I hope it will be one of them

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

Wouuu, humm ... I don't know

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

We don't use Report Builder, because there is no real added value. Currently, excel (pivot tables with SSAS connection) seems to be the best solution. Avoid to use the SSAS Excel Plugin. You can also check solutions like Temtec

|||

Ayzan, thanks for your quick reply:)

If i get it right you "just" apply the out-of-the-box reporting via Report Viewer WebPart and define and manage all the security and access issues already before in the backend by SSAS roles.

Does this mean you are satisfied with the customization of the parameter area for the users and also you don't have any user-specific parameter-item choices so that there is no reason to apply the Report Server WebService API?

I have already thought about the excel-pivot tables with SSAS solution, but haven't had time to do enough research or rather develop a prototype, but probably it would be worthwile to dive deeper into this.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Which impacts has SSAS regarding performance, flexibility, effort and maintenance?

If you like, I'll send you my white-papers and presentations about the research and prototype-work I'll do in the following weeks:)

Cheers

Marc

|||

As you said, we "just" apply the SSRS/SSAS comon framework. But remember, that we work on a prototype, the real BI project will begin soon. So, my users are satisfied with the current interface as they didn't have any bi application before.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Well, in my opinion, we did not investigate SSAS features as deep as I expected. Although SSRS and SSAS cover more than our real needs, the biggest problem, I have, is that I can't find a SSAS/MDX expert (2005 version) ... and I am desesperatly expecting SSAS step by step book ;-). Nevertheless, we manage to set up 4 cubes, easaly, with partitioning, security, without coding a line of mdx and with no data mining (next step).

Concerning maintenance and felxibility, remember, it's a prototype ;-). Our 4 cubes contains 2 partitions (hsitory and current month), and the current month partition is reprocessed twice a day, and from now we never experienced a problem ...

I will be glad to read you whitepapers and presentations.

Regards

Ayzan

|||

Hi ,

Can any one help me to create a webpart which is a report explorer for WSS using asp.net. If you any code snippet can you help me out with this.

regards

Sahu

Report Viewer/Explorer-WebPart missing under SharePoint v3+SQL Server 2005

Hello all,

I'm new with SP v3 and the Reporting Services of SQL Server 2005.

I did a prototyp report and show it with "SQL Reporting Services
Report"-WebPart, but I can't find the WebParts Report Viewer and
Explorer in the WebPart Gallery.

Please, could somebody give me a clue where the problem could be, or
how I could isolate the problem area.

Cheers
Marc

Salut Marc,

If you seach the keyword "web parts" in the help module you will find how to add the SSRS web parts ...

Try this dos command

--

C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN\STSADM.EXE -o addwppack -filename "C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint\RSWebParts.cab"

--

Regards

Ayzan

|||

Hello Ayzan,

thanks a lot for your help - works fine!

The only thing i wonder is that the stsadm-console-tool did deploy the webparts through the CAP-File, but neither do the webparts appear after the "add webparts" view nor do they reside in the webparts library under site settings.

When I do the stsadm -o enumwppacks command the webparts are listed!

So did I miss something...is there another procedure now in SP v3, or is it a further security setting?

Thanks again!

Cheers,

Marc

|||

You did not miss something ... Bill did ;-)

Click on "Modify the workspace" and 'Add Wep Parts".

When the right zone appears click on "Create Lists" and "Browse".

Choose "Virtual Server Gallery" ... and it should be there ...

Regards

Ayzan

|||

Hey Ayzan,

I got it...really amazing usability...its all so intuitive...good effort, Bill :D!

U are the man:)

Have a nice day,

Marc

|||

Sorry, I forgot to ask you if you already have a documentation for Sharepoint v3, or some useful links?

Cheers

Marc

|||

Nop, we are working on a test platform, so we didn't spend time on writing a documentation. But you can post your questions, I will try answer.

Regards

Ayzan

|||

Hello Ayzan,

how are you?

For me, I'm still not sure about the most reasonable way to go, although I'm dealing with SSRS for about 3 weeks.

The requirements for the our reporting system are:

1.-Reports depend on the current user (e.g. choice of report parameter, rights)
2.-Reports consist of a comprehensive collection of different paramater types
3.-OLAP/Cubes will be applied
4.-Ad-Hoc Reports should be offered (Report-Builder might be to complex and too less user-friendly for users)

My outcome for now:

Report Viewer Control looks like a possible "out-of-the-box" solution, but

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

Thanks a lot for any help!

Cheers,
Marc

|||

Hi Marc,

First of all, don't think that I am a Sql 2005 expert, I am just a project manager. My team and I, have been working on Sql 2005 for 3 months now, so as to build dashboard portal prototype, using SSAS for the cubes, SSRS for reporting, and Sharepoint services as web framework.

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

We manage security and access to dimension occurrences through SSAS roles.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

Good question, if you find how, please tell me ;-)). I know that some new features will be implemented with the SP1, I hope it will be one of them

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

Wouuu, humm ... I don't know

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

We don't use Report Builder, because there is no real added value. Currently, excel (pivot tables with SSAS connection) seems to be the best solution. Avoid to use the SSAS Excel Plugin. You can also check solutions like Temtec

|||

Ayzan, thanks for your quick reply:)

If i get it right you "just" apply the out-of-the-box reporting via Report Viewer WebPart and define and manage all the security and access issues already before in the backend by SSAS roles.

Does this mean you are satisfied with the customization of the parameter area for the users and also you don't have any user-specific parameter-item choices so that there is no reason to apply the Report Server WebService API?

I have already thought about the excel-pivot tables with SSAS solution, but haven't had time to do enough research or rather develop a prototype, but probably it would be worthwile to dive deeper into this.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Which impacts has SSAS regarding performance, flexibility, effort and maintenance?

If you like, I'll send you my white-papers and presentations about the research and prototype-work I'll do in the following weeks:)

Cheers

Marc

|||

As you said, we "just" apply the SSRS/SSAS comon framework. But remember, that we work on a prototype, the real BI project will begin soon. So, my users are satisfied with the current interface as they didn't have any bi application before.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Well, in my opinion, we did not investigate SSAS features as deep as I expected. Although SSRS and SSAS cover more than our real needs, the biggest problem, I have, is that I can't find a SSAS/MDX expert (2005 version) ... and I am desesperatly expecting SSAS step by step book ;-). Nevertheless, we manage to set up 4 cubes, easaly, with partitioning, security, without coding a line of mdx and with no data mining (next step).

Concerning maintenance and felxibility, remember, it's a prototype ;-). Our 4 cubes contains 2 partitions (hsitory and current month), and the current month partition is reprocessed twice a day, and from now we never experienced a problem ...

I will be glad to read you whitepapers and presentations.

Regards

Ayzan

|||

Hi ,

Can any one help me to create a webpart which is a report explorer for WSS using asp.net. If you any code snippet can you help me out with this.

regards

Sahu

sql

Report Viewer/Explorer-WebPart missing under SharePoint v3+SQL Server 2005

Hello all,

I'm new with SP v3 and the Reporting Services of SQL Server 2005.

I did a prototyp report and show it with "SQL Reporting Services
Report"-WebPart, but I can't find the WebParts Report Viewer and
Explorer in the WebPart Gallery.

Please, could somebody give me a clue where the problem could be, or
how I could isolate the problem area.

Cheers
Marc

Salut Marc,

If you seach the keyword "web parts" in the help module you will find how to add the SSRS web parts ...

Try this dos command

--

C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN\STSADM.EXE -o addwppack -filename "C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint\RSWebParts.cab"

--

Regards

Ayzan

|||

Hello Ayzan,

thanks a lot for your help - works fine!

The only thing i wonder is that the stsadm-console-tool did deploy the webparts through the CAP-File, but neither do the webparts appear after the "add webparts" view nor do they reside in the webparts library under site settings.

When I do the stsadm -o enumwppacks command the webparts are listed!

So did I miss something...is there another procedure now in SP v3, or is it a further security setting?

Thanks again!

Cheers,

Marc

|||

You did not miss something ... Bill did ;-)

Click on "Modify the workspace" and 'Add Wep Parts".

When the right zone appears click on "Create Lists" and "Browse".

Choose "Virtual Server Gallery" ... and it should be there ...

Regards

Ayzan

|||

Hey Ayzan,

I got it...really amazing usability...its all so intuitive...good effort, Bill :D!

U are the man:)

Have a nice day,

Marc

|||

Sorry, I forgot to ask you if you already have a documentation for Sharepoint v3, or some useful links?

Cheers

Marc

|||

Nop, we are working on a test platform, so we didn't spend time on writing a documentation. But you can post your questions, I will try answer.

Regards

Ayzan

|||

Hello Ayzan,

how are you?

For me, I'm still not sure about the most reasonable way to go, although I'm dealing with SSRS for about 3 weeks.

The requirements for the our reporting system are:

1.-Reports depend on the current user (e.g. choice of report parameter, rights)
2.-Reports consist of a comprehensive collection of different paramater types
3.-OLAP/Cubes will be applied
4.-Ad-Hoc Reports should be offered (Report-Builder might be to complex and too less user-friendly for users)

My outcome for now:

Report Viewer Control looks like a possible "out-of-the-box" solution, but

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

Thanks a lot for any help!

Cheers,
Marc

|||

Hi Marc,

First of all, don't think that I am a Sql 2005 expert, I am just a project manager. My team and I, have been working on Sql 2005 for 3 months now, so as to build dashboard portal prototype, using SSAS for the cubes, SSRS for reporting, and Sharepoint services as web framework.

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

We manage security and access to dimension occurrences through SSAS roles.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

Good question, if you find how, please tell me ;-)). I know that some new features will be implemented with the SP1, I hope it will be one of them

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

Wouuu, humm ... I don't know

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

We don't use Report Builder, because there is no real added value. Currently, excel (pivot tables with SSAS connection) seems to be the best solution. Avoid to use the SSAS Excel Plugin. You can also check solutions like Temtec

|||

Ayzan, thanks for your quick reply:)

If i get it right you "just" apply the out-of-the-box reporting via Report Viewer WebPart and define and manage all the security and access issues already before in the backend by SSAS roles.

Does this mean you are satisfied with the customization of the parameter area for the users and also you don't have any user-specific parameter-item choices so that there is no reason to apply the Report Server WebService API?

I have already thought about the excel-pivot tables with SSAS solution, but haven't had time to do enough research or rather develop a prototype, but probably it would be worthwile to dive deeper into this.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Which impacts has SSAS regarding performance, flexibility, effort and maintenance?

If you like, I'll send you my white-papers and presentations about the research and prototype-work I'll do in the following weeks:)

Cheers

Marc

|||

As you said, we "just" apply the SSRS/SSAS comon framework. But remember, that we work on a prototype, the real BI project will begin soon. So, my users are satisfied with the current interface as they didn't have any bi application before.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Well, in my opinion, we did not investigate SSAS features as deep as I expected. Although SSRS and SSAS cover more than our real needs, the biggest problem, I have, is that I can't find a SSAS/MDX expert (2005 version) ... and I am desesperatly expecting SSAS step by step book ;-). Nevertheless, we manage to set up 4 cubes, easaly, with partitioning, security, without coding a line of mdx and with no data mining (next step).

Concerning maintenance and felxibility, remember, it's a prototype ;-). Our 4 cubes contains 2 partitions (hsitory and current month), and the current month partition is reprocessed twice a day, and from now we never experienced a problem ...

I will be glad to read you whitepapers and presentations.

Regards

Ayzan

|||

Hi ,

Can any one help me to create a webpart which is a report explorer for WSS using asp.net. If you any code snippet can you help me out with this.

regards

Sahu

Report Viewer/Default Parameters

Is it possible for one report to have different default parameters, based on the user viewing the report, when the report is accessed via the Report Viewer?

Thanks.

Assuming you are asking for viewing report through report server: default values can be (1) constant, (2) expression-based, or (3) dataset based.

Regarding (2): you could determine the default value based on the current userid, e.g =iif(User!UserId="abc", "Default1", "Default2")

Regarding (3): you could use the current user information in the query commandtext or as parameter into a stored procedure to dynamically determine the default value.

-- Robert

|||

If you are using the ReportViewer control in ASP.NET, you can set the value of the parameter programatically based on the current user identity:

this.ReportViewer1.ServerReport.ReportPath = "/SampleReports/Employee Sales Summary";

ReportParameter p = new ReportParameter("EmpID", "20");

this.ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { p });

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!
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>