Category: Reports

BC Excels at Reporting

Tonya Bricco-Meske, Microsoft MVP1 Comment
BC Excels at Reporting

I had the honor of presenting at DynamicsCon Live in Scottsdale, Arizona about one of the newer features in Business Central. You can now create and run Excel Report Layouts from Business Central (without any apps or custom code!)

Excel is the most popular spreadsheet system. At one point in time we all probably listed “proficient in Excel” on our resumes. Now is the time to dust up on all the functions and advanced processing capabilities within Excel to slice and dice your data from BC.

Excel Report Layouts were introduced in Business Central version 2022 Wave 1 (BC20).

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 »