Finance | Project Operations, Human Resources, ...

Answered

Passing params to SSRS report

(0) Share

Report

Posted on by bankk

6,609

Hello:

I have code below attempting to call a modified WmsBillOfLading SSRS report. To make a long story short, there is print management override to get the default report, and I've added a button on the WMSBillOfLading form trying to call 'print'. My issue is, based on the selected BOL on WMSBillOfLading form, I'm not able to pass the value so in the report param dialog it shows the BOL Id selected. I'm having to manually enter the BOL Id in order to run the report.

[FormControlEventHandler(formControlStr(WMSBillOfLading, myBOLPrint), FormControlEventType::Clicked)]

public static void myBOLPrint_OnClicked(FormControl sender, FormControlEventArgs e)

{

SrsReportRunController controller = new SrsReportRunController();

SRSPrintDestinationSettings printSettings;

WMSBillOfLading lclwmsBOL;

controller.parmReportName(PrintMgmtDocType::construct(PrintMgmtDocumentType::SalesBOL).getDefaultReportFormat());

controller.parmLoadFromSysLastValue(false);

Args args;

args = sender.formRun().args();

lclwmsBOL = sender.formRun().dataSource().cursor();

args.record(WMSBillOfLading::findRecId(lclwmsBOL.RecId));

controller.parmArgs(args);

controller.parmShowDialog(true);

controller.startOperation();

}

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi,

You can override the prePromptModifyContract method on the controller class to set default value to the report parameter.

On this method you can get the caller record using this.parmArgs().record() to get the caller record and then set the value to the contract class parm methods.

Refer to the below blog.

https://msdynamicsxx2012.blogspot.com/2017/03/how-to-pass-default-value-to-parameter.html

Thanks,

Girish S.

Was this reply helpful? Yes No
bankk 6,609 on at

Like (0)

Report

Hi Girish,

The WMSBillOfLading report does not have a contract class which I can override. Per the code above, I do have the cursor to the WMSBillOfLading record but without a contract class and a parm method, is it possible to set the BOL value? Thank you.

Was this reply helpful? Yes No
Verified answer

bankk 6,609 on at

Like (0)

Report

Hi Girish,

I went a different route and modified the query sending in my BOL#. It appears to be working so far. Thank you for your help!

queryLocal = controller.getFirstQuery();

queryBuildDataSource = SysQuery::findOrCreateDataSource(queryLocal, tableNum(WMSBillOfLading));

queryBuildDataSource.clearRanges();

queryBuildRange = SysQuery::findOrCreateRange(queryBuildDataSource, fieldNum(WMSBillOfLading, BillOfLadingId));

queryBuildRange.value(lclwmsBOL.BillOfLadingId);

Was this reply helpful? Yes No

Join the conversation

Community site session details

Passing params to SSRS report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Passing params to SSRS report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates