Last post Jul 06, 2011 03:31 PM by mezzanine74
Jun 24, 2011 08:03 AM|mezzanine74|LINK
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
Jun 26, 2011 10:30 PM|You-Hu Fu|LINK
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.
Jun 27, 2011 08:56 AM|mezzanine74|LINK
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.
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?
Jul 04, 2011 06:17 AM|You-Hu Fu|LINK
It shoule be the report server URL not report manager, please have a try and give the feedback if you have any question.
Jul 05, 2011 09:04 AM|mezzanine74|LINK
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.
Jul 05, 2011 09:11 PM|You-Hu Fu|LINK
Are dsu and dsp your parameters of UserName and PassWord? If so I think you should modify your URL to
Just like this sample URL:
Jul 06, 2011 03:31 PM|mezzanine74|LINK