Passing a parameter to an SSRS report from Controller

(0) Share

Report

Posted on by brianmaric

Hi folks, I need to run a batch job that passing the customer account to the SSRS report Dynamically...and this will write a PDF file per customer.

So I believe I need to call the controller class something like this:

But not sure how to pass the parameter to the report. The parameter is not in the contract class. Can't I just pass the parameter to the report by modifying the query range rather than adding the parameter to the contract class?

Thank you in advance...

SrsReportRunController controller = new SrsReportRunController();
SRSPrintDestinationSettings printSettings;

// set report name
controller.parmReportName(ssrsReportStr(AMKcustsevenDayOpen, Report));

controller.parmArgs().parm('custaccount?');

// get print settings from contract
printSettings = controller.parmReportContract().parmPrintSettings();

// set print medium
printSettings.printMediumType(SRSPrintMediumType::File);
printSettings.fileFormat(SRSReportFileFormat::PDF);
printSettings.overwriteFile(true);
printSettings.fileName(@"C:\Temp\Report.pdf");

// suppress the parameter dialog
controller.parmShowDialog(true);

// start operation
controller.startOperation();

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Suggested answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi brianmaric,

You need to get data contract and set parameter there, something like

AMKcustsevenDayOpenContract rdpContract = controller.parmReportContract().parmRdpContract() as AMKcustsevenDayOpenContract ;

rdpContract .parmCustAccount('blah-blah');

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report
Copy link

Link copied!

oh...so you just can't pass the parameter to the report query...

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

It's depends how it's done. Is it query based report ? Do you have data contract ?

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report
Copy link

Link copied!

It is a query based report and Ideally I don't want to add a parameter to the contract class...possible?

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

It is possible, look at LedgerJournalController.setRange() method and it's usage.

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report
Copy link

Link copied!

Thanks!!

...but how do you call it?

Was this reply helpful? Yes No
Verified answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Example is in LedgerJournalController.main(), however, you don't need to do a straight copy, it's just an example, change it according to your needs.

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report
Copy link

Link copied!

Thank You!!

...but is there any way to suppress the other required parameters? I tried running it and got an error message saying date parameters are required. I guess I could just create another design without the parameters but I wonder if there is a way around it.

Thanks again!

Was this reply helpful? Yes No
Suggested answer

Mohamed lotfi 255 on at

Like (0)

Report
Copy link

Link copied!

You can use the next code:-

SrsReportRunController controller = new SrsReportRunController();

SRSPrintDestinationSettings printSettings;

SrsReportDataContract contract;

YourReportContractClass rdpContractClass;

// set report name

controller.parmReportName(ssrsReportStr(AMKcustsevenDayOpen, Report));

//------ add this section-------//

contract = controller.parmReportContract();

rdpContractClass= contract.parmRdpContract() as YourReportcontractClass ;

rdpContractClass.parmAccountNum(CustTable.AccountNum);

//--------------//

// get print settings from contract

printSettings = controller.parmReportContract().parmPrintSettings();

// set print medium

printSettings.printMediumType(SRSPrintMediumType::File);

printSettings.fileFormat(SRSReportFileFormat::PDF);

printSettings.overwriteFile(true);

printSettings.fileName(@"C:\Temp\Report.pdf");

// suppress the parameter dialog

controller.parmShowDialog(true);

// start operation

controller.startOperation();

Was this reply helpful? Yes No