Charts in Word Reports

(1) Share

Report

Posted on by CU30070844-0

Hi,

I need to create Charts based on Content Control in Word reports layout. The word report is based on BC XML Schema on cloud implementation.

I tried until now to create chart based on content control repeater but this require VBA code in Word. The biggest problem is that BC reports are not executing VBA code or is blocked.

Is that possible ?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

that's right, cloud-based environments have restrictions on executing VBA code, the same as ActiveX Controls, for security reasons and generating charts in Word reports based on Content Controls can be challenging.

You can try to develop a Word report in BC and handle the calculations from the VBA code in the AL code. That's the way you can bypass restrictions on VBA code.

You could try to design a chart in RDLC layout in BC and then you could try to export that RDLC in a Word document.
Word document is not the best option for displaying charts, but for these purposes, you can use Power BI as well as Excel and the development process will be much easier.

Greetings

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, Word layout has many limitations, such as the followings.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-howto-report-layout?wt.mc_id=DX-MVP-5004336#sub-totals--running-totals

However, in the next version, Microsoft will enhance the Word layout, and hopefully your problem will be solved by then.

https://learn.microsoft.com/en-us/dynamics365/release-plan/2024wave2/smb/dynamics365-business-central/use-improved-features-report-documents?wt.mc_id=DX-MVP-5004336

Hope this info helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No