none
New syntax for window.open in SSRS 2012?

    Question

  • I just today upgraded to SQL Server 2012 from SQL Server 2008 R2.

    This syntax used to work in 2008 R2, which means I can drill thru from Report A to Report B, and also Report B opens in a new window, with parameters (including multi-valued parameters) passed in the URL:

    ="javascript:void(window.open('" + "http://www.ACME.COM/ReportServer/Pages/ReportViewer.aspx?http://www.ACME.COM/ & "Reports%20ACME%20DQ%20Detail/" &  Fields!FPDSErrorReportName.Value & "&pcComponent=" & Parameters!pcComponent.Value   & "&pcOffice="  & Join(Parameters!pcOffice.Value, "&pcOffice=")  + "','_blank','resizable=yes,scrollbars=yes,titlebar=yes'))"

    Now when I try to use this syntax I get:  404 NOT FOUND

    Any thoughts/comments appreciated.

    Note that I could get the report to pop up in a new window if I used relative addressing, but then with that I couldn't pass the parameters in the URL.


    Sunday, March 30, 2014 4:29 AM

Answers

All replies

  • I think server is not recognizing the webaddress sent. Can you check the value of expression used by typing inisde a textbox without the window.open part and copy and paste it onto a browser window to see if url is correct and you get the desired page. 

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Sunday, March 30, 2014 7:14 AM
  • Thanks Visakh, I'll give that another test.

    Here's what would help me though:  an actual URL (feel free to fake the server/domain name) that passes a parameter to an SSRS 2012 report.  I've done it for some time in SSRS 2008 R2, again the syntax appears to be different now for SSRS 2012.

    Thanks.

    Sunday, March 30, 2014 11:26 AM
  • This was the MSDN doc/thread I was looking for:  http://msdn.microsoft.com/en-us/library/ms155391.aspx

    The key, per the thread is:  Note the _vti_bin proxy syntax [for SQL Server Reporting Services 2012 in integrated mode].

    --Bob Harford
    Sunday, March 30, 2014 11:48 AM