Views are used on List Pages to define different ways of organizing data. Instead of creating a new custom page to reorganize the data, you could create a View that will rearrange the columns. The great thing about creating a view via AL code is that it is available to all users.
The real benefits of Views:
Read More »
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 »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 »
You have created a new Report Layout that you want embedded within Business Central. Instead of uploading the layout file in each company as a Custom Layout, we now have the ability to “upload” the layout when publishing the app to a Business Central environment.
Read More »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 »
BC Development Notebook 