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
Recently someone asked me if it is possible to programmatically access information from notes and add them on a page or report, so I thought, why not blog about it?
The first thing you should know is that notes are saved in the table: “Record Link“:
Source : Think about IT
This blog explains how to do grouping in the RDLC Report in Microsoft Dynamics Business Central or NAV. There are two steps involved: designing the data set and using the Report Builder to set the grouping.
Source : ArcherPoint
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
This blog provides step-by-step instructions on how to add filters in a report in Microsoft Dynamics 365 Business Central or Dynamics NAV. In the example provided, if you want to be able to view only blocked customers, adding a filter in a report will allow you to so.
Bron : ArcherPoint
A quick hack today. Got this question from someone who needed to be able to update a report and show users that something had changed. This is easy when you have access to a database and can add data to it but in this case that was not possible.
So I came up with a hacky (and great :P) way to do this. and wanted to share it in case it came handy in your box of tricks :).
Bron : Kasper on BI
In my blog post: How Do I : Create a Report, and layout, in VSCode? I explained the basics on how you can create a simple report for Business Central. In this post, and due to many requests, I will explain how you can get started to create a document report.
Bron : Think about IT