A Page Break is the point at which one page ends and another begins. Handling Page Breaks is
important, as the current page should indicate continuation to the next page, while the next page must indicate that the current page is continued from the previous page. So, there must be a closing identifier, i.e., closing page break information and an opening identifier, i.e., opening page
break information.
In other words, Page Breaks specify the headers and footers for every page, and are printed across multiple pages. Closing Page Break starts printing from the first page and prints on every page except the last page, e.g., Continued... to be printed at the bottom of each page. Opening Page Break starts printing from the second page till the last page. Closing Page Break is specified before Opening Page Break, since in any circumstance, closing page break is encountered first.
In TDL, Page Breaks can be handled vertically as well as horizontally.
Types of Page Breaks
Vertical Page Breaks
In cases where a report containing data cannot be printed in a single page, one needs to use vertical page breaks. Vertical Page Breaks can be specified at 2 levels, viz. Form and Part.
Form Level Page Break
Vertical Page Breaks can be specified at Form through the Form Attribute ‘Page Break’. It takes 2
parameters, viz. First Part for Closing Page Break and Second Part for Opening Page Break.
Syntax
[Form:
Page Break : Closing Part, Opening Part
Example
Consider a Trial Balance report of a company, which requires the title and address of the Company in the first page and the grand total in the last page. In the pages between the first and the last page, the text Continued.... may be required at the end of each page, and the Company Name and Address at the beginning of each page.
[Form: My Trial Balance]
Page Break : Cl Page Break, Op Page Break
;; where both Cl Page Break and Op Page Break are Parts
[Part: Cl Page Break]
Lines: Cont Line
[Line: Cont Line]
Fields: Cont Field
Border: Full Thin Top
[Field: Cont Field]
Set As : “Continued…”
Full width : Yes
Align : Right
[Part: Op Page Break]
Parts: DSP OpCompanyName, DSP OpReportTitle
Vertical: Yes
In this example, Closing Page Break is defined to print Continued... at the end of every continued
page. Opening Page Break is defined to print the Company Name and Report Title at the beginning of all the continuing pages. Since more than one part is used within Part definition, specify the alignment as ‘Vertical’, if required.
Part Level Page Breaks
Vertical Page Breaks can be specified at Part through the Part Attribute Page Break. This is generally used when the Page Totals are to be printed for each closing and opening pages.
It takes 2 parameters, viz.1st Line for Closing Page Break and 2nd Line for Opening Page Break.
Syntax
[Part: Part Name]
Page Break : Closing Line, Opening Line
Example
Consider a Trial Balance Report of a company, where we may require the running page totals to be printed at the end and beginning of each page.
[Part: My Trial Balance]
Page Break : Cl Page Break, Op Page Break
;; where both Cl Page Break and Op Page Break are Lines
[Line: Cl Page Break]
Use : Detail Line
Local : Field: Particulars Fld: Set As: “Carried Forward”
Local : Field: DrAmt Fld: Set As: $$Total:DrAmtFld
Local : Field: CrAmt Fld: Set As: $$Total:CrAmtFld
Local : Field: NetAmt Fld: Set As: $$Total:NetAmtFld
Border: Full Thin Top
[Line: Op Page Break]
Use : Cl Page Break
Local : Field: Particulars Fld: Set As: “Brought Forward”
Here, Line ‘Cl Page Break’ is defined to use the pre-defined ‘Detail Line’ and the relevant fields are modified locally to set the respective values. Similarly, the Line ‘Op Page Break’ is defined to use the above defined line ‘Cl Page Break’, which locally modifies only the field ‘Particulars Fld’.
Horizontal Page Breaks
Horizontal Page Breaks are used if the number of columns run into multiple pages.
Line Level Page Breaks
Horizontal page breaks can be specified at Line through Line Attribute ‘Page Break’. It is generally
used to repeat a closing column at every closing page and opening column at every opening page. It takes 2 parameters, viz. 1st Field for Closing Page Break & 2nd for Opening Page Break.
Syntax
[Line: Line Name]
Page Break : Closing Field, Opening Field
Example
Consider a Columnar Sales Register Report of a company, where multiple columns are printed across pages. Some fixed columns are required in subsequent pages which makes it easy to map the columns in subsequent pages.
[#Line: DSP ColVchDetail]
Page Break : Cl Page Break, Op Page Break
;; where both Cl Page Break and Op Page Break are Fields
[Field: Cl Page Break]
[Field: Op Page Break]
Fields : DBC Fixed, VCH No
In this example, the Field Cl Page Break is defined as Empty, since no Closing Column or Field is required and Field Op Page Break is defined with further fields DBC Fixed and VCH No, which are available in default TDL.
important, as the current page should indicate continuation to the next page, while the next page must indicate that the current page is continued from the previous page. So, there must be a closing identifier, i.e., closing page break information and an opening identifier, i.e., opening page
break information.
In other words, Page Breaks specify the headers and footers for every page, and are printed across multiple pages. Closing Page Break starts printing from the first page and prints on every page except the last page, e.g., Continued... to be printed at the bottom of each page. Opening Page Break starts printing from the second page till the last page. Closing Page Break is specified before Opening Page Break, since in any circumstance, closing page break is encountered first.
In TDL, Page Breaks can be handled vertically as well as horizontally.
Types of Page Breaks
Vertical Page Breaks
In cases where a report containing data cannot be printed in a single page, one needs to use vertical page breaks. Vertical Page Breaks can be specified at 2 levels, viz. Form and Part.
Form Level Page Break
Vertical Page Breaks can be specified at Form through the Form Attribute ‘Page Break’. It takes 2
parameters, viz. First Part for Closing Page Break and Second Part for Opening Page Break.
Syntax
[Form:
Page Break : Closing Part, Opening Part
Example
Consider a Trial Balance report of a company, which requires the title and address of the Company in the first page and the grand total in the last page. In the pages between the first and the last page, the text Continued.... may be required at the end of each page, and the Company Name and Address at the beginning of each page.
[Form: My Trial Balance]
Page Break : Cl Page Break, Op Page Break
;; where both Cl Page Break and Op Page Break are Parts
[Part: Cl Page Break]
Lines: Cont Line
[Line: Cont Line]
Fields: Cont Field
Border: Full Thin Top
[Field: Cont Field]
Set As : “Continued…”
Full width : Yes
Align : Right
[Part: Op Page Break]
Parts: DSP OpCompanyName, DSP OpReportTitle
Vertical: Yes
In this example, Closing Page Break is defined to print Continued... at the end of every continued
page. Opening Page Break is defined to print the Company Name and Report Title at the beginning of all the continuing pages. Since more than one part is used within Part definition, specify the alignment as ‘Vertical’, if required.
Part Level Page Breaks
Vertical Page Breaks can be specified at Part through the Part Attribute Page Break. This is generally used when the Page Totals are to be printed for each closing and opening pages.
It takes 2 parameters, viz.1st Line for Closing Page Break and 2nd Line for Opening Page Break.
Syntax
[Part: Part Name]
Page Break : Closing Line, Opening Line
Example
Consider a Trial Balance Report of a company, where we may require the running page totals to be printed at the end and beginning of each page.
[Part: My Trial Balance]
Page Break : Cl Page Break, Op Page Break
;; where both Cl Page Break and Op Page Break are Lines
[Line: Cl Page Break]
Use : Detail Line
Local : Field: Particulars Fld: Set As: “Carried Forward”
Local : Field: DrAmt Fld: Set As: $$Total:DrAmtFld
Local : Field: CrAmt Fld: Set As: $$Total:CrAmtFld
Local : Field: NetAmt Fld: Set As: $$Total:NetAmtFld
Border: Full Thin Top
[Line: Op Page Break]
Use : Cl Page Break
Local : Field: Particulars Fld: Set As: “Brought Forward”
Here, Line ‘Cl Page Break’ is defined to use the pre-defined ‘Detail Line’ and the relevant fields are modified locally to set the respective values. Similarly, the Line ‘Op Page Break’ is defined to use the above defined line ‘Cl Page Break’, which locally modifies only the field ‘Particulars Fld’.
Horizontal Page Breaks
Horizontal Page Breaks are used if the number of columns run into multiple pages.
Line Level Page Breaks
Horizontal page breaks can be specified at Line through Line Attribute ‘Page Break’. It is generally
used to repeat a closing column at every closing page and opening column at every opening page. It takes 2 parameters, viz. 1st Field for Closing Page Break & 2nd for Opening Page Break.
Syntax
[Line: Line Name]
Page Break : Closing Field, Opening Field
Example
Consider a Columnar Sales Register Report of a company, where multiple columns are printed across pages. Some fixed columns are required in subsequent pages which makes it easy to map the columns in subsequent pages.
[#Line: DSP ColVchDetail]
Page Break : Cl Page Break, Op Page Break
;; where both Cl Page Break and Op Page Break are Fields
[Field: Cl Page Break]
[Field: Op Page Break]
Fields : DBC Fixed, VCH No
In this example, the Field Cl Page Break is defined as Empty, since no Closing Column or Field is required and Field Op Page Break is defined with further fields DBC Fixed and VCH No, which are available in default TDL.