web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / best approach to creat...
Microsoft Dynamics AX (Archived)
Answered

best approach to create complex SSRS report

(0) ShareShare
ReportReport
Posted on by @rp@n 30

Dear All,

Can you please let me know what are the best approach to create complex SSRS report.

Means no performance issue, no timed out etc. Smoothly run report by end user.

Please give me more shed on this.

Thanks!

Arpan

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    [View:https://msdn.microsoft.com/en-us/library/dn251070.aspx:750:50]

    Series of performance articles on SSRS reports by Microsoft Perf Team:

    [View:https://blogs.msdn.microsoft.com/axperf/tag/ssrs/:750:50]

    [View:https://blogs.msdn.microsoft.com/axsupport/2013/09/18/microsoft-dynamics-ax-2012-reporting-tips-how-to-improve-performance/:750:50]

    Make sure you do not return full table buffers but only the fields you actually need. Sorting, grouping, counting and adding a lot of joins are generally all performance killers, keep it simple. Also make sure your selection criteria has covering indexes on the tables.

    Finally, no reports will run fast if you do not do regular SQL database maintenance and health checkups.

    https://www.daxrunbase.com/2016/05/11/ax-database-tuning-and-maintenance/

  • @rp@n Profile Picture
    @rp@n 30 on at

    Thank Vilomos,

    As said "Sorting, grouping, counting and adding a lot of joins are generally all performance killers,". Suppose as per my requirements i need this all (Sorting, Grouping, multiple joins) but how to avoid this all?

    please give me more shed on this.

    Thanks!

    Arpan

  • Verified answer
    Mahmoud Hakim Profile Picture
    Mahmoud Hakim 17,887 on at

    my suggestion in huge data and complex data sources In addition to Vilmos Kintera reply, try to decrease joins and links, create multiple reports instead of one report that includes everything

    ex. our customer needs one report for sales and collection with customer details and sales analysis and his database size above 500 GB, after design, this report performance is very bad.

    we divide this report to 3 reports (one for customer details with statistical data like one for collection, and other for sales analysis )

    this is a real case with us,

    so based on your case you will provide the best practice for this case  

  • @rp@n Profile Picture
    @rp@n 30 on at

    Thanks Hakim,

    for SSRS report how i will came to know how much size occupied in database?

    Please give me more shed on this.

    Thanks!

    Arpan Sen

  • Verified answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    He talked about raw data for the entire table. You could check size per DB or per table with the sp_spaceused stored procedure in SSMS.

    You are asking what you already have answer for. Follow the links I provided, they have plenty of explanation on what takes long and what to avoid/overcome with which techniques.

  • Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Please kindly mark the answers which you have found to be helpful with the checkbox next to each post, in order to resolve the thread and assist others.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans