Browsed by
Tag: Report Design

How To Add Long Text On Last Page Of Custom Word Report in Business Central

How To Add Long Text On Last Page Of Custom Word Report in Business Central

Today we look at how to print a long text on the last page of a custom Word Report. Some customers have the requirement to print terms and conditions on the last page of their sales quotes. This is exactly what we will do in this tutorial. Prerequisites I assume that you have a working environment for Business Central in a Visual Studio Code Project. My examples are done using a Docker Container with Business Central 16. Have a look…

Read More Read More

Zero Values in Word Reports

Zero Values in Word Reports

Today we look at how to hide zero values in Word Reports. Sometimes it makes sense not to print the value 0 in reports to protect the user from a flood of information. With the help of two small procedures we can achieve this behavior in Word Reports. If you are familiar with RDLC reports, you will know the function BlankZero. In this post, we are going to implement something similiar. BlankZero in RDLC Reports With RDLC Reports, we have…

Read More Read More

Resize Columns in Word Layouts

Resize Columns in Word Layouts

Have you ever bothered with column widths in Microsoft Word when you wanted to edit a Business Central Report? You resize columns and thereby automatically reduce the size of the following column. What a bummer! You don’t know what I mean? Let me show you. In the GIF down here, I’m enlarging the first column “ItemNo_Line_Lbl”. As a result, the second column “Description_Line_Lbl” is automatically reduced in size. But I do not want that at all. Instead, I just want…

Read More Read More

Add Fields to a Word Report in Business Central

Add Fields to a Word Report in Business Central

Well, how do I…where is the… alright, I will checkout a tutorial first. This was my reaction when someone asked me to add fields to a Word Report and I opened a Microsoft Word layout for the first time. What You Will Learn In this post you will learn how to add a field to an already existing standard report invoice in Visual Studio Code. My examples are done in a docker container with Business Central 15. I assume that…

Read More Read More

Use a Shortcut for XML Mapping Pane in Microsoft Word

Use a Shortcut for XML Mapping Pane in Microsoft Word

XML Mapping Pane. The first time I heard that phrase it sounded a bit shady to me. A really daunting name for a rather simple tool if you ask me. If you want to develop Microsoft Word layouts for Business Central, you better use a shortcut for the XML Mapping Pane because it is the main tool to access your dataset. Usually you have to navigate to your developer tab in Microsoft Word and then click on the button “XML…

Read More Read More