Microsoft Dynamics NAV - RDLC Report with Leader Dots.
Reviewed by 0x000216
on
Tuesday, July 19, 2016
Rating: 5
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.
Read Complete Article »
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.
RDLC Report - The tablix ‘Tablix1’ has a detail member with inner members. Detail members can only contain static inner members.
Reviewed by 0x000216
on
Friday, December 18, 2015
Rating: 5
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.
Read Complete Article »
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.
Let's Begin.
NAV 2013 R2 - Export To Excel With Font & Color
Reviewed by 0x000216
on
Sunday, August 02, 2015
Rating: 5
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.
Read Complete Article »
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.
NAV 2013 R2 - Multiple Sheets in Excel Using Excel Buffer.
Reviewed by 0x000216
on
Sunday, July 26, 2015
Rating: 5
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.
Read Complete Article »
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.
NAV 2013 R2 - Import Excel File Using Excel Buffer.
Reviewed by 0x000216
on
Tuesday, June 30, 2015
Rating: 5
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.
Read Complete Article »
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.
NAV 2013 & Later - Grouping In Export To Excel Report Without Layout.
Reviewed by 0x000216
on
Sunday, June 21, 2015
Rating: 5
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.
Read Complete Article »
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.
NAV Report - How To Use Excel SUMIF Function?
Reviewed by 0x000216
on
Sunday, May 24, 2015
Rating: 5
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 ?
Read Complete Article »
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 ?
NAV - RTC Report Reset Row No. / Serial No. on Group Change.
Reviewed by 0x000216
on
Sunday, April 19, 2015
Rating: 5
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.
Read Complete Article »
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.
RTC Report - Formatting Boolean Values as Check Mark and X Mark.
Reviewed by 0x000216
on
Monday, November 17, 2014
Rating: 5
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..
Read Complete Article »
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..
Navision - How to Format Dates for Cheque Reports?
Reviewed by 0x000216
on
Wednesday, October 22, 2014
Rating: 5
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.
Read Complete Article »
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.
How to Use an Embedded Picture in a RTC Report.
Reviewed by 0x000216
on
Sunday, May 04, 2014
Rating: 5
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.
Read Complete Article »
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.
NAV 2013 & NAV 2013 R2 - Save Export to Excel
Reviewed by 0x000216
on
Thursday, January 09, 2014
Rating: 5
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.
Read Complete Article »
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.
NAV 2013 & R2 - Export to Excel Report With Enter Cell.
Reviewed by 0x000216
on
Wednesday, January 08, 2014
Rating: 5
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.
Read Complete Article »
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.
NAV 2013 & R2 - Export to Excel Report
Reviewed by 0x000216
on
Tuesday, January 07, 2014
Rating: 5
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.
Read Complete Article »
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.
NAV 2013 - Development Environment Crash During Creation of Report Request Page.
Reviewed by 0x000216
on
Tuesday, October 01, 2013
Rating: 5
Save Navision RTC Reports into PDF, Word & Excel..
Hi all,
If you would have noticed with the introdcution of RTC Client in 2009 i.e NAV 2009, in C/AL Symbol Menu Report have some new options.
Read Complete Article »
If you would have noticed with the introdcution of RTC Client in 2009 i.e NAV 2009, in C/AL Symbol Menu Report have some new options.
Save Navision RTC Reports into PDF, Word & Excel..
Reviewed by 0x000216
on
Friday, July 12, 2013
Rating: 5
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 -
Read Complete Article »
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 -
Multiple Copies Classic & RTC with Report Page No. Reset with Each Copy - Part 2
Reviewed by 0x000216
on
Tuesday, June 04, 2013
Rating: 5
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.
Read Complete Article »
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.
Multiple Copies Classic & RTC with Report Page No. Reset with Each Copy - Part 1
Reviewed by 0x000216
on
Sunday, June 02, 2013
Rating: 5
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?
Read Complete Article »
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?
NAV 2009 Reports - Common Issue & Resolutions.. (Part 2)
Reviewed by 0x000216
on
Sunday, February 03, 2013
Rating: 5