I am so close to getting this to work for me -- but the child report won't acknowledge the parameter and insists on prompting me.  Any ideas?   thanks a million for posting it---it's a much better way of drilling through....

I was wondering if you can help me out on this issue.  I was able to pass a report parameter  to the url and get the new browser window to open correctly, but when I pass a field to url I am unable to capture that specific value to pass to the subreport. 

 ="BLOCKED SCRIPTvoid(window.open('" & Parameters!ServerAddress.Value & "?" & Parameters!ReportPath.Value & "&rs:Command=Render&parameter1=" & Parameters!parameter1.Value & "&Field1=" & Fields!Field1.Value & "','_blank'))"

 I was also successful in passing the value from the first value in the dataset and the report opened a new window and rendered correctly

For example using: "First(Fields!Field1.Value, "DataSet1")"  in place of the highlight string above.  The problem is that I have a list of values returned in the dataset and I want to pass the specific Field1 value that the user selects for the subreport. 

Do you know why I am unable to pass the specific field value?

Thanks,

Sandi

I wonder if you can help me with how to handle special characters in a parameter value? 

="javascript:void(window.open('http://eagnmnsg4cd/ReportServer/Pages/ReportViewer.aspx?%2fZZ+-+Development%2fHardware+Network+Information+for+DistrictComputer&rs:Command=Render&District="+Fields!altdistrict.Value+"&Name="+Fields!name.Value+"'))"

The following works except if District name has a special character in it such as

 QA_ITE&A      Is there anyway I can pass the district value so that the & will not be interpreted as an & command operator..?

Anyway I can Pass Parameters!DistrictName.Value through encodeURIComponent.    ?   So far can't find the correct way to do this?

Great tip Rob,

It works okay on my test server.

However in the live environment I have got two servers: 1 sql server (sqlsrv) with rs on it and 1 iis server (applsrv).

Running the report on applsrv server via report manager works okay. But running the same report on applsrv as a link in a web based program (http://xx-sqlsrv/Reportserver$sql2005?/partoer/medewerkersreport&rs:Command=Render) the drill down url comes up with javascript:void(window.open('http://applsrv/synergy/docs/EPRequest.asp?Action=1&ID=%7BF3FD5DC4-8DA2-44B9-8D5F-6AB54A47C202%7D','_blank')) in stead of 'http://applsrv/synergy/docs/EPRe....

Do I have to install RS on applsrv as well or is there an easy solution?

Thanks

 Wim

Hi Reda, its a great article.

but i am stuck with one issue, while passing dynamic variable in URL my syntax is not working for some reason. although i am following exactly the way you have mentioned, but when i try to pass the field.value, the hyperlink disappears at all. it never gives me an error, instead it stops allow me to click on on the text box, and the text box become a normal text box without any link.

this is my syntax:

=

"javascript:void(window.open(http://ss-jhq-sspmo-2/ReportServer/Pages/ReportViewer.aspx?%2fPMO+Dashboard%2fBA_SSRS_Prjt_Level_MilestonePerProject&rs:Command=Render&Project_UID="=Fields!ProjectUID.Value+"'))"

please help i have already wasted quite a lot of time to resolve this.

Hi Khurram,

It looks like you need to replace the = sign with a + sign just before the word "Fields" toward the end. Like this:

"javascript:void(window.open(http://ss-jhq-sspmo-2/ReportServer/Pages/ReportViewer.aspx?%2fPMO+Dashboard%2fBA_SSRS_Prjt_Level_MilestonePerProject&rs:Command=Render&Project_UID="+Fields!ProjectUID.Value+"'))"

Check my syntax in the article carefully. 

ROb

This works great for us, but I have a question.  Is there a way to control where the window pops up?  I have a main report, that has a drill through report that has a drill through report, etc. down to 4 levels of drill through.  Each report opens in a new window (which is exactly what I want), however, I would like to have each cascade down from the main report when the link is selected.  Right now it would appear the the first drill through cascades, but then when I click the link on that report, that drill through report seems to open at the top left of the monitor instead of cascading down.  I have been searching for a solution, but have been unsuccessful.

Thank you

Hello, Great article but I have problems using Javascript. I have the complete URL as a Field value and I am trying to use that value in Go to URL property of a textbox from VS2008. Without the javascript it works fine but when provided within the javascript it fails to do anything. Here's my expression

="javascript:void(window.open('"+Fields!SprintURL.Value+"'))"

Not sure where I am going wrong with this. Any help would be greatly appreciated. Thanks

Hi,

Very Good Article.

I am using below code in Jump to URL,New window is opening but paramter is not getting passed to report.

I am getting error as parameter the 'cat' parameter is missing a value.

="javascript:void(window.open('http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fDemo+Project%2fReport22&rs:Command=Render&Cat="+Fields!SubCategoryName.Value+"'))"

OR

="javascript:void(window.open('http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fDemo+Project%2fReport22&rs:Command=Render&Cat=Bottom Brackets'))"

Please anyone can help me solve this issue.

Thanks and Regards,

Suresh S.