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

Missing Permission Set

Missing Permission Set

A while ago, I came across an interesting error message that I had not seen before. The error message occurred when I created an empty table with the “ttable” snippet, claiming that my extension has a “missing permission set”. PerTenantExtensionCop Ruleset Apparently the PerTenantExtensionCop felt that we had stepped on his toes. Recently, the rule “PTE0004” forces all table definitions to have a matching permission set. If not, you will get an error. Here you can look up the rules…

Read More Read More

ID Assigning – Boost Your Productivity with AL/BC

ID Assigning – Boost Your Productivity with AL/BC

This post is part of the blog post series “Boost Your Productivity with AL and Business Central”. If you want to know more about what this series is about and why I created it, you can checkout this post. What This Post Is About Today I deliberately keep the post short. It is about the automatic assignment of an ID for .al objects. Some of you may already know this trick. For others, who do not know it yet, it…

Read More Read More

Boost Your Productivity with AL/BC – Breadcrumbs

Boost Your Productivity with AL/BC – Breadcrumbs

This post is part of the blog post series “Boost Your Productivity with AL and Business Central”. If you want to know more about what this series is about and why I created it, you can checkout this post. Today we will deal with the breadcrumbs in Visual Studio Code. What Are These Breadcrumbs? Breadcrumbs in Visual Studio allow us to navigate to our symbols or files in a fast way. Pictures speak more than a thousand words, so let’s…

Read More Read More