We are all learning new things about RDLC report design and we know that still there are lot of things to learn about, here are the things I’m sharing which I learned.       1.  How to make page Header and Footer as dynamic.       2.  How to print page Footer on last page only.       3.  How to remove empty/blank rows in grouping.       4.  How to print TransHeader and TransFooter in RDLC re...

 In this post we will move to next step, and there we will go through two more data item grouping.For example: Here we will list Customer Ledger entries by Customer, then Customers by Salespersons. So we will get all customers for each salesperson and ledger entries for each customer that is done by using Salesperson, Customer, and Customer Ledger Entries data items.In my previous blog I briefly explained how to add a parent and child group and how it has displayed list of customers by sale...

You may want to add custom code to the RDLC report to do more actions than what's already provided with the report functions. So it gives you a base for extending your report functionalities which can’t programmed in NAV report design environment. You may want to add custom code to implement simple string manipulation task or sophisticated data access manipulation. So you can add custom functions to RDLC report and add references to functions in report controls. When the report is comp...

What is RDLC Report?The Report Definition Language (RDL) Data is a report component that is used by Microsoft Dynamics NAV to display the report in the Role Tailored client. Microsoft Visual Studio Report Designer is an external designer that is used to design the visual element (the RDL data) of a report. It is accessed from the Report Dataset Designer.With the help of RDLC reports we can easily export the report result into Excel, PDF and Word formats. We can have interactive sorting, add link...