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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy