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)

Suggested answer

Mea_ 60,284 on at

Like (0)

Report

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

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

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

Like (0)

Report

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

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

Like (0)

Report

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

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report

Thanks!!

...but how do you call it?

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report

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

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

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