.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SSRS - Retreiving generated Parameters from Report Server created by using StoredParametersID

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

SSRS - Microsoft SQL Server Reporting Services Version 9.00.4309.00

Problem - StoredParametersID is an rs: (report server) parameter and is not a valid Report Parm and can not be used in web services calls as a parameter. It can not be used as <deviceinfo> and it cannot be used as a "ReportPath" in the web services call.

How can I retreive the current set of generated parameters that are created on the report server side, so I can use these to make a web services call to retreive the Drill Down report since the only method to retreive the report information seems to be a Report URL call with the StoredParametersID included.


View Complete Post

More Related Resource Links

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

How to export SSRS report to PDF from SSIS with parameters

Hello everyone.  I am trying to setup a process in which a user, who is using a vb.net 2008 application, will need to  trigger the creation of two items.  The first is  SSRS report which will need to be exported to PDF format to a shared folder on the network.  This report accepts one parameter.  The second thing that will need to be created at the same time is an excel file with data exported from SQL Server 2008 which is generated through an SSIS package.  A couple things to note.  The excel file and the pdf file need to have the same file name, other than the extension.  For example P00000001_20100831.pdf and P00000001_20100831.xlsx and will both be stored in the same network share.  The filenames need to be created dynamically at run time and will be based on a parameter being passed to the report. So far I have the portion that creates the excel file working fine.  The way I create that is as follows.  I have a stored procedure that creates a job which calls the SSIS package and passes the appropriate parameters to the SSIS package.  After the job is created I immediately run it and then delete the job.  Ok, everything works fine with that. Now I cant seem to figure out how to get the pdf created.  If possible I would like to keep this portion together with the already created job or package.&nb

A connection could not be made to the report server - Problem deploying an SSRS report from Business

I’m having trouble with what seems to be a common issue for people, regarding deployment of an SSRS report from Business Intelligence Development Studio. Unfortunately none of the solution I have seen posted here (and elsewhere) have been able to help me so far.   Two of my collegaues can both deploy with no problem, and I am using exactly the same Target destinations as them (TargetDataSourceFolder, TargetReportFolder, TargetServerURL).   I have posted the error message below, which from my basic understaning would indicate, I think, a security issue (perhaps something local to my PC, or user account)   Has anyone experienced this particular issue who might be able to help?   Best wishes, Jamie TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://turpin-net.turpin-bg.local/Reportserver. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <HTML dir="ltr"> <HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; c

Passing parameters from ASP.Net web page to SSRS report

I have a web page that displays some data.  The user first selects a date range on the web page and then can edit some data.  When they click a submit button, I want to run a report.  But I would like to pass the start date and end date values that the user already entered on the web page to the report.  Is this possible?  Can I use the value of a session variable in the report? Bob

Problems passing parameters to SSRS report from ASP.Net web page

I have a web page that displays some data.   When they click a submit button, I want to run a report.  But I would like to pass the start year/month and end year/month values that the user already entered on the web page to the report.  Here is what my url looks like when the report is displayed: http://xyzserver/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fDevicesAllNew&rs:Command=Render&StartYYMM=201007&EndYYMM=201008 But my report displays the 2 textboxes for my StartYYMM and EndYYMM parameters as empty.  What am I doing wrong?  I did a google search and I saw something about using ReportServer instead of ReportManager.  I notice at the top of the browser when I run my report, it reads "Report Manager - Windows Internet Explorer".  Is this correct? Bob     Bob

Problem with Report parameter inside SSRS Report Viewer webpart with deployment from one server to a

Hi all,I've got this problem.me and my team have developed a lot of reports by using a SSRS configured in Sharepoint Integration Mode.For accessing these report we are using the Sql Server 2008 Report Viewer Webpart.One of its parameter is the Report ur that is an absolute url so the problem is when I move our solution from server1 to server2 I have to re-editing all pages where I've added the Report Viewer webpart for updating the report url with the new servername otherwise it's impossible to view the report.Is there any official or unofficial way to solve this problem ?many thanks

Server 2008 R2 64 bit, SSRS 2008 64 bit with Report Builder 3.0 issues with Oracle OLE Driver

Folks, ran out of idea on this issues. Setup as shown at the Title. I can connect via VS 2010  but report builder cannot run properly when setup with connection string. I use a 32 bit Oracle Driver and VS 2010 works well with it, however, Report Builder on SSRS report a bad image issues while attempting to use the same driver. What have been tried: 1-Already attempted to try to download Oracle ODP drivers 64 bit, but current driver 11g and minor version above 11g does not install, installation failed. So far all chats indicated that Server 2008 R2 does not have a Oracle 64 bit driver provided y Oracle. Any help is appreciated ....    

what kind of a report to be created in SSRS when the requirement is to show the Summary and Details

I have some reports to be developed where I need to show the Summary and the details of Students/Particular Product, Please advice what kind of Report format/ drill down or is there a way that on clicking on the summary it would show Details in a child report using SSRS 2008. it would be helpful if there are some tutorial links too thanks in advance for response.

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Report Builder 3.0 Compatibility with SSRS and Sql Server 2008 (not R2)

I've built reports in Report Builder 3.0 (which I love!). I tried to deploy the reports to an instance of SSRS installed with SQL Server 2008 (not R2). I can't deploy the reports - it appears SSRS is not forward compatible with Report Builder 3.0 reports. Would SQL Server 2008 SP1 help? Is there anything I can do to use Report Builder 3.0 with SSRS 2008?

Unfortunately, I cannot install SQL Server 2008 R2 in the production environment (yet).

SSRS Subscriptions in Report Server



Plz help in Report Server Report Subscriptions- Email/windows file share.

I am getting error

"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)" 

i tried to change credentials in report Datasource page but am getting Error on Page.

Kindly help me guys.

Thanks in Advance,



Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Adding parameters via URL to a SSRS report stored in Sharpeoint 2007

I am trying to pass parameter to a SSRS Report via URL stored in Sharepoint 2007 (integrated mode) but that doesn't seems to work. The report opens without the parameters taken into account. Any sggestions on how to pass parameters to SSRSreport on sharpeoint?..Thanks for your help...

How do I call an SSRS Report from a stored procedure, and pass parameters?


Hi all,

I have a Report, that I want to run ad-hoc from a Stored Procedure. 

I want to render this report to PDF format, and save it to a drive.

The difference between this post and most threads I've seen is I don't want to run a stored proc within the report and send parameters to the stored proc.

I DO want to call a report FROM the stored proc, and send parameters TO the report.

How can I do this?

Many thanks,


Separate Date and Time report parameters in SSRS 2005



Is it possible to declare separate report parameters in SSRS 2005 as Date and Time?

I want the user to be able to enter a date and a time.

When I declare the parameters in my stored procedure as datetime, in SSRS the parameter just shows as a Date only.


Generating SSRS report by taking data both from sql server and web service.



In my report, i need join data from both sql server and web service and display that on ssrs report.

is this possible in ssrs ?


SSRS Report Sorting issue in Dashboard created usign Performance point services in sharepoint 2010


I have created a report in SSRS and this report is integrated within a dashboard created using performance point services in sharepoint 2010.

The report is a simple tabular report with 5 coulmns and interactive sorting is enabled on each of them.

Sorting works when the report is viewed separately but gives "Report Server Error" when I try to sort (on any column) inside the dashboard.

I have user IP instead of host name in the report server url.

Please help.



SSRS 2008 Report Manager only accessible within the server, cannot open on a different PC


How should I configure my SQL 2008 Reporting Services so that the Report Manager can be accessed outside the server.  That is, from a different machine within the same network?  Whenever I try to access the Report Manager from another machine, a prompt will appear requesting for username/password several times before a blank page is shown.

Reporting Services Configuration Details:
Service Account: Local System
Execution Account: Tried using my own login details within the domain and tried without it

Please let me know if you need any other details.  I am running out of ideas on what I can possibly do, thanks!


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend