Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

SSRS report downloads as pdf automatically

(1) ShareShare
ReportReport
Posted on by 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,295 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

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! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans