open report in popup window with parameter

Question

I have set the action to:
="javascript:void(window.open(' http://prodsql02/reports/report/%D7%93%D7%95%D7%97%D7%95%D7%AA/%D7%A4%D7%A2%D7%99%D7%9C%D7%95%D7%AA/subreports/1_field_popup

&param1=" & Fields!conclusions.value & " & "','_blank','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=730'))"

but when I click on the field nothing opens. what am I doing wrong?

Answer 1

Hello to everybody,
although it's been a long time since you discussed this issue, but for you and for potential users in the future - the following link structure works for me:

="javascript:void(window.open(' http://reporting.domain.local/reportserver/Pages/ReportViewer.aspx?%2fMainFolder%2fSubfolder%2fSubReportName&rs:Command=Render&TableNo=123&FieldNo=99&PrimaryKeyField2Value=" & Fields!ProdOrderNo.Value & "&PrimaryKeyField3Value=0&rc:Parameters=false&rc:Toolbar=false','_blank','resizeable=1,top=200,left=200,width=1600,height=600'))"

I use this address structure to open a detailed sub-report in a new small window when clicking on a value in the table in the main report. Most of the parameters are hardcoded, one is transferred from the table row value in the main report. You can also transfer any other parameters.

Where
http://reporting.domain.local/reportserver/Pages/ReportViewer.aspx?%2fMainFolder%2fSubfolder%2fSubReportName - is report path incl. folder structure

TableNo, FieldNo, PrimaryKeyField3Value - Parameters, hardcoded into the URL address
PrimaryKeyField2Value - Parameter transferred from main report

Happy reporting.

Answer 2

Hi @david berlinger

Please try like this:

="javascript:void(window.open(' http://prodsql02/reports/report/%D7%93%D7%95%D7%97%D7%95%D7%AA/%D7%A4%D7%A2%D7%99%D7%9C%D7%95%D7%AA/subreports/1_field_popup

&param1=" & Fields!conclusions.value & " ','_blank','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=730'))"

By the way, you may need to deploy the report to the server for test, it might not work in preview.

Regards,

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

at least now I get a popup, but it fails with HTTP 400 Bad Request - web page cannot be found.
I rechecked the link by pasting it directly in the browser and except for the missing parameter it worked.
any idea here to go from here?

PS what did you change?

thanx meanwhile