Damn it. I gave everything to write 10 tips together, but in the end there were only 9. Reports can drive you to despair in AL. While extensions have been available for tables and pages for a long time, we have to be patient with reports until the following screenshot of a report extension becomes reality. Update 09.06.2023: Finally I can make the 10 tips full. My 10th tip is a special one. Learn in this blogpost how to copy…
There are already some tutorials that are dedicated to the topic of translations. But I haven’t found one yet that is specifically for reports. That’s why I will take on this task today. For reports, we currently have the special case that we do not create “empty” objects, but often copy standard reports and customize them for customers. At least this is the case now, maybe this will change in 2021 with the announced report extensions. Unfortunately, the copied reports…
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…
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…