Passing the paramter value dynamically in jump to URL
Hi All, I have created a default report and Report A. andfrom default report i need to jump to Report A. I passed then static value to report A and the report executed succesfully. URL created : "http://localhost/reportserver?/Dev/GDAS+Sandbox+Reports/R007.3+-+GDAS+Scorecard+Operational+Scorecard&rs:Command=Render&TimeMonthly=Parameters!TimeMonthly.Value&DeliveryOrg=[Delivery Org].[Org].%26[20]" Now i need to pass those value dynamically, so added a prompt to default report say time. but how could pass these dynamic value to the report. URL : http://localhost/reportserver?/Dev/GDAS+Sandbox+Reports/R007.3+-+GDAS+Scorecard+Operational+Scorecard&rs:Command=Render&DeliveryOrg=[Delivery Org].[Org].%26[21]&TimeMonthly= & Fields!ParameterValue.Value.ToString() The above URL fails. Can anybody help me on this. Thanks in advance Lalitha
November 13th, 2008 11:20am

Hi Lalitha, If you want to pass the field value of the default report to the parameter value of the Report A, you can use the Jump to report option of the action property. This can be done with the following instructions. Open the Action property dialog box. Select Jump to report option. Select the report name from the drop down list. Click Parameters to open the Parameters dialog box. Set the parameter name and value from drop down list, such as Parameter Name: TimeMonthlyParameter Name: Fields!field_name.value If there are any more questions, please let me know.Thanks.
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2008 11:02am

Hello, The Jump to report option opens the report in the same window, where asI need the report in the new window , so used the option jump to URL. CanI achieve this property with any other option? Thank You, Lalitha
November 18th, 2008 11:42am

Hi Lalitha, If you wanto to open the link report in a new window and pass the parameter value to it, try the following expression in Jump to URL. Code Snippet ="javascript:void window.open('http://localhost/reportserver?/Dev/GDAS+Sandbox+Reports/R007.3+-+GDAS+Scorecard+Operational+Scorecard&rs:Command=Render&TimeMonthly=Parameters!TimeMonthly.Value&DeliveryOrg=[Delivery Org].[Org].%26[20]','_blank')" If you have any more questions, please let me know. Thanks.
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2008 5:50am

Hi, I tried executing the report using the code given above. The report didnt throw any error but, when clicked on the hyperlinked, the report was not invoked. Please let know what can done !!!! Thanks Lalitha
November 19th, 2008 12:43pm

Hi, the link in the browser is ="http://localhost/reportserver?/Dev/GDAS+Sandbox+Reports/R007.3+-+GDAS+Scorecard+Operational+Scorecard&rs:Command=Render&DeliveryOrg=%5BDelivery%20Org%5D.%5BOrg%5D.%26%5B21%5D&TimeMonthly="+Parameters!TimeMonthly.Value As i told in the previous reply, in the link the parameter is passed to the browser. but the parameter values is as follow [Time].[Monthly].[Month].&[200809] and an error is thrown. an escape sequence %26need to insert before '&'. Please let me know how can achieve this. Thanks. Lalitha
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2008 1:55pm

Easiest way to check is to ensure the value returned by your Fields!ParameterValue.Value.ToString() actually encodes to a DateTime. Another way to do it is to change your parameter on the drill-through report to be a string and then do some conversion of the parameter value into the desired form inside the report. Usually, I do this kind of thing by outputting the drill through URL into a textbox in the report for debugging purposes and then I ensure the values can be passed to the child report by placing them on the URL.Remember that if the reports are being edited together in a single solution in BIDS, there is a Drill through action for reports where you can set the parameter values directly. This helps you not have to edit the URL directly.Hope that helps,-LukaszThis posting is provided "AS IS" with no warranties, and confers no rights.
December 16th, 2008 8:49pm

Hi Lalitha, I learned that you are using the MDX parameter to pass, so how about writing a custom code that may split those braces and the dots!!!!! actually i too had the same requirement and i was able to write a custom code and fared well :) .Avenash.M.G
Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2011 2:03am

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

Other recent topics Other recent topics