Transcript WebFOCUS Report Design: PDF vs. HTML

WebFOCUS Report Design:
PDF vs. HTML
Mickey Grackin
IT Specialist
National Institute of Standards and Technology
WebFOCUS Report Design: PDF vs. HTML
Agenda
 PDF versus HTML Discussion
 Traditional FOCUS Language Behavior
 General Formatting
 GRIDs and BORDERs
 SPACES and GAPs
 SQUEEZE and WRAP
 Live Demonstrations
 Other keywords
Disclaimer: This presentation should in no way be construed as indicating that WebFOCUS or
Information Builders, Inc. are endorsed by NIST or are recommended by NIST or that they are
necessarily the best materials, instruments, software or suppliers for the purposes described.
2
WebFOCUS Report Design: PDF vs. HTML
PDF versus HTML Discussion
WebFOCUS Report Design: PDF vs. HTML
PDF versus HTML Discussion
 They are two different animals
 HTML Format




What’s a page?
I am a “living” document
Dynamic Document
Half Baked Document from WebFOCUS
 PDF Format
 Must be a page!
 I am a “Permanent” document
 Static Document
 Fully Baked Document from WebFOCUS
4
WebFOCUS Report Design: PDF vs. HTML
General Formatting
WebFOCUS Report Design: PDF vs. HTML
General Formatting – Default Behavior
TABLE FILE CAR
PRINT DEALER_COST RETAIL_COST SALES
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT HTML or PDF
END
6
WebFOCUS Report Design: PDF vs. HTML
General Formatting – Default Behavior
 HTML Format
 One “page”
 GRID around TITLEs and DATA
 No SPACE between columns
 Dynamic column widths
 PDF Format
 Two pages
 No GRID around TITLEs and DATA
 GAPs between columns
 Fixed column widths
7
WebFOCUS Report Design: PDF vs. HTML
General Formatting – WebFOCUS Style Sheet
 FOCUS Language keywords to control
formatting of the report elements
 WebFOCUS Style Sheet is NOT a Cascading
Style Sheet (CSS)
ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE,$
ENDSTYLE
8
WebFOCUS Report Design: PDF vs. HTML
GRIDs and BORDERs
WebFOCUS Report Design: PDF vs. HTML
General Formatting – GRIDs and BORDERs
 GRID keyword controls border lines around
report elements
 PDF versus HTML with GRID look different
 VGRID and HGRID keywords
 BORDER keywords added in later releases
(will discuss this later)
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON,$
10
WebFOCUS Report Design: PDF vs. HTML
SPACEs and GAPs
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SPACES and GAPs
 Traditional FOCUS Behavior
 SPACES – Places N spaces between
columns
 Column width depends on length of the
Field Format and Title values
 Very rarely used (if at all) in WebFOCUS
 SPACES setting Only works with
STYLEMODE=FIXED
12
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SPACES and GAPs
 HTML Format
 SPACES setting has no affect
 Cell Spacing and Cell Padding
 Columns are only as wide as necessary
 PDF Format
 SPACES setting has no affect
 GAPs separate columns
 Columns as wide as Field Format or Title
 SQUEEZE and WRAP change the column
width rules for both HTML and PDF formats
13
WebFOCUS Report Design: PDF vs. HTML
SQUEEZE and WRAP
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SQUEEZE and WRAP
 SQUEEZE=ON
 Removes unnecessary blanks
 HTML default behavior
 SQUEEZE=OFF
 Mimics traditional column width behavior
 PDF default behavior
 May be applied to the entire report or on
specific report columns for both HTML and
PDF formats
 SQUEEZE=[number] is also possible
15
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SQUEEZE and WRAP
 WRAP=ON
 Allows text to word wrap
 HTML default behavior with GRID=ON
 WRAP=OFF
 Does NOT allow text to word wrap
 HTML default behavior when
SQUEEZE=OFF or GRID=OFF
 PDF default behavior
 WRAP=ON or OFF very rarely used
 WRAP=[number] is also possible
16
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SQUEEZE and WRAP
 ON TABLE SET HTMLCSS ON
 Allows full usage of SQUEEZE and WRAP
for HTML format
 Translates WebFOCUS Style Sheet to
Cascading Style Sheet (CSS) settings
 Has no affect on PDF format
17
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SQUEEZE and WRAP – HTML
TABLE FILE CAR
PRINT DEALER_COST RETAIL_COST SALES
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON,$
ENDSTYLE
END
18
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SQUEEZE and WRAP – HTML
 SQUEEZE=[number] and HTML format
 Acts like maximum width setting
 It still WRAPs if necessary
ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON,$
TYPE=REPORT, COLUMN=CAR, SQUEEZE=2,$
ENDSTYLE
END
19
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SQUEEZE and WRAP – HTML
 SQUEEZE=[number], WRAP=OFF and HTML
format
 Locks width of the column
 Column will not wrap
TYPE=REPORT, COLUMN=CAR, SQUEEZE=2,
WRAP=OFF,$
20
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SQUEEZE and WRAP – HTML
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON, WRAP=OFF,$
TYPE=REPORT, COLUMN=CAR, SQUEEZE=2,$
TYPE=REPORT, COLUMN=MODEL, SQUEEZE=2,$
TYPE=REPORT, COLUMN=MODEL, WRAP=2,$
21
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SQUEEZE and WRAP – PDF
TABLE FILE CAR
PRINT DEALER_COST RETAIL_COST SALES
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON,$
ENDSTYLE
END
22
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SQUEEZE and WRAP – PDF
 SQUEEZE=[number] and PDF format
 Locks width of the column
 It will truncate if necessary
ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON,$
TYPE=REPORT, COLUMN=CAR, SQUEEZE=2,$
ENDSTYLE
END
23
WebFOCUS Report Design: PDF vs. HTML
General Formatting – SQUEEZE and WRAP – PDF
TYPE=REPORT, COLUMN=MODEL, SQUEEZE=2,$
TYPE=REPORT, COLUMN=MODEL, WRAP=2,$
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON, SQUEEZE=2,$
TYPE=REPORT, COLUMN=MODEL, WRAP=2,$
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON, WRAP=1.5,$
24
WebFOCUS Report Design: PDF vs. HTML
GAPs Revisted
WebFOCUS Report Design: PDF vs. HTML
General Formatting – GAPs
TABLE FILE CAR
PRINT DEALER_COST RETAIL_COST SALES
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON,$
ENDSTYLE
END
26
WebFOCUS Report Design: PDF vs. HTML
General Formatting – GAPs
 GAPs are the space between the column
values and the gridlines that surround them
on PDF format reports
 LEFTGAP, RIGHTGAP, TOPGAP and
BOTTOMGAP
 Can be used for HTML format when:
 ON TABLE SET HTMLCSS ON
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON, LEFTGAP=0,$
27
WebFOCUS Report Design: PDF vs. HTML
General Formatting – GAPs
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON, LEFTGAP=0, BOTTOMGAP=.25,$
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE,
GRID=ON, LEFTGAP=1, BOTTOMGAP=.25,$
28
WebFOCUS Report Design: PDF vs. HTML
BORDERs Revisted
WebFOCUS Report Design: PDF vs. HTML
General Formatting – BORDERs
TABLE FILE CAR
PRINT DEALER_COST RETAIL_COST SALES
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE SET PAGE NOPAGE
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT HTML or PDF
ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE,
SQUEEZE=ON,$
ENDSTYLE
END
30
WebFOCUS Report Design: PDF vs. HTML
General Formatting – BORDERs
 Alternative to GRID
 BORDER keywords allow better control of
gridlines (borders)
 Consistent look between HTML and PDF
 Can change border STYLE, COLOR and
thickness of each border line
TYPE=REPORT, ORIENTATION=LANDSCAPE,
SQUEEZE=ON, BORDER=LIGHT,$
31
WebFOCUS Report Design: PDF vs. HTML
General Formatting – BORDERs
TYPE=REPORT, ORIENTATION=LANDSCAPE,
SQUEEZE=ON,
BORDER-LEFT=HEAVY,
BORDER-LEFT-STYLE=DASHED,
BORDER-LEFT-COLOR=RGB(255 0 255),$
TYPE=REPORT, ORIENTATION=LANDSCAPE,
SQUEEZE=ON,
BORDER=HEAVY,
BORDER-STYLE=DASHED,
BORDER-COLOR=RGB(255 0 255),$
32
WebFOCUS Report Design: PDF vs. HTML
Summary
 This is just the tip of the iceberg
 WebFOCUS offers tremendous flexibility and
control over report design for both the HTML
and PDF formats
 Find this and more on Information Builders
Developer Center  Tips and Techniques
WebFOCUS Report Design – Part 1
http://www.informationbuilders.com/support/developers/htmlpdf.html
WebFOCUS Report Design – Part 2
http://www.informationbuilders.com/support/developers/htmlpdf_part2.html
33
WebFOCUS Report Design: PDF vs. HTML
Questions???
Tell a Good Joke Now
34