SSRS reports - choose to run in batch

(0) Share

Report

Posted on by Mahesh.0507

Hi All !

I'm having a requirement with running SSRS reports. I need to execute the report depending on the Report parameter values, I want the report to run automatically either in the background[Run in Background] with batch processing enabled or without it.

Can anyone guide me on how to achieve this ?

Thanks !

I have the same question (0)

All responses (7)

Answers (1)

Martin Dráb 238,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you saying that you don't want to use the standard configuration on Run in the background fast tab and you want to duplicate the same setup as custom parameters of your report? If so, why?

Was this reply helpful? Yes No
Mahesh.0507 40 on at

Like (0)

Report
Copy link

Link copied!

Appreciate your helpMartin Dráb !

I'm looking to automate the process rather than manually adjusting it every time I run the report. So, that the report automatically runs either in the background with batch processing enabled or without it depending on the parameter values.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,779 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

there is a standard feature to run the report in the background.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Martin Dráb 238,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I still don't understand. You don't want to use standard parameters, because they need to be configured manually. So you'll create custom parameters, which - will be configured manually? What's the benefit of it?

Was this reply helpful? Yes No
Mahesh.0507 40 on at

Like (0)

Report
Copy link

Link copied!

Martin Dráb - Let me put it this way!

I have this input parameter 'legal entity' for the report. Now, depending on how many entities/company I select [Lookup with multiselect], I want the system to decide whether it should run in the background with batch processing enabled or not.

Hope that clears things up a bit! Thanks !

Was this reply helpful? Yes No
Martin Dráb 238,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can add such logic to report controller class. Note that it sounds like you want ReliableAsynchronous execution mode rather than a batch running on schedule.

Was this reply helpful? Yes No
Verified answer

Mahesh.0507 40 on at

Like (0)

Report
Copy link

Link copied!

I added the modified method to the dialog fields in UI Builder class. Upon modification, I was able to validate the parameter values & toggle the "Run in Batch" button using the following :

this.controller().batchInfo().fieldBatchExecuteValue(NoYes::NO);

Thanks !

Was this reply helpful? Yes No