1 / 20

Jenny Lalik

Jenny Lalik. Tips n Techniques. Report Styling Enhancements for 7.7. Accordion By Row Excel 2007 Output Format Hide Null Across Columns Pass dates to EXL2K Control the “FOCUS” underline Display Across Titles MultiDrill list box . Accordion BY Tree Add a tree control to BY fields.

lucien
Download Presentation

Jenny Lalik

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Jenny Lalik Tips n Techniques

  2. Report Styling Enhancements for 7.7 • Accordion By Row • Excel 2007 Output Format • Hide Null Across Columns • Pass dates to EXL2K • Control the “FOCUS” underline • Display Across Titles • MultiDrill list box

  3. Accordion BY TreeAdd a tree control to BY fields • An interactive HTML tree interface to data aggregated at multiple sort levels. • Initial view presents highest dimension sort field and aggregated measures. • Click to open each sort key value and view the next dimension and the associated aggregated measures.

  4. Accordion By RowSET EXPANDBYROW = {ON/OFF/ALL/N} • Sets subtotals (LAST BY-1) • Sets subtotals above the data • Turns off features not supported: • Page Numbers • Report Totals • Borders • Presents open at any level • ON/ALL / N SET EXPANDBYROW = ON TABLE FILE GGSALES SUM GGSALES.SALES01.BUDUNITS GGSALES.SALES01.UNITS GGSALES.SALES01.BUDDOLLARS GGSALES.SALES01.DOLLARS BY LOWEST GGSALES.SALES01.REGION BY LOWEST GGSALES.SALES01.CATEGORY BY LOWEST GGSALES.SALES01.PRODUCT ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON END

  5. Accordion By RowStyling Features Not Supported • EXPANDBYROW is set OFF in reports with: • Multi-verb requests. • PRINT/LIST. • OVER. • TABLEF. • ROW -TOTAL. • ON field RECAP. • FOR. • IN. • SEQUENCE. • PAGENUM. • SUBHEAD. • Any BORDER keywords are ignored.

  6. Accordion By RowStyling Features Not Supported • EXPANDBYROW is set OFF in reports with: • Multi-verb requests. • PRINT/LIST. • OVER. • TABLEF. • ROW -TOTAL. • ON field RECAP. • FOR. • IN. • SEQUENCE. • PAGENUM. • SUBHEAD. • Any BORDER keywords are ignored.

  7. Accordion By Row Demo

  8. Excel 2007 Output Format (EXL07)Production in Release 7.7.02 • Excel 2007 Workbooks & Templates • Feature Table • What is supported in Release 7.7.02 • Future Development • Demos • Core Styling Features • Templates • From .MHT to .XLTX

  9. What WebFOCUS generates for FORMAT EXL07 • Workbooks - .XLSX • XML component files define the workbook characteristics • Zipped into single binary .XLSX file • Workbooks based on Templates • based on Excel 2007 .XLTX template files • Supports native Excel 2007 formulas, tables, graphs, images, cell formatting. • Zipping the .XLSX • Done by JAVA layer • WebFOCUS Client (Servlet) – default • Reporting Server (JSCOM) – supports secured servers • Defined location in • WebFOCUS Administration Console (IBIF_excelservurl) • in FEX with SET EXCELSERVURL

  10. Hide Null Across ColumnsSET HIDENULLACRS = {ON|OFF} Hide ACROSS columns that are completely empty (null / missing) within each sort key page break. {ON|BY} fieldname PAGE-BREAK • Designed to support page oriented formats PDF / DHTML / PPT / PS • Demos well in the table based formats HTML / EXL2K / EXL07

  11. Hide Null Across Columns Standard HTML Across Report (DEFAULT)

  12. Hide Null Across Columns HTML Across Report with SET HIDENULLACRS = ON

  13. EXL2K: Dates As Formatted Values OR TextSET EXL2KTXTDATE = {TEXT|VALUE} • Pass dates to EXL2K as values with formats rather than text • FOCUS Date formats translated into Excel format masks • Date Components that remain translated text • Dates Without a Day Component • Quarter Formats • Date Components for Use in Excel Formulas • EXL07 works with VALUE by default

  14. EXL2KTXTDATE: TEXT vs VALUE

  15. Control the “FOCUS” UnderlineSET TITLELINE = {ON|OFF|SKIP} • FOCUS Underline inserted in PDF, PPT, PS & DHTML

  16. Controlling the “FOCUS” Underline SET TITLELINE=OFF TABLE FILE GGSALES SUM GGSALES.SALES01.UNITS GGSALES.SALES01.DOLLARS BY LOWEST GGSALES.SALES01.CATEGORY BY LOWEST GGSALES.SALES01.PRODUCT ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * $ TYPE=REPORT, FONT='TREBUCHET MS', SIZE=10, COLOR='BLACK', STYLE=BOLD, $ ENDSTYLE END

  17. Controlling the “FOCUS” Underline SET TITLELINE=SKIP TABLE FILE GGSALES SUM GGSALES.SALES01.UNITS GGSALES.SALES01.DOLLARS BY LOWEST GGSALES.SALES01.CATEGORY BY LOWEST GGSALES.SALES01.PRODUCT ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * $ TYPE=REPORT, FONT='TREBUCHET MS', SIZE=10, COLOR='BLACK', STYLE=BOLD, $ ENDSTYLE END

  18. Move the Across Titles (PDF Only)SET ACROSSTITLE={ABOVE/SIDE} ABOVE SET ACROSSTITLE = SIDE TABLE FILE GGSALES SUM UNITS BY REGION ACROSS CATEGORY ACROSS PRODUCT WHERE CATEGORY NE 'Gifts'; ON TABLE PCHOLD FORMAT PDF ON TABLE SET STYLE * BORDER=LIGHT, FONT='TREBUCHET MS', SIZE=10, $ ENDSTYLE END SIDE

  19. Multidrill control file for colors/fonts • Edit and change highlightedproperty for the background color to match yourweb portal colors • Found in ibi\WebFOCUS77\ibi_html\javaassist\ibi\html\js\multidrill.css

  20. Thank You For more help visit http://techsupport.informationbuilders.com/

More Related