open report in popup window with parameter

david berlinger 96 Reputation points
2020-09-24T07:05:02.54+00:00

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?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,798 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,586 Reputation points
    2020-09-24T09:08:31.703+00:00

    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.

    0 comments
  2. david berlinger 1 Reputation point
    2020-09-24T11:47:06.75+00:00

    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

  3. Karel Hrubeš 0 Reputation points
    2024-04-17T16:57:22.4766667+00:00

    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.

    0 comments