Assign values to report parameter, from URL step by step.

Hi,

I have a asp.net web application. At the click of a button it is opening the reports, but the values of the parameters are not getting assigned to the reports . Parameters values are passed through URL.

In the URL we have all the required values. But what are the steps to assign these values to report parameter.

We are not using report viewer. Onclick of button we are calling a javascript and through this javascript we are directly opening report server.

we have been googling for 1 days but no luck, we have kept the default setting in report server after deploying the report.

Below is the screen shot of javascript code.  

Below is the screen shot of  report server URL with value.

In the report server URL what value was coming I have copied pasted the same in the notepad.

What is the step by step process that I need to follow so that the report server URL values gets directly assigned to the reports.

Waiting for some good help.

June 19th, 2015 11:05am

Hello,

You are opening the report via the "Report Manager" URL, here you can not pass parameter values. You have to use the SOAP URL instead, means "reportserver" instead of "reports" in the URL. See URL Access (SSRS) and follow up links

Free Windows Admin Tool Kit Click here and download it now
June 19th, 2015 11:30am

thanks Olaf ,  

I tryed by replacing "Reports" with the "Reportserver", but no success.

Can you help a little more what I am missing. and how can I achive this.

June 19th, 2015 1:11pm

Please read the link Olaf posted and write your URL according to the documentation there.  It's more than just changing "Reports" to "Reportserver".  Eg, from BOL

http://myrshost/reportserver?/Sales&rc:Parameters=Collapsed

Free Windows Admin Tool Kit Click here and download it now
June 19th, 2015 1:22pm

Please read the link Olaf posted and write your URL according to the documentation there.  It's more than just changing "Reports" to "Reportserver".  Eg, from BOL

http://myrshost/reportserver?/Sales&rc:Parameters=Collapsed

June 19th, 2015 1:37pm

Hi prince16in2002,

Just as Olaf said, the issue is caused by using the "normal" Report Manager URL for the WebRequest. From the document, we can know that the URL should look more like
http://myrshost/ReportServer?/AdventureWorks 2008R2/Employee_Sales_Summary_2008R2&ReportMonth=3&ReportYear=2008

So, we should browse to the report using the report server path instead report manager ("reports" is the report manager). Please refer to the following URL:
=https://server_name/ReportServer?/RevenueStorm_19June15/RevenuestormReport&OpportunityId=......

If there are any other questions, please feel free to ask.

Thanks,
Katherine Xiong

Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2015 12:34am

I tried with the recommended URL setting (i.e both with &rs: and &rc:) even changed the url 

(i;e   

http://server_IP/ReportServer/Pages/ReportViewer.aspx?/RevenueStorm_19June15/RevenuestormReport
&rs:Command=Render

&rc:OpportunityId=DA4C00A5-4304-E511-80ED-005056A66628
&rc:AnalysisId1=596f8d16-843a-4893-85b1-11f9186bf761
&rc:AnalysisId2=a72d129e-439f-4ca3-b9ab-104f996bb1c1
&rc:AnalysisId3=3b38abc5-13cb-4df1-91d0-29165b193610
&rc:AnalysisId4=1438405c-bfaa-4d82-934b-e63d9a6d1061
&rc:AnalysisId5=d4893765-a436-4aa0-b019-8cfae76be4c4
&rc:AnalysisId6=82f73cf4-bf30-42c8-bbeb-a16664e9886e

&rs:ClearSession=true

)

still I am not able to assign the values of report parameter from the URL.

Waiting for helpful reply.

June 25th, 2015 9:07am

Well, let me say this again:

Please read the link Olaf posted and write your URL according to the documentation there.  It's more than just changing "Reports" to "Reportserver".  Eg, from BOL

http://myrshost/reportserver?/Sales&rc:Parameters=Collapsed

David

Free Windows Admin Tool Kit Click here and download it now
June 25th, 2015 9:43am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics