Jenny lalik
Download
1 / 19

Jenny Lalik - PowerPoint PPT Presentation


  • 65 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Jenny Lalik' - conor


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Jenny lalik

Jenny Lalik

Tips n Techniques


Report styling enhancements for 7 7
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
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.


Accordion by row set expandbyrow on off all n
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


Accordion by row styling features not supported
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.



Excel 2007 output format exl07 production in release 7 7 02
Excel 2007 Output Format (EXL07)Production in Release 7.7.02

  • Excel 2007 Workbooks & Templates

    • Core Styling Features

    • Templates

      • From .MHT to .XLTX


What webfocus generates for format exl07
What WebFOCUS generates for FORMAT EXL07

  • Workbooks - .XLSX

    • XML component files define the workbook characteristics

  • Zipped into single binary .XLSX file

    • Done by JAVA layer

      • WebFOCUS Client (Servlet) – default

      • Reporting Server (JSCOM) – supports secured servers

    • Define location in

      • WebFOCUS Administration Console (IBIF_excelservurl)

      • in FEX with SET EXCELSERVURL

  • Workbooks based on Templates

    • based on Excel 2007 .XLTX template files

    • Supports native Excel 2007 formulas, tables, graphs, images, cell formatting.


Hide null across columns set hidenullacrs on off
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


Hide null across columns standard html across report default
Hide Null Across Columns Standard HTML Across Report (DEFAULT)


Hide null across columns html across report with set hidenullacrs on
Hide Null Across Columns HTML Across Report with SET HIDENULLACRS = ON


Exl2k dates as formatted values or text set exl2ktxtdate text value
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



Control the focus underline set titleline on off skip
Control the “FOCUS” UnderlineSET TITLELINE = {ON|OFF|SKIP}

  • FOCUS Underline inserted in PDF, PPT, PS & DHTML


Controlling the focus underline
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


Controlling the focus underline1
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


Move the across titles pdf only set acrosstitle above side
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


Multidrill control file for colors fonts
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


Thank you
Thank You

For more help visit

http://techsupport.informationbuilders.com/


ad