Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

SSRS report Split based on customer selection

Posted on by 4
Hi Team,
 
Like how standard SSRS report /Customer account statement / report is working (Based on number of customers selected on dailogbox, those many number of reports will generate per customer).
 
same requirement I have. want to generate separate reports for customer wise.
 
Kindly share your thoughts on this.
 
Thank you.
  • Verified answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 9,553 Super User 2024 Season 2 on at
    SSRS report Split based on customer selection
     
    My idea is to create a batch job to generate individual reports and save them in a directory specified in the parameters.
    i.e. call up the standard report for each customer and save it as a PDF file.
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • CU28081815-0 Profile Picture
    CU28081815-0 4 on at
    SSRS report Split based on customer selection

    thanks for your reply - Mohamed Amine Mahmoudi,
     
    Basically my requirement is, if I select 3 customers in report dialog i should get 3 separate reports for each customer.
  • Verified answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 9,553 Super User 2024 Season 2 on at
    SSRS report Split based on customer selection
    Hi,
     
    I think you can develop a batch job to generate the reports as pdf and put them in specific folder.
     
    Best regards,
    Mohamed Amine MAHMOUDI

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans