Is there any way to find and copy the query used by the built in reports?

(0) Share

Report

Posted on by Hugh_dc

Complete newbie here.

Starting out in IT and asked to try and modify some reports in BC.

Some stuff is simple, make a column wider, add an image.

The one I am stuck with is to add the posting date to the remittance advice report #400 (which is present in table 25)

There are so many tables and I have no idea where anything is, so trying to build a new query to make a new report from scratch will be nearly impossible.

So, I am hoping I could get the query used to make the dataset in the built-in report and simply add in the extra bit.

Suggestions?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

Well the source code for all standard reports are available so i guess the simplest and best approach is to actually look at the source code for that specific report in VS Code and learn from how it is built.

Was this reply helpful? Yes No
Hugh_dc 5 on at

Like (0)

Report

Awesome, regarding me being a newbie at this, where do I find the source code?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

There is lots of great information here about setting up VS Code against Business Central here:

docs.microsoft.com/.../devenv-get-started

Was this reply helpful? Yes No
Hugh_dc 5 on at

Like (0)

Report

Ok, got that running, now how do I get the reports out?

Was this reply helpful? Yes No
Hugh_dc 5 on at

Like (0)

Report

Let me change that, I can export a report, same as I have done before. But where do I find the query statement?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

You have to look at the data item table view property in the report.

And if there are several tables involved in the report you have to look at the way they are linked.

Typical example is line 173 and 174 of report 400.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,720 Super User 2025 Season 2 on at

Like (0)

Report

Hi, using page inspection feature you can easily find the information of the report opened.

https://docs.microsoft.com/en-us/dynamics365/business-central/across-inspect-page#work-with-page-inspection

For example,

If the fields you want to add are not in the standard report, you need to use ReportExtension to add them.

https://yzhums.com/10723/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Hugh_dc 5 on at

Like (0)

Report

This is helpful, the bit I am still stuck on is how to get the .ai file out of BC? It is BC 17, I can export a report, no problem. I can open that report in report builder or in visual code.

But everything I am seeing indicates that I need a .ai file to come along with that rdl file.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,720 Super User 2025 Season 2 on at

Like (1)

Report

Yes, ReportExtension is not yet supported in BC17, so you will also need the AL file.

There are a few simple ways here.

1. Found from On-Premises' installation.

For example,

Download the installation you needed, https://yzhums.com/24575/

Dynamics.365.BC.38230.W1.DVD 20.0\Applications\BaseApp\Source\Base Application.Source.zip

2. Find the source code in the Symbol File and copy it into your new AL file.

AZ AL Dev Tools/AL Code Outline extension is required.

3. Get to the source code of the default apps by Business Central Artifacts

https://www.powershellgallery.com/packages/BcContainerHelper/3.0.5

For example, Download-Artifacts -artifactUrl (Get-BCArtifactUrl) -includePlatform

4. Get the BC Source code from github.

https://github.com/StefanMaron/MSDyn365BC.Code.History

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Hugh_dc 5 on at

Like (1)

Report

This is a great answer, but I think it is beyond my current access and ability to implement.

We will move to the cloud soon, so I think we will wait until then.

Was this reply helpful? Yes No