Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Is there any way to ac...
Finance forum
Answered

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

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

  • Suggested answer
    greengrimms Profile Picture
    greengrimms 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

  • Saad Iqbal Profile Picture
    Saad Iqbal 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.

  • Verified answer
    greengrimms Profile Picture
    greengrimms 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

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

News and Announcements

Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans