Selecting Page Size, Orientation, and Color

How to:

Reference:

You can select the page size, page orientation (portrait or landscape), and page color for your report. The default page size is letter (8.5 x 11 inches), but you can select from many other sizes, including legal and envelopes.

Reference: Page Size, Orientation, and Color Attributes

Attribute

Description

Applies to

PAGESIZE

Sets page size.

In the Development environment:

  • PDF
  • PS
  • PPT
  • PPTX
ORIENTATION

Sets page orientation.

In the Development environment:

  • PDF
  • PS
  • EXL2K
  • PPT
  • PPTX
PAGECOLOR

Sets page color.

  • HTML report with internal cascading style sheet
  • PPTX

    Note: The PAGECOLOR StyleSheet attribute is ignored in a report containing a template, in order to preserve the styles in the template.

Syntax: How to Set Page Size

This syntax applies to a PDF, PS, PPT, or PPTX report.

[TYPE=REPORT,] PAGESIZE={size|LETTER}, $

where:

TYPE=REPORT

Applies the page size to the entire report. Not required, as it is the default value.

size

Is the page size. If printing a report, the value should match the size of the paper. Otherwise, the report may be cropped or printed with extra blank space.

Valid values are:

Value

Description

SCREEN

Sets the page size so that the report fills the screen. Each print line is infinitely wide. The report width determines the page width. The number of lines per page depends on how many lines fit on the screen. This number varies, depending on the font and screen resolution.

LETTER

8.5 x 11 inches. LETTER is the default value.

LEGAL

8.5 x 14 inches.

CUSTOM

Enables you to set a custom page size for a DHTML, PDF, or PPTX report. If you use the CUSTOM option, you can specify the length and width values in the request using CUSTOM-PAGE-LENGTH=number and CUSTOM-PAGE-WIDTH=number through a SET command or StyleSheet attribute. The number value you specify depends on the UNITS parameter (inches, centimeters, points). The default is inches.

TABLOID

11 x 17 inches.

LEDGER

17 x 11 inches.

WIDESCREEN

13.333 x 7.5 inches.

C

17 x 22 inches.

D

22 x 34 inches.

E

34 x 44 inches.

STATEMENT

5.5 x 8.5 inches.

EXECUTIVE

7.5 x 10.5 inches.

FOLIO

8.5 x 13 inches.

10x14

10 x 14 inches.

A3

297 x 420 millimeters.

A4

210 x 297 millimeters.

A5

148 x 210 millimeters.

B4

250 x 354 millimeters.

B5

182 x 257 millimeters.

QUARTO

215 x 275 millimeters.

ENVELOPE-9

3.875 x 8.875 inches.

ENVELOPE-10

4.125 x 9.5 inches.

ENVELOPE-11

4.5 x 10.375 inches.

ENVELOPE-12

4.5 x 11 inches.

ENVELOPE-14

5 x 11.5 inches.

ENVELOPE-MONARCH

3.875 x 7.5 inches.

ENVELOPE-PERSONAL

3.625 x 6.5 inches.

ENVELOPE-DL

110 x 220 millimeters.

ENVELOPE-C3

324 x 458 millimeters.

ENVELOPE-C4

229 x 324 millimeters.

ENVELOPE-C5

162 x 229 millimeters.

ENVELOPE-C6

114 x 162 millimeters.

ENVELOPE-C65

114 x 229 millimeters.

ENVELOPE-B4

250 x 353 millimeters.

ENVELOPE-B5

176 x 250 millimeters.

ENVELOPE-B6

176 x 125 millimeters.

ENVELOPE-ITALY

110 x 230 millimeters.

US-STANDARD-FANFOLD

14.875 x 11 inches.

GERMAN-STANDARD-FANFOLD

8.5 x 12 inches.

GERMAN-LEGAL-FANFOLD

8.5 x 13 inches.

Syntax: How to Set Page Orientation

This syntax applies to a PDF, PS, or EXL2K report.

[TYPE=REPORT,] ORIENTATION={PORTRAIT|LANDSCAPE}, $

where:

TYPE=REPORT

Applies the page orientation to the entire report. Not required, as it is the default.

PORTRAIT

Displays the report across the narrower dimension of a vertical page, producing a page that is longer than it is wide. PORTRAIT is the default value.

LANDSCAPE

Displays the report across the wider dimension of a horizontal page, producing a page that is wider than it is long.

Example: Setting Page Orientation

This request sets the page orientation of a PDF report to landscape.

SET ONLINE-FMT = PDF 
TABLE FILE CENTQA
SUM CNT.PROBNUM AS 'Total Number, of Problems'
SUM CNT.PROBNUM AS 'Problems From, Each Plant' BY PLANT
SUM CNT.PROBNUM AS 'Problem by Product' BY PLANT BY PRODNAME
ON PLANT PAGE-BREAK
HEADING CENTER
"QA Report for Company, Plant, and Product"
" "
ON TABLE COLUMN-TOTAL
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE * 
TYPE=REPORT, ORIENTATION=LANDSCAPE, $ 
ENDSTYLE
END

Syntax: How to Set Page Color

This syntax applies to an HTML report with internal cascading style sheet.

[TYPE=REPORT,] ... PAGECOLOR=color, ... , $

where:

TYPE=REPORT

The TYPE specification is optional with this feature. If omitted, TYPE defaults to REPORT.

color

Is a supported color. For a list of values, see Formatting Report Data.

Example: Setting Page Color

This request sets the page color of an HTML report with internal cascading style sheet to silver.

SET HTMLCSS = ON 
TABLE FILE CENTORD
ON TABLE SUBHEAD
"SELECTED PRODUCT INVENTORY"
SUM QTY_IN_STOCK/D12 BY PROD_NUM BY SNAME BY STATE
WHERE PROD_NUM EQ '1004'
WHERE SNAME EQ 'eMart'
WHERE STATE EQ 'CA'
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE * 
TYPE=REPORT, PAGECOLOR=SILVER, GRID=OFF, $ 
ENDSTYLE
END

The output is: