Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SSRS reports - choose ...
Finance | Project Operations, Human Resources, ...
Answered

SSRS reports - choose to run in batch

(1) ShareShare
ReportReport
Posted on by Mahesh.0507 32
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 !
  • Verified answer
    Mahesh.0507 Profile Picture
    Mahesh.0507 32 on at
    SSRS reports - choose to run in batch
    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 !
  • Martin Dráb Profile Picture
    Martin Dráb 230,379 Most Valuable Professional on at
    SSRS reports - choose to run in batch
    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.
  • Mahesh.0507 Profile Picture
    Mahesh.0507 32 on at
    SSRS reports - choose to run in batch
    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 !
  • Martin Dráb Profile Picture
    Martin Dráb 230,379 Most Valuable Professional on at
    SSRS reports - choose to run in batch
    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?
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 10,262 Super User 2024 Season 2 on at
    SSRS reports - choose to run in batch
    Hi,
     
    there is a standard feature to run the report in the background.
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Mahesh.0507 Profile Picture
    Mahesh.0507 32 on at
    SSRS reports - choose to run in batch
    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.
  • Martin Dráb Profile Picture
    Martin Dráb 230,379 Most Valuable Professional on at
    SSRS reports - choose to run in batch
    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,661 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans