August 29, 2017 at 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'))"
August 31, 2017 at 1:54 pm
LittleKitten - Tuesday, August 29, 2017 5:15 AMHi,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
September 1, 2017 at 7:26 am
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