How do I: Create a timeline in a report dataset in AL?

A question I got recently was, how can I visualize or create a dataset that can show/fetch information on a timeline? For example, I have a time-sheet and want to visualize the hours employees worked at certain projects, per day, week, month, year, and so on.

In this example I will create an order intake report. For the simple reason that for this report you can use the standard demo data in Business Central, and for time-sheets you first need to go threw a setup and then create the demo data.

Source : Think about IT
Read more…

Power BI Deployment Reports Tips for Business Central Users

In addition to integrating Power BI into Business Central, it could be useful to be able to use a fast access portal or receive scheduled reports from Power BI automatically without going through the complete Power BI (Pro and Premium) solution. All this is already existing and usable if I use Power BI Premium license or Pro license, or if I integrate MS-Flow, MS-Sharepoint Online etc. etc

Source : Roberto Stefanetti NAV & Business Central Blog
Read more…

Report.SaveAsPDF in Business Central (Workaround) – Download Report PDF in Business Central

As we know, Report.SaveAsPDF or Report.SaveAsExcel not supported in Business Central Cloud (SaaS) version. We have an alternate code for solution. We can save Report in Stream objects than after convert to file using Blob Export function.

Here is the sample code to download work order report in PDF file with Customize file Name.

Source : Nilesh Gajjar
Read more…

How To: Moon Power Make-Up – Working with Custom Report Layouts in Microsoft Dynamics Business Central or NAV

When we do Microsoft Dynamics Business Central or Dynamics NAV development, one of our goals is to minimize the work required during an upgrade. When it comes to report customizations, we can handle this by using a custom report layout instead of modifying an existing report. It’s easier to upgrade, and it’s not any harder than modifying the existing report layout. I’ll talk you through custom report layout limitations, how you can make a custom report layout, and why you would want one.

Source : ArcherPoint
Read more…