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…
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…
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. Update 13.11.2020: The…
Sometimes work can be frustrating. I sometimes get frustrated when I find out that there seems to be no quick way of doing things. When you develop reports with Visual Studio Code and AL, you often want to add columns in the dataset for a data item. Sometimes you also want to add code in the triggers. I noticed that there is no shortcut to jump through the data items of an .al report file. My new extension AL Navigator…
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…