Small and medium business | Business Central, N...

How to find the tables and columns for an existing Report Request page in Business Central

(3) Share

Report

Posted on by PN-22101425-0

Hi All,

I have a requirement to pull or find out the tables and columns used for a specific report request page in our BC sandbox environment. Actually it is a custom report i tried to find it in Report Layout Selection, Report Layout, Custom Report Layouts no where i found this report.

Even i pointed the vs code to cloud sandbox environment and downloaded the symbols as suggested in internet. But still am unable to see that report neither in VS code editor nor in BC no where am seeing the tables and fields for the report (Sales and Service Extract)

Can anyone guide me is there any way to pull the tables and columns used for custom report which is report request page from BC, please suggest if am missing anything here and am giving the launch.json code this is how am pointing to sandbox environment.

{
            "name": "Microsoft cloud sandbox",
            "request": "launch",
            "type": "al",
            "environmentType": "Sandbox",
            "environmentName": "sandbox",
            "tenant": "",
            "startupObjectId": 22,
            "startupObjectType": "Report",
            "breakOnError": "All",
            "launchBrowser": true,
            "enableLongRunningSqlStatements": true,
            "enableSqlInformationDebugger": true
        }

Thanks in advance

Pavan kumar

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

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

Like (0)

Report

Hi, This custom report should belong to a third-party extension. You need to add the dependencies property in the app.json file and re-download the symbol file to see it.

For example,

PS: In this wave, there is a convenient function, I hope it can also give you some tips.

Business Central 2025 wave 1 (BC26): New VS Code actions from the Web Client (Generate launch configurations and Get selected as dependencies on the Extension Management)

https://yzhums.com/62106/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,603 Super User 2025 Season 2 on at

Like (1)

Report

1. Go to extension management page. Check third party extensions.

2. Add those details in dependencies of app.json page.

3. Download Symbol.

Please check this: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-work-workspace-projects-references

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,603 Super User 2025 Season 2 on at

Like (1)

Report

Use Page Inspection:
Open Business Central and navigate to the Report Request Page.
Press Ctrl + Alt + F1 to open Page Inspection.
Look at the Table Name under the "Page" section—it may show the main table linked to the request page.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,236 Most Valuable Professional on at

Like (1)

Report

Hi

If you use an app like AL Prism, you can access this information visually and quickly.

Best

GR

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (0)

Report

If you have access the app file in which the custom report is included, just select the app file and it will show that object and you can open the AL file and check what table it is referencing, the other way is to check in third party tool Prism.

When you select the app file, select Tree view on the right and it should show you something like this

Other way is to use Page Inspection to check main table, but that doesn't give you all the tables and column information.

Was this reply helpful? Yes No
PN-22101425-0 34 on at

Like (1)

Report

@gdrenteria

As you mentioned, AL Prism is an extension in the VS Code editor. My requirement is for custom reports. I want to find or see the tables, columns, joins, business logic, and any filters applied. Is it possible to view all this kind of information? Is there any place I can find all this info? Please suggest if there is any way.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,603 Super User 2025 Season 2 on at

Like (1)

Report

Hi @PN-22101425-0

Hope you have checked below steps which provided.

Adding one mor details: Add dependencies and After downloading symbol. Download AL object designer extension in visual code and select report. here you can see the report list...Open report and there you can see the table details.

Was this reply helpful? Yes No
Vahid Ghafarpour 12,168 Super User 2025 Season 2 on at

Like (1)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No