Display Booleans on an RDLC Report

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?

Change the font to Wingdings, and use an expression.

=iif(Fields!FieldName.Value, Chr(254), Chr(111)) If the boolean is true, you will get a checkmark in the box, otherwise you will get an empty box.

Display Booleans on RDLC Report

Now to rinse and repeat for the rest of the report!

#msdyn365bc #businesscentral #bcdevelopment #reporting

Leave a comment