28Nov

How to Print Microsoft Dynamics NAV 2013 R2 RDLC Report Page Footer on Last Page Only

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.  “Print on last page”: It prints page footer on every page except first page.

As I explained in above points we can use page footer to print footer at bottom of a page but it prints on every page, except very first or last page. So what is the way to print page footer at an end of a report? Here I explain how to achieve this using a simple method.

If we want to hide a text box from all pages except last page, set an expression to visibility property of the text box. The expression is to hide the text box in all pages except last page, therefore use the built-in fields to achieve this.

Expression and its syntax explained below:

=IIF(Expression, Yes, No);

   1.  Expression (1st parameter) = it’s a condition for hide, hide if current page is not last page (If current page is not equal to last page). IIF means “If and only if”.

   2.  Yes/True (2nd Parameter) = Hide if condition is true.

   3.  No/False (3rd Parameter) =Show if condition is true.

Here we are writing expression for not to hide if current page is equal to last page so the expression looks like this:

 ”=IIF(CurrPage=LastPage, Don’t hide, Else hide)”, So the expression is “=IIF(Globals!PageNumber=Globals!TotalPages, false, true)”.

What if two or more text boxes to hide? In this scenario place all text boxes inside a rectangle control and apply this visibility condition to the rectangle instead each text boxes.

Please have a look at below screenshot shows how to write above expression or how to hide text if current page is not the last one.

Figure 1

Figure 1: Shows how to hide text if current page is not the last.

If you wish to discuss regarding this RDLC Report Design blog, please feel free to drop me an email to dileepa.b@ecanarys.com.

 

Related

How to print Header and Details (Lines) in different pages of a RDLC Report in NAV 2013 R2

We usually print header and details section of a document on same page, what if we want to print on ...

Read More >

How to print TransHeader and TransFooter in Microsoft Dynamics NAV RDLC reports

We know that TransHeader and TransFooter section types were available in NAV 2009 version but there ...

Read More >

How to Customize the Microsoft Dynamics NAV 2013 R2 Splash screen Image

I think I got late with this post, but I was unaware that most of us still don’t know how to c...

Read More >

New and Important things to know for better RDLC report design in NAV 2013 R2.

We are all learning new things about RDLC report design and we know that still there are lot of thin...

Read More >

Design Microsoft Dynamics Navision 2013R2 RDLC Report Part-2

 In this post we will move to next step, and there we will go through two more data item groupi...

Read More >

How to write custom code in NAV 2013 R2 Report layout design?

You may want to add custom code to the RDLC report to do more actions than what's already provid...

Read More >

Design Microsoft Dynamics Navision 2013R2 RDLC Report

What is RDLC Report?The Report Definition Language (RDL) Data is a report component that is used by ...

Read More >

Microsoft Dynamics NAV 2013 R2 Chart Generator

In general chart means visual display of information, this is one such feature that is introduced in...

Read More >

Share

Post a Comment

  • Recent
  • Popular
  • Tag
Tags
Monthly Archive
Subscribe
Name

Contact Us
  • *
  • *