The below code for Passing parameters to SSRS using X++ code.
MenuFunction SSRS_MyReport;
Args Args;
str parmId ="";
;
// create reference to menu item “OverTime” which is in AOT
SSRS_MyReport = new MenuFunction(menuItemOutputStr(OverTime),MenuItemType::Output);
Args = new Args();
// Set parameters and parameter value
// I have 3 Parameters Nationality, EmplGroup, PeriodID
parmId = "Nationality=KSA&EmplGroup=HERD&PeriodID=2014_05";
// Assign parameters to report
Args.parm(parmId);
// Run the report
SSRS_MyReport.run(Args);
Notes:
1- Parameters name is case sensitive, so it should set name as predefined in report.
2- You can pass more than one parameters by add “&” between each parameter.
3- Not add space between parameters, it cause an error
No comments:
Post a Comment