Finance | Project Operations, Human Resources, ...

Answered

Passing params to SSRS report

(0) Share

Report

Posted on by bankk

6,611

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,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,611 on at

Like (0)

Report
Copy link

Link copied!

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,611 on at

Like (0)

Report
Copy link

Link copied!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates