Custom Reports - Word Layout

(0) Share

Report

Posted on by Phil0867

162

Hi,

Is there a way of printing blanks rather than zeroes when customising reports using the Word layout. When we add information lines to sales orders, they fill qty and value with zeroes on the report which we then need to edit in Word to remove them. I'm not a developer so solution needs to be something that can be done in the word layout itself.

Regards

Phil

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

THE Italian on at

Like (1)

Report

There is no conditional formatting on word layouts.

There are 2 solutions for this

1. Use RDL Layout

2. Copy the existing report (clone) and in the dataset export in the dataset column a global variable text field. In the onaftergetrecord trigger (or wherever this is needed) create a function that assign a formatted value if this is not zero. If this is zero assign blank. Then use that value in the word layout.

Was this reply helpful? Yes No