Finance | Project Operations, Human Resources, ...

Run multiple SSRS designs in single click

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi Everyone,

Though below issue has been discussed many times before, I haven't found any verified solution on it.

Please help if anyone has solution for below requirement,

I want to call 4 designs depending on the 4 different contract parameters which are Yes/No type.

Lets consider these 4 parameters as parmA,parmB, parmC, parmD having values of Yes/No type.

And report designs names are Design A, Design B, Design C, Design D.

I want to link parameters and designs as below,

parmA - Design A

parmB - Design B

parmC - Design C

parmD - Design D

If these parameters values have been set to Yes then respective designs will run in report viewer. So in one click user may want to see/download 1, 2, 3 or 4 designs.

I referred CustAgingReportController as mentioned on one of the blog. (Refer Screenshot) But in CustAgingReportController only one design run at a time. So modifying preRunModifyContract didn't work for me.

Can anybody suggest me the best solution for above requirement.

Thank you in advance.

All responses (2)

Answers (0)

Suggested answer

Pedro Tornich 955 on at

Like (0)

Report

RE: Run multiple SSRS designs in single click

For this particular case, I would create a separated class, which could be a RunBase class to leverage the dialog framework.

In this new class I would have a dialog with the checkboxes you mentioned and also with all the information required to run the report (including query, if needed).

Then on the run() method of this class, based on the dialog parameters, I would call each specific report separated, one after the other.
Crispin John Augustine 37,081 on at

Like (0)

Report

RE: Run multiple SSRS designs in single click

preRunModifyContract is too late.

Your code needs to go in controller::main(), before call to prompt() and startOperation()