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

(0) Share

Report

Posted on by Saad Iqbal

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

All responses (3)

Answers (1)

Sort by

Verified answer

greengrimms 1,400 on at

Like (0)

Report
Copy link

Link copied!

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 50 on at

Like (0)

Report
Copy link

Link copied!

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 1,400 on at

Like (1)

Report
Copy link

Link copied!

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