jenny lalik
DESCRIPTION
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. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/1.jpg)
Tips n TechniquesJenny Lalik
![Page 2: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/2.jpg)
Report Styling Enhancements for 7.7
Accordion By RowExcel 2007 Output FormatHide Null Across ColumnsPass dates to EXL2KControl the “FOCUS” underlineDisplay Across TitlesMultiDrill list box
Copyright 2007, Information Builders. Slide 2
![Page 3: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/3.jpg)
Accordion BY TreeAdd a tree control to BY fields
Copyright 2007, Information Builders. Slide 3
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.
![Page 4: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/4.jpg)
Accordion By RowSET EXPANDBYROW = {ON/OFF/ALL/N}
SET EXPANDBYROW = ONTABLE FILE GGSALESSUM GGSALES.SALES01.BUDUNITS GGSALES.SALES01.UNITS GGSALES.SALES01.BUDDOLLARS GGSALES.SALES01.DOLLARSBY LOWEST GGSALES.SALES01.REGIONBY LOWEST GGSALES.SALES01.CATEGORYBY LOWEST GGSALES.SALES01.PRODUCTON TABLE PCHOLD FORMAT HTMLON TABLE SET HTMLCSS ONEND
• 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
![Page 5: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/5.jpg)
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.
Copyright 2007, Information Builders. Slide 5
![Page 6: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/6.jpg)
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.
Copyright 2007, Information Builders. Slide 6
![Page 7: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/7.jpg)
Accordion By Row Demo
Copyright 2007, Information Builders. Slide 7
![Page 8: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/8.jpg)
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
Copyright 2007, Information Builders. Slide 8
![Page 9: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/9.jpg)
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
![Page 10: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/10.jpg)
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 formatsHTML / EXL2K / EXL07
Copyright 2007, Information Builders. Slide 10
![Page 11: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/11.jpg)
Hide Null Across Columns Standard HTML Across Report (DEFAULT)
Copyright 2007, Information Builders. Slide 11
![Page 12: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/12.jpg)
Hide Null Across Columns HTML Across Report with SET HIDENULLACRS = ON
Copyright 2007, Information Builders. Slide 12
![Page 13: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/13.jpg)
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
Copyright 2007, Information Builders. Slide 13
![Page 14: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/14.jpg)
EXL2KTXTDATE: TEXT vs VALUE
Copyright 2007, Information Builders. Slide 14
![Page 15: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/15.jpg)
Control the “FOCUS” UnderlineSET TITLELINE = {ON|OFF|SKIP}
FOCUS Underline inserted in PDF, PPT, PS & DHTML
Copyright 2007, Information Builders. Slide 15
![Page 16: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/16.jpg)
Controlling the “FOCUS” Underline
Copyright 2007, Information Builders. Slide 16
SET TITLELINE=OFFTABLE FILE GGSALESSUM GGSALES.SALES01.UNITS GGSALES.SALES01.DOLLARSBY LOWEST GGSALES.SALES01.CATEGORYBY LOWEST GGSALES.SALES01.PRODUCTON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTALON TABLE PCHOLD FORMAT PDFON TABLE SET HTMLCSS ONON TABLE SET STYLE *$TYPE=REPORT, FONT='TREBUCHET MS', SIZE=10, COLOR='BLACK', STYLE=BOLD,$ENDSTYLEEND
![Page 17: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/17.jpg)
Controlling the “FOCUS” Underline
Copyright 2007, Information Builders. Slide 17
SET TITLELINE=SKIPTABLE FILE GGSALESSUM GGSALES.SALES01.UNITS GGSALES.SALES01.DOLLARSBY LOWEST GGSALES.SALES01.CATEGORYBY LOWEST GGSALES.SALES01.PRODUCTON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTALON TABLE PCHOLD FORMAT PDFON TABLE SET HTMLCSS ONON TABLE SET STYLE *$TYPE=REPORT, FONT='TREBUCHET MS', SIZE=10, COLOR='BLACK', STYLE=BOLD,$ENDSTYLEEND
![Page 18: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/18.jpg)
Move the Across Titles (PDF Only)SET ACROSSTITLE={ABOVE/SIDE}
Copyright 2007, Information Builders. Slide 18
SET ACROSSTITLE = SIDETABLE FILE GGSALESSUM UNITSBY REGIONACROSS CATEGORYACROSS PRODUCTWHERE CATEGORY NE 'Gifts';ON TABLE PCHOLD FORMAT PDFON TABLE SET STYLE * BORDER=LIGHT, FONT='TREBUCHET MS', SIZE=10, $ENDSTYLEEND
ABOVE
SIDE
![Page 19: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/19.jpg)
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
Copyright 2007, Information Builders. Slide 19
![Page 20: Jenny Lalik](https://reader030.vdocuments.us/reader030/viewer/2022012904/568163bf550346895dd4dfc1/html5/thumbnails/20.jpg)
Thank You
For more help visithttp://techsupport.informationbuilders.com/
Copyright 2007, Information Builders. Slide 20