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();

}

All responses (3)

Answers (1)

Sort by

Suggested answer

GirishS 27,845 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.
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.
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);