Open report in new window (Javascript)

  • Hi,

    I am struggling to get this to work.
    It does open up a new window and attempts to run the report. However i don't think it is recognising the parameters.
    i.e. for FiscalYear I think it is passing through Fields!Fiscal_Year.Value rather than 2017.
    How should I reference all of the paramaters?

    ="void(window.open('http://Test/PLReportServer/Pages/ReportViewer.aspx?%2fDevelopment%2fAcme+Test+Reports%2fCashier+Refunds+Detail&FiscalYear=Fields!Fiscal_Year.Value&FiscalWeek=Fields!Fiscal_Week.Value&StoreID=Fields!Store_ID.Value&FiscalWeekCaption=Parameters!FiscalWeek.Label&StoreName=Fields!Store_Number_Branch_Full_Name.Value&ProductItemHierarchy=Parameters!ProductItemHierarchy.Label&DepartmentCode=Fields!Department_Code.Value&rc:Parameters=false&rs:Command=Render','_blank','width=800,height=600,left=250,top=50,scrollbars=1,resizable=1'))"

  • LittleKitten - Tuesday, August 29, 2017 5:15 AM

    Hi,

    I am struggling to get this to work.
    It does open up a new window and attempts to run the report. However i don't think it is recognising the parameters.
    i.e. for FiscalYear I think it is passing through Fields!Fiscal_Year.Value rather than 2017.
    How should I reference all of the paramaters?

    ="void(window.open('http://Test/PLReportServer/Pages/ReportViewer.aspx?%2fDevelopment%2fAcme+Test+Reports%2fCashier+Refunds+Detail&FiscalYear=Fields!Fiscal_Year.Value&FiscalWeek=Fields!Fiscal_Week.Value&StoreID=Fields!Store_ID.Value&FiscalWeekCaption=Parameters!FiscalWeek.Label&StoreName=Fields!Store_Number_Branch_Full_Name.Value&ProductItemHierarchy=Parameters!ProductItemHierarchy.Label&DepartmentCode=Fields!Department_Code.Value&rc:Parameters=false&rs:Command=Render','_blank','width=800,height=600,left=250,top=50,scrollbars=1,resizable=1'))"

    If you have setup a parameter for Fiscal year then you would reference it with:
    Parameters!ParameterName.Value

    Fields!Fieldname.Value is a value in the dataset.

    Sue

  • Hi,
    No, I pass through fiscal year in the dataset on purpose.
    Anyway, I did solve my issue
    The way to open up a new window in javascript with passing parameters is to do

    &FiscalYear = " & Fields!FiscalYear.Value  & " &FiscalWeek = " & Fields!FiscalWeek.Value & " and so on......
    Fields! can also be Parameters! or whatever you want to pass through to the new report

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply