MSSQLTips

http://www.mssqltips.com/tip.asp?tip=1283

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