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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SSRS report direct fro...
Finance | Project Operations, Human Resources, ...
Suggested Answer

SSRS report direct from SQL

(0) ShareShare
ReportReport
Posted on by everand 65

What do you think about creating / customizing reports using SSRS with direct queries to SQL database, eg. CustAgingReport. Is this (sometimes) practiced? I’m asking because I’ve created something like this to check performance (using specific parameters value) and results are very efficient – report is ready dozens times faster than in AX

I have the same question (0)
  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,671 Moderator on at

    Hi everand,

    Lot of customers have tapped into 2012 database and create some reports to gain performance. However something like custAgingReport will have lot of logic build into X++ and will be difficult to create such a report.

    Do know that if report is not build properly can choke up AX. Also when you move to D365, you will no longer have access to SQL so you have to replan your strategy.

  • Martin Dráb Profile Picture
    Martin Dráb 237,801 Most Valuable Professional on at

    Don't forget that you would lose many things that the application handles for you - getting label from fields for the appropriate language (user's, customer's...), working with meaningful enum values instead of mere numbers, automatically applying relations in queries, dealing with partitions and data areas, dealing with table inheritance and date-effective data, applying security, utilizing print management and so on and so on. And you wouldn't be able (easily) reuse any business logic defined in AX.

  • everand Profile Picture
    everand 65 on at

    Hi,

    Thanks for reply

    Satish:

    Definitely rewriting logic of "CustAgingReport" is not a pice of cake. I don't afraid of choking up AX by external queries - AX chokes up sometimes himself

    But seriuosly - direct query to SQL is not so rarely?

    Martin:

    My enviroment is simple - single language (given), single partition, single company (till now). Table inheritance (getting data from those tables) is known, enums label also (I have dedicated table with all enums data in AX), UTC datatime conversion to local time zone and so on. Things as security are of course unavailable

    Especially I wondering about bussines logic: risk of mistakes during reconstruction (ommiting some parameter, which may have impact in the future) or changes of logic eg. AX / processes customization... But performance gain is so huge…

    Or maybe rewriting X++ logic to be more, let say, specific / custom without flexibility... It's possible to improve it while we are talking about performance?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans