Mickey Grackin IT Specialist National Institute of Standards and Technology - PowerPoint PPT Presentation

slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Mickey Grackin IT Specialist National Institute of Standards and Technology PowerPoint Presentation
Download Presentation
Mickey Grackin IT Specialist National Institute of Standards and Technology

play fullscreen
1 / 34
Mickey Grackin IT Specialist National Institute of Standards and Technology
213 Views
Download Presentation
arleen
Download Presentation

Mickey Grackin IT Specialist National Institute of Standards and Technology

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. WebFOCUS Report Design: PDF vs. HTML Mickey Grackin IT Specialist National Institute of Standards and Technology

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

  3. WebFOCUS Report Design: PDF vs. HTML PDF versus HTML Discussion

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

  5. WebFOCUS Report Design: PDF vs. HTML General Formatting

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

  7. WebFOCUS Report Design: PDF vs. HTML GeneralFormatting – 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

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

  9. WebFOCUS Report Design: PDF vs. HTML GRIDs and BORDERs

  10. 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,$

  11. WebFOCUS Report Design: PDF vs. HTML SPACEs and GAPs

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

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

  14. WebFOCUS Report Design: PDF vs. HTML SQUEEZE and WRAP

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

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

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

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

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

  20. 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,$

  21. 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,$

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

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

  24. 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,$

  25. WebFOCUS Report Design: PDF vs. HTML GAPs Revisted

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

  27. 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,$

  28. 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,$

  29. WebFOCUS Report Design: PDF vs. HTML BORDERs Revisted

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

  31. 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,$

  32. 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),$

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

  34. Questions??? Tell a Good Joke Now