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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Is there any way to access the back end tables to make your own report in D365

(0) ShareShare
ReportReport
Posted on by 50

Dear Community,

I am new in D365 and i need your help. Is there a way to access the back end table where i can get access them and make my on reports, by using joints and merger.

Regards

Saad Iqbal

I have the same question (0)
  • Verified answer
    greengrimms Profile Picture
    1,400 on at
    RE: Is there any way to access the back end tables to make your own report in D365

    Hi Saad,

    There's two ways of doing that, as far as I know:

    First one would be to generate a data provider class, where you would create the query that will be used to populate your report:

    docs.microsoft.com/.../how-to-use-a-report-data-provider-class-in-a-report

    docs.microsoft.com/.../walkthrough-creating-a-report-bound-to-a-report-data-provider-class-x-business-logic

    Second one would be to use an AOT Query as a data source for the report:

    docs.microsoft.com/.../how-to-use-a-query-in-a-report

    Hope that answers your question.

    Regards

  • Saad Iqbal Profile Picture
    50 on at
    RE: Is there any way to access the back end tables to make your own report in D365

    Thanks for your support.

    IS there an easy way without coding.  just dig and drop table and joints just like in power BI.

  • Suggested answer
    greengrimms Profile Picture
    1,400 on at
    RE: Is there any way to access the back end tables to make your own report in D365

    Hi again,

    Sorry for the delay.

    Not that I know of, at least not Out-of-Box, but there are 3rd party solutions like Lasernet that can aid you with that:

    appsource.microsoft.com/.../formpipe.lasernet

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…

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

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans