Call query based SSRS report one by one for selected records

(0) Share

Report

Posted on by Reliable

2,015

Hi Techies,

We are looking for a quick/urgent solution on one issue we are facing in work report.

Navigation to open a report ->All work->Work tab(Action pane)->Work report

This is a query based report and we have customized it. In case of multiple records selected- report is opening once and showing each record report one after other in single document. Body section is grouped.

Challenge we are facing here is with footer section. This is not added in body grouping so footer data is not in sync with body.

We're thinking to call this report from class for each record one by one, can anyone share any links/ code if done already like this please, we are looking more into it.

Or, is there any alternate way to get footer details in sync with body in single report. Please advise. Please let me know if I can share more details.

Thanks in advance.

Regards,

Sangram

Categories:

Development / Customization / SDK

All responses (1)

Answers (0)

Suggested answer

Reliable 2,015 on at

Like (0)

Report

RE: Call query based SSRS report one by one for selected records

So this is achieved with below set of customization-

Created a new class, opened a new dialogue(custom form) with multiple selected records and print settings from this class.

Given an option to select print setting on this dialogue.

Using these selected records and print setting, called report controller class(new) for each work order.

Also a new controller class is written to remove the ranges and add only selected in setRanges() method. Because standard controller class has logic inside this method to filter all records that are selected, so even when you are calling a report for single work via code it takes all selected records.

So cleared the work id range in separate controller class and added single work order for which a report is called for.

Hide the original report dialogue.

Now the reports are opening one document after another in cascading manner, which resolves the footer issue.

Thank you.