We usually print header and details section of a document on same page, what if we want to print on different pages? And how to do this?We can print header and details section of a document in different pages easily. To achieve this we have to place two different table controls, where one table control refers to header and another refers to details (lines), in a list control with a few properties change of these controls such as grouping, and page breaks, for example.In this blog I’m print...

We know that TransHeader and TransFooter section types were available in NAV 2009 version but there are no such section types in RDLC, even though wecan achieve these in RDLC report using report functions.We can print TransHeader and TransFooter in RDLC report using below functions:     1.  Using RunningValue function.     2.  Using ReportItems function.RunningValue Function: It uses a specified function to return a running aggregate of the specified expre...

I think I got late with this post, but I was unaware that most of us still don’t know how to change the NAV splash screen image.So let’s have a look on this.Steps:1.   How to change the Microsoft Dynamics NAV splash screen image as mentioned below screen shot.2.   After installation of NAV, usually all files are stored in the C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client. In the folder we choose Images folder as mentioned below screens hot.3.   S...

As we are all know there were two properties in NAV 2009 to print footer at bottom and on last page of report using PrintOnEveryPage and PlaceInBottom properties, but in RDLC report there are no such properties to achieve this.In RDLC report we can use page footer to print footer at bottom of a report, but it prints on every page, because of these below two properties:    1.  “Print on first page”: It prints page footer on every page except last page.    2. &...

Microsoft Dynamics NAV 2013 onwards there are no “Database Logins” supported. It means, no need to create all the users in SQL database, because the user authentication is not on SQL server level, but on NAV server level. When you create a new user, you provide different information depending on the credential type that you are using in current Microsoft Dynamics NAV Server instance. But all users of a Microsoft Dynamics NAV Server instance must be using the same credential type. You...

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...

Microsoft Dynamics CRM, is one of the prominent offerings from the Microsoft Dynamics family of ERP and CRM products. It is quite a long time now that MS CRM is in the marketplace. We came across a very odd request from one of our clients, asking us develop a tool which will generate documentation for the CRM workflows. The definition of the workflows in MS CRM is quite intuitive and easy to use. However, the way this data is stored in the CRM SQL database is not that straight forward. Our team ...

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...