Author: Tonya Bricco-Meske, Microsoft MVP

ValuesAllowed property in BC

Tonya Bricco-Meske, Microsoft MVPLeave a comment

I was working on a task where it was suggested to create an Option field so we had a shorter list of values available to users. When I got into the nitty gritty of development and was trying to set the value from an Enum I was getting a warning “An implicit conversion is being performed from a value of type ‘Enum xxx’ to a value of type ‘Option’. This conversion can lead to unexpected runtime issues. This warning will become an error in a future release.” I know there are ways to do conversions, but do I really need to use an option? Wouldn’t it be nice to just use the Enum?

I then stumbled across the ability to limit the (enum) values available to users. You can set this with the ValuesAllowed property on Tables or Pages. All you have to do is separate the values with a comma.

Read More »

Display Booleans on an RDLC Report

Tonya Bricco-Meske, Microsoft MVPLeave a comment

When developing for Business Central you have the option to create Word, Excel and RDL Report layouts. RDL stands for Report Definition Language, and is used by SQL Server Reporting Services (SSRS). I may be an outlier, but I find it relaxing to create custom RDL layouts. You have so much control over the rendering of your report, and I enjoy making very crisp, clean documents for my clients.

I had been working on a task that has over 120 custom fields used for a report, half of which were booleans. So how do you display those on a report?

Read More »