Showing posts with label RTC Reports. Show all posts
Showing posts with label RTC Reports. Show all posts

Monday, September 5, 2016

Microsoft Dynamics NAV 2013 R2 & Later - Report Page Number Format x/y

Hi All,

We have already discussed this in NAV 2009 Reports about how to Set the Page Number in Format X/Y.

But with Microsoft Dynamics NAV 2013 R2 and Later its very simple to configure it. Till 2013 we used to have setGroupPageNo and other functions to reset the Page No.


Wednesday, July 20, 2016

Friday, December 18, 2015

RDLC Report - The tablix ‘Tablix1’ has a detail member with inner members. Detail members can only contain static inner members.

Hi All,

In This article we will discuss how to resolve an Issue that we face During Creation of a RDLC Report.

Applies To - NAV 2009 and Later (RDLC Reports)

Scenario -
You are creating Say a Document Report. There are multiple tables in Body. For Linking these tables you put all these tables inside a List.

When You want to save the Report, You get an Error Message  -
Error while validating RDL content:
The tablix ‘Tablix1’ has a detail member with inner members. Detail members can only contain static inner members.


Monday, August 3, 2015

NAV 2013 R2 - Export To Excel With Font & Color

Hi All,

This post is based on Requirement/ Query of one of my Blog Reader +shital bawage . All Thanks to Shital for the article.


In this article we will discuss how to achieve Export To Excel with Font, Color and Back Ground Color.

Please go through the article and let me know your views and queries as comment to the article.

If you are looking for same solution in Navision Classic Version refer the article.

There are some issues which are resolved in a Seprate Article, Please Refer Here For Updated Article for NAV 2013 R2.

Let's Begin.

Monday, July 27, 2015

NAV 2013 R2 - Multiple Sheets in Excel Using Excel Buffer.

Hi all,

In this article we will see the possibility of having Multiple Excel Sheets Using Excel Buffer Export.

The Article is based on request of Mr. Anand gupta, so all thanks to him for the query.

Most of us know how to export data using excel buffer, but it only contain a single sheet. Now let's consider a scenario where i want to export my customers, vendors and Items from navision in excel.

So its pretty obvious that i want then in different sheets.


Wednesday, July 1, 2015

NAV 2013 R2 - Import Excel File Using Excel Buffer.

Hi All,


This article is based on a friend request. The Requirement was to import the data in a table From an Excel File.

Most of us know this feature is there in standard objects of Microsoft Dynamics NAV from a long time.

If you are one of those who don't know about it please go through the article.


Monday, June 22, 2015

NAV 2013 & Later - Grouping In Export To Excel Report Without Layout.

HI All,

In This Article we will see how we can use Grouping (Group Header, Group Footer) Via Code in NAV 2013 R2 Reports.

This situation is faced during upgrade of a Report where we had put code for Some Task Say Export to Excel in Sections Like Group Header and Footer in 2009 or Previous Version.

In the Demo we will see a case of Export to Excel Report on Item Ledger Entry Table Having Grouped by Location Code and  Item Category Code.

1. As i Need Grouping on Location Code and Item Category Code in Item Ledger Entry Table i need to have a Key on Table 32 Item Ledger Entry as shown below.



Monday, May 25, 2015

NAV Report - How To Use Excel SUMIF Function?

Hi all,

I think most of us know SUMIF Function IN Excel, Those who don't know below is a sample.

Suppose i Export my Item Ledger Entries Data in Excel. Now i want to see the Total Quantity Sum where Entry Type Is Sales or Purchase.

There are two ways to achieve same -
1. I Filter the Data based on Entry Type and Sum up Quantity.

2. Or I Can Use SumIF Excel Function where i can put a condition.

Monday, April 20, 2015

NAV - RTC Report Reset Row No. / Serial No. on Group Change.

Hi all,

This post is based on query of one of my reader Peter Huba.

During Report Development we face queries like resetting the Row  No. when there is a change in Group.

What we exactly Try To Do ?

We tried to write C/AL code based on our group and try to set/reset a variable.
But in some cases that dosent help too as we have visibility condition in RDLC Rows which create issues.

What we Don't Do ?

Tuesday, November 18, 2014

RTC Report - Formatting Boolean Values as Check Mark and X Mark.

Hi All,

This post only show steps about how to Format Boolean Values in RTC Reports.

If you don't know this, then please go ahead.

I received a query to put a check mark or X mark for a Boolean field in Navision RTC Report.

Let's see how we can achieve it.

Wednesday, October 22, 2014

Navision - How to Format Dates for Cheque Reports?

Hi all,

This is nothing most of you would be interested in. This post only show steps about how to Format Cheque Date specific to Actual Cheque.

If you don't know this, then please go ahead.

The intended readers for this post are the Peoples who have recently joined and are still Learning NAV. Based on Request received via Contact Form..

Monday, May 5, 2014

How to Use an Embedded Picture in a RTC Report.

Hi all,

Let's see how to Display an Embedded Picture in a Report.

* The Steps Shown below are from NAV Version 2013 R2.

It was a query from one of my friend +shubhangi verma  about how to add Embedded Picture in Report.

I am using Standard report 405 Which can be downloaded from the link provided at the end of the Post.

There are certain steps that we need to follow while adding an Embedded Picture in a Report. Let's see them.

Friday, January 10, 2014

NAV 2013 & NAV 2013 R2 - Save Export to Excel

Hi all,

In Last post we had seen how to use export to Excel Reports in NAV 2013.

The Next question asked to me is with older version with some code we used to able to save the Report at a specified path instead of opening it. Is it possible with NAV 2013 and later?

So here it is, we can again create some functions in excel buffer and save the excel files.

This article Applies to Microsoft Dynamics NAV 2013 & NAV 2013 R2. Attached Screens are from NAV 2013 R2.

Thursday, January 9, 2014

NAV 2013 & R2 - Export to Excel Report With Enter Cell.

Hi all,

Yesterday we had seen the changes in Excel Buffer in NAV 2013, but there is one more conman way that we used to use in NAV 2009 For Export to Excel Reports (i.e Enter Cell Function in Report).

Lets discuss that today. The Idea for this post came from Ms +shubhangi verma.

Let's see what changes we need to do in a export to excel report created in NAV 2009 or Previous Version to use in NAV 2013 with ENTERCELL.

Wednesday, January 8, 2014

NAV 2013 & R2 - Export to Excel Report

Hi all,

Let's see the Changes in Excel Buffer Table in NAV 2013 as compared to NAV 2009.

1. As automation are discountinued in NAV 2013, Microsoft have created a DLL for Excel Operations.

2. A new field added in Table "Cell Type", used to specifying type of field.

Tuesday, October 1, 2013

NAV 2013 - Development Environment Crash During Creation of Report Request Page.

Hi all,

I found a issue while upgrading reports to NAV 2013 and Plan to share same with you all.

During Upgrading Classic Reports with Request Form to NAV 2013 (say from Version 5), while trying to create request page for Report - NAV 2013 Development Environment Crashes.

Saturday, July 13, 2013

Tuesday, June 4, 2013

Multiple Copies Classic & RTC with Report Page No. Reset with Each Copy - Part 2

Hi all,

Let's Continue with the part that we left in last session (Reference Article 1)-

So we were done with classic report, let try to do same on RTC Too.

Again from taking reference from Report 206 we follow below listed steps -

Monday, June 3, 2013

Multiple Copies Classic & RTC with Report Page No. Reset with Each Copy - Part 1

Hi all,

I found lot of Queries about this, so lets try to do this. I Divide this article into three parts -

1) Enabling Multiple Copies in a standard Report - Classic. [This Article]
2) Enabling Multiple Copies in a standard Report - RTC.
2) Set Page X / Y in Multiple Copies printing Reports.

For the Demo i will be using Standard Report 16593 - Excise Invoice. This report have none
of the above listed points.

Sunday, February 3, 2013

NAV 2009 Reports - Common Issue & Resolutions.. (Part 2)

Hi all,

As promised in the blog entry i will list down some common known things that we need to take care while estimating & developing RTC Reports in 2009 Versions.

* These are my faced issues and their resolutions, you may not agree with all these. If that will be case i would suggest you to share same with others.

Lets begin with RTC Report Header -
During development you might have seen that in standard reports there are basically two ways to display report Headers.

1) Using Page Header.
2) Using Header in Body.

When to use which?