How to modify existing report in Business Central

(0) Share

Report

Posted on by How to Integrate Na...

Is there any way to development tools will be used by partners to modify standard Reports and build/modify custom Reports?

Categories:

Other

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

For that, you need to use Visual Studio Code (and AL) for creating the dataset and the RDLC layout, then you can customizw the layout with standard tools like Report Builder.

regarding standard reports: actually you cannot modify a standard report. If you need that, you need to do:

1) From your local sandbox, export the standard report as TXT

2) Convert the TXT to AL with Txt2AL tool. This will give you a .al file (dataset) and .rdlc file (layout).

3) Import the AL files in VS Code and modify them as per your needs

4) Load the report in D365BC

Was this reply helpful? Yes No
How to Integrate Na... 75 on at

Like (0)

Report

Thanks for the reply

can you just let me know that how to export the standard report as TXT because I got a report export format as a .rdl .

so let me know that what is the right way to export txt format.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

As said in point 1, you need to have a local deveopment sandbox for that. From here, you can open C/SIDE and export the report as TXT object.

Was this reply helpful? Yes No
How to Integrate Na... 75 on at

Like (0)

Report

i have a cloud hosted business central. so just let me know where i can find export the report as TXT object.

i have checked every where but i did not get the c/side export option.

can you please let me know step by step because i could not find.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

You cannot do that on a cloud sandbox. For this task, you need to have a local development sandbox (docker-based).

You can create that locally (by installing Docker and pulling microsoft/bcsandbox:latest) or use an Azure VM template (available here: aka.ms/bcdeveloperpreviewext)

After the container installation, you'll have a local D365BC environment with C/SIDE.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Simple customizations can be done with the extension Dynamic Reports

Was this reply helpful? Yes No
dkatson 2,263 on at

Like (0)

Report

Here is a nice blog from Steven, how to do that thinkaboutit.be/.../how-do-i-add-fields-to-a-report-in-business-central

Was this reply helpful? Yes No
SSG 5 on at

Like (0)

Report

Hi , I have docker container. But I am not able to get c/side. will you guys pls elaborate. any guide?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Always check if you can get away with just modifying the layout without extending it and apply it to Custom Report Selections.

Eg, changing field formatting, size etc. Adding new fields/data will require conversion and extension.

Was this reply helpful? Yes No