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

Wednesday, July 20, 2016

Microsoft Dynamics NAV - RDLC Report with Leader Dots.

Hi All,

In NAV 2009 and Previous Version Textbox and Labels have a property called LeaderDots.

The property actually Sets a series of leading characters (…) before or after the data.



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

Saturday, July 13, 2013

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.

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?

Thursday, January 10, 2013

NAV 2009 Reports - Common Issue & Resolutions..

Hi all,

I know it to late but I wish you all a very Happy  & Prosperous New Year. I am so much busy these days that i can't even make a Blog entry.

So here is the list of points that i will be coming up in next few days (once i will get free) -

As most of us still working on NAV 2009 Reports. Let's figure out the challenges we face during development of RTC Reports.

1) Report Header in First Page Only?
2) Report Header in All Pages?
3) Report Footer in Last Page Only?
4) Report Footer in All Pages?
5) Report Footer in Last Page Bottom Only?
6) Resetting page number while running report for multiple records?

I will be posting entries for all these points, if anyone have any other doubts about RTC Report please add it as comment on this article. I will try to figure out the solution for same and will append the above list.

Let's try to work to RTC reports as easy as it used to be in Classic Version.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

Wednesday, December 12, 2012

Add Image in RTC Reports?

Hi all,

I think i got late with this post, but i was unaware that most of us still don't know how to add reports in Role Tailored Client Reports.

So let's have a look on the same. For the demo purpose i will use standard report with ID 111.

Monday, March 19, 2012

RTC Report Landscape Format without Printer Settings.


Hi all,

In Case of Report Development in Landscape Format, it was behaving wired. In need to select the printer orientation from the printer settings.

But later on i thought about the same and started searching on the web. Then From MSDN i found out that if the report settings in RDLC are done correctly then we don't need to change the printer settings everytime.

How Printed Report Settings Are Determined

IF The settings in the Report Properties dialog box on the layout of the report specify a standard paper size, Then the settings in the Report Properties dialog box on the RDLC layout but is overridden if you change the settings in the Print dialog box.

For more info, you can read the whole article from here.

For Standard Lanscape Page Size these are the setting for RDLC Reports.

Interactive  8.5in, 11in
Margin       1.5cm, 0in, 2cm, 2cm
Page Size    29.7cm, 21cm
Body Size   27.29206cm, 9.16692cm

I hope this issue was faced by most of developers.


Hi all Just a update in same post. The above method works only in NAV 2009 R2 and later. For Printing Report in Landscape Format in NAV 2009 SP1, just apply the hotfix before using above technique.

The hotfix is available for NAV 2009 SP1 here.  

Thanks & Regards,
Saurav Dhyani

Thursday, February 9, 2012

RTC Report designing NAV2009 Videos


Hi all,

While browsing for RTC Report Development i found out something, which i thought to share will all.


Some videos for Report Designing in RTC have been uploaded in YouTube. 

Have a look on the playlist here.

Thanks & Regards,
Saurav Dhyani

Wednesday, December 21, 2011

RTC Report Page Number - Format x/y


Hi all,

Let see how can we achieve Page Number in RTC Reports as CurrentPage/Total Pages in RTC Reports.

Design any of the standard reports I used purchase invoice, and go to RTC Layout of the report From View - layout.

I have added a new text box in the report Header, then i went to expression by right-clicking on the text box.

RTC Report Page Number - Format x/y


Hi all,

Let see how can we achieve Page Number in RTC Reports as CurrentPage/Total Pages in RTC Reports.

Design any of the standard reports I used purchase invoice, and go to RTC Layout of the report From View - layout.

I have added a new text box in the report Header, then i went to expression by right-clicking on the text box.

Tuesday, September 20, 2011

TransHeader & TransFooter in RTC Reports


Hi all,

While Trying to figure out something new features in Navision RoleTailored Client, I figured out a blog which i find usefull to share with you all.

Most of the time customer ask for Transheaders and Transfooters in Role Tailored Client(RTC) Reports and we say that it cannot be done as read in microsoft documents.

I tested by creating a report as suggested in the Blog and it worked as expected.
Its is done by using the Hash Table in the Report Code Section.

Please read the complete blog at here.

Thanks & Regards
Saurav Dhyani
http://saurav-nav.blogspot.com/

Monday, July 4, 2011

RTC Report Development 3


Hi all,

If you havent read part1 and part2 then click here for Part1 and Part2.


Now lets see what can be done to create Page Header without any issues.
Lets check what microsoft do to create Page Header for the same report. Here is what it see the Layout of standard Report.

Thursday, June 30, 2011

RTC Report Development 2


Hi all,

If you havent read the part first then read it here.


Now when you created the sugggestion layout you can see the Red Dots in the Report body. For being specific in the table details of the first table in the Page Body.








The most part of an RTC Report is the Page Header, we all face issues in this.

Let's discuss what happens when we say suggest layout.

Wednesday, June 29, 2011

RTC Report Development 1

Hi all,

we all have some known and unkown issues while creating a Report For Role Tailored Client.
we will try to create a standard report by deleting its Layout and creating a new RDLC Layout from Scratch.


I have saved Standard Report 406 Purchase - Invoice as 5000 Purchase - Invoice 1.
Then i deleted its existing layout by using Tools->Delete Layout.

Now lets create the Layout from Scratch.
Now lets see what Layout suggestion suggest for this report, by using Tools -> Create Layout Suggestion.

Popular Posts