Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SSRS report downloads ...
Finance | Project Operations, Human Resources, ...
Suggested answer

SSRS report downloads as pdf automatically

(1) ShareShare
ReportReport
Posted on by Anme1 31
 
HI everyone,
 
When I run an SSRS report, and it takes a long time to process, the report is automatically downloaded as a PDF.
 
how i can fix that?
 
 
  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,300 Most Valuable Professional on at
    SSRS report downloads as pdf automatically
    Hi,
     
    Is it happening with all the SSRS report or particular reports?
     
    PDF  an be defaulted as destination at the time of generating the SSRS report or in the form setup- print management setup- destination of reports.
     
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    SSRS report downloads as pdf automatically
    Hi,
    Here are some things you can consider:
    • If processing of all reports is slow, consider using a scale-out deployment, where multiple report server instances support a single report server database. For best results, use load balancing software to distribute requests evenly throughout your deployment.
    • If an individual report is processing slowly, adjust the report dataset query if the report must run on demand. Also consider using cacheable shared datasets, caching reports, or running reports as snapshots.
    • If all reports are slow to process in a particular format (for example, when rendering to PDF), consider file share delivery, adding more memory, or selecting a different format.
    • To understand how long it takes to process reports and other usage metrics, please view the report server execution log.Report Server ExecutionLog and the ExecutionLog3 View - SQL Server Reporting Services (SSRS) | Microsoft Learn
    • For more information on how to mitigate performance issues by optimizing memory management configuration settings, please view:Configure Available Memory for Report Server Applications - SQL Server Reporting Services (SSRS) | Microsoft Learn
    In addition, you can refer to this official document. If the SSRS report runs for too long, you can use batch processing to improve performance. For specific information, you can check this link:
    Help prevent long-running reports from timing out - Finance & Operations | Dynamics 365 | Microsoft Learn
    Best Regards,
    Hana

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 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