Jenny lalik
This presentation is the property of its rightful owner.
Sponsored Links
1 / 19

Jenny Lalik PowerPoint PPT Presentation


  • 38 Views
  • Uploaded on
  • Presentation posted in: General

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.

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


Accordion by row demo

Accordion By Row Demo


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


Exl2ktxtdate text vs value

EXL2KTXTDATE: TEXT vs VALUE


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/


  • Login