Answered by:
Report Manager

Question
-
User-1312722619 posted
hi,
I would like to use Report Manager to display several reports. (ReportViewer is not working for me in this new server, so it is not option now)
Can you please help me to find a link or book to study following subjects.
- Passing credentials to skip Login control
- Passing parameters to reports with QueryString
- Preventing user to get home page just to make sure he doesnt delete any file.
- Manuplating aspx files of Report Manager, writing codes if possible
- Creating new users and control their roles
Friday, June 24, 2011 8:03 AM
Answers
-
User1471008070 posted
Hi,
If you are the administrator, just give the user enough permission for logining in your report manager, besides if you want to create new users and control their roles, you can refer to this tutorial about Setting Permissions in Reporting Services
To your second question, it seems you want to pass the parameter's value to report from URL, right? If so I think you can make use of URL's access in reporting services, please see this article for detail about Using URL Access Parameters
You cannot Manuplate aspx files of Report Manager and write codes, as all reporting services' page have been compiled, it is not recommend to modify their source code. If you have to do it, I would recommend you make use of Web Services of reporting services, as SQL Server Reporting Services provides access to the full functionality of the report server through the Report Server Web service. The Report Server Web service is an XML Web service with a SOAP API. It uses SOAP over HTTP and acts as a communications interface between client programs and the report server. The Web service provides two endpoints - one for report execution and one for report management - with methods that expose the functionality of the report server and enable you to create custom tools for any part of the report life cycle.
There are three primary ways to develop Reporting Services applications based on the Web service. You can:
-
Develop applications using Microsoft Visual Studio and the Microsoft .NET Framework SDK. For more information about using the .NET Framework to build Web service applications, see Building Applications Using the Web Service and the .NET Framework.
-
Develop applications using the rs utility (RS.exe), the Reporting Services script environment. With Reporting Services and Visual Basic scripts, you can run any of the Report Server Web service operations. For more information about scripting in Reporting Services, see Scripting with the rs Utility and the Web Service.
-
Develop applications using any SOAP-enabled set of development tools. For more information, see The Role of SOAP in Reporting Services.
If you have any other question, please feel free to ask.
Thanks,
Challen Fu- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Sunday, June 26, 2011 10:30 PM -
All replies
-
User1471008070 posted
Hi,
If you are the administrator, just give the user enough permission for logining in your report manager, besides if you want to create new users and control their roles, you can refer to this tutorial about Setting Permissions in Reporting Services
To your second question, it seems you want to pass the parameter's value to report from URL, right? If so I think you can make use of URL's access in reporting services, please see this article for detail about Using URL Access Parameters
You cannot Manuplate aspx files of Report Manager and write codes, as all reporting services' page have been compiled, it is not recommend to modify their source code. If you have to do it, I would recommend you make use of Web Services of reporting services, as SQL Server Reporting Services provides access to the full functionality of the report server through the Report Server Web service. The Report Server Web service is an XML Web service with a SOAP API. It uses SOAP over HTTP and acts as a communications interface between client programs and the report server. The Web service provides two endpoints - one for report execution and one for report management - with methods that expose the functionality of the report server and enable you to create custom tools for any part of the report life cycle.
There are three primary ways to develop Reporting Services applications based on the Web service. You can:
-
Develop applications using Microsoft Visual Studio and the Microsoft .NET Framework SDK. For more information about using the .NET Framework to build Web service applications, see Building Applications Using the Web Service and the .NET Framework.
-
Develop applications using the rs utility (RS.exe), the Reporting Services script environment. With Reporting Services and Visual Basic scripts, you can run any of the Report Server Web service operations. For more information about scripting in Reporting Services, see Scripting with the rs Utility and the Web Service.
-
Develop applications using any SOAP-enabled set of development tools. For more information, see The Role of SOAP in Reporting Services.
If you have any other question, please feel free to ask.
Thanks,
Challen Fu- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Sunday, June 26, 2011 10:30 PM -
-
User-1312722619 posted
Hi You Hu Fu,
Thanks for your reply. I have created user and roles successfully. I can login to report manager by using my username and password.
username: PTS\MyUserName
password: MyPassword
I am trying to bybass login by providing this credentials on URL (i know this is not recommenden, just for test)
None of them working. It is still asking me my password. How can i fix this, any idea?
http://pts/Reports_SQLEXPRESS?/karadumanco/reports/testreport&dsu:MyUserName&dsp:MyPassword
http://pts/Reports_SQLEXPRESS?/karadumanco/reports/testreport&dsu:PTS\MyUserName&dsp:MyPassword
http://pts/Reports_SQLEXPRESS?/karadumanco/reports/testreport&dsu:PTS/MyUserName&dsp:MyPassword
Monday, June 27, 2011 8:56 AM -
User1471008070 posted
Hi,
It shoule be the report server URL not report manager, please have a try and give the feedback if you have any question.
Monday, July 4, 2011 6:17 AM -
User-1312722619 posted
Hi, yes i noticed that i used wrong adress. now i changed it accordingly.
i am able to pass query parameters with the new syntax.. but i am not still not able to pass username and password.
This adress run the report and pass projectID successfully. No toolbar as i need.
But this link still asking me my username and password.
Actually, i solved the problem with ReportViewer, so i will show all my reports by ReportViewer. But this is still a mystery and still trying to understand where i am doing wrong. I would like to learn if possible.
Thanks.
Tuesday, July 5, 2011 9:04 AM -
User1471008070 posted
Hi,
Are dsu and dsp your parameters of UserName and PassWord? If so I think you should modify your URL to
&dsu=YourName&dsp=YourPassword
Just like this sample URL:
http://<Server Name>/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&Year=2002
Tuesday, July 5, 2011 9:11 PM -
User-1312722619 posted
Hi, My syntaxvis correct, i am sure. I think i need to change some settings in webconfig?Wednesday, July 6, 2011 3:31 PM