15Dec

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 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 printing sales header in first table and sales lines another, where each table data should print in different pages. To do this, we must first group the data into a single entity for each document using List control and after group each table controls, header table with header grouping and line table with details grouping, whereas sales header table control prints sales header information and sales line table control prints list of sales lines, and to print sales header and lines in separate with different pages, by setting up page break properties of each group.

Step by step:

1.   Place a List control on report body section. List control is used to list entries one after another. As we place two table controls (Header and Lines) it list entries from each tables such as Header and its lines as one after another in different pages.

2.   Place two table controls inside the List control, one after another vertically, for example, whichever order you wish, as shown below.

List Control

Screenshot 1: Shows Table controls inside List control.

3.   We group sales document based on sales document number, hence we must group data in the list control as shown below.

Shows grouping List control.

Screenshot 2: Shows grouping List control.

Shows grouping with sales document number

Screenshot 3: Shows grouping with sales document number.

4.   Group sales header table with sales document number. Follow the same steps done for the list control.

5.   Apply parent grouping to sales line table as shown below. In sales line table we group sales lines based on sales document number because we need to print list of sale lines for each header.

Shows parent grouping of sales line table.

Screenshot 4: Shows parent grouping of sales line table.

Shows how to add group header with parent grouping to sales line table

Screenshot 5: Shows how to add group header with parent grouping to sales line table.

Shows how sales lines table looks after grouping

Screenshot 6: Shows how sales lines table looks after grouping.

You can delete columns which are not necessary in the table.

6.   After grouping has been done, you should apply page break to both table controls, as both inserts a new page when they finishes printing entries for each document, to print both sales header and details in different pages. Select the group in each table control and apply page break as shown below. To apply page breaks, select the group and open properties window of it as shown below.

Shows how to select the group to which page break applies

Screenshot 7: Shows how to select the group to which page break applies.

Shows properties window of the group to apply page breaks

Screenshot 8: Shows properties window of the group to apply page breaks.

Note: Reset page number for sales line table only as it indicates the end of a document and restart the page number with new document.

7.   Add fields and parameters you wish to print in the report, as shown below.

Shows after grouping and added fields required

Screenshot 9: Shows after grouping and fields.

8.    Report output: First screenshot shows sales header and second shows relevant sales lines of the document shows in first screenshot.

Shows Header in first page

Screenshot 10: Shows Header in first page.

Sales Lines in second page

Screenshot 11: Sales Lines in second page.

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

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

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
  • *
  • *