Word Custom Report Layout Formatting Issue

(0) Share

Report

Posted on by GazzR

141

Hello,

We are formatting a Word document and uploading it to the Custom Report Layout.

When we then apply some AL code on this document, to hide some data based on its condition, the formatting goes back to default and left aligns all the columns.

We then re-upload the template which corrects the formatting but loses the AL formatting.

In AL we are trying to hide the 0% on comment lines, and on Item lines where there is a 0%, show NETT instead.

Layout.png_2D00_640x480.png

Is there a solution for this?

I have the same question (0)

All responses (6)

Answers (1)

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

Are you previewing this from Custom Layout? Or direct from order page?

Thanks.

Was this reply helpful? Yes No
GazzR 141 on at

Like (0)

Report

From the Order Page

Was this reply helpful? Yes No
GazzR 141 on at

Like (0)

Report

Example of the difference in formatting after applying some formatting in AL.

Was this reply helpful? Yes No
Nitin Verma 21,708 Moderator on at

Like (0)

Report

Ok,

Please go to the Report Layout > Choose New layout and do as per below image.

After filling this Click on Replace Layout and choose your custom Layout, and then Make that as default layout and then run the report again from the Order page.

Hope it will resolve your issue.

Thanks.

Was this reply helpful? Yes No
GazzR 141 on at

Like (0)

Report

Thanks for the suggestion, but it hasn't made any difference.

Was this reply helpful? Yes No
Verified answer

sVerme 120 on at

Like (1)

Report

Hiding the value should be done in your AL-code. Check if the line is of type comment, and give it a value of ''.

for the alignment of the fields. This is a bug in Word, when you open the document it loses the alignment of fields in a table.
the value of the align gets removed from the XML for some reason.

You have to align them to the right again every time you open the document.

EDIT:
You could try adding a nonbreaking space before your XML item in your table.
Sometimes this helps to stop it from losing its alignment.

Was this reply helpful? Yes No