Because Everyone Makes Decisions

Developer Studio Topics and Demonstration Jeff Winters, Branch Technical Specialist

WebFOCUS USF User Meeting

 Developer Studio Topics    Accordion Reports (2 ways – automatic and manual) Freeze Titles and Columns Active Report HTML5     Suppress chart toolbar in Active charts Report Painter Controls for ‘Guided Query’ HTML Composer Chain and Line Separators HTML Composer List Box features  Move, Search and Page Copyright 2007, Information Builders. Slide 2

WebFOCUS USF User Meeting Accordion Reports - Automatic  Automatically controlled by SET command  Only in HTML.  SET EXPANDBYROW = ON  Expands downward – columns all line up Copyright 2007, Information Builders. Slide 3

WebFOCUS USF User Meeting Accordion Reports - Automatic  Choose to do a Set from the Procedure Viewer Copyright 2007, Information Builders. Slide 4

WebFOCUS USF User Meeting Accordion Reports - Manual  Can specify specific roll ups at each sort level  Only in HTML reports  Expands to the right Copyright 2007, Information Builders. Slide 5

WebFOCUS USF User Meeting Accordion Reports - Manual  In Report Painter, Report Options panel, Features tab Copyright 2007, Information Builders. Slide 6

WebFOCUS USF User Meeting Accordion Reports - Manual  Must add SUM fields multiple times for each roll up  Use Sort Groups tab to create roll up levels  This creates a ‘multi-verb’ report Copyright 2007, Information Builders. Slide 7

WebFOCUS USF User Meeting Freeze Titles  Freeze Titles (or Footings)  Only in HTML Copyright 2007, Information Builders. Slide 8

WebFOCUS USF User Meeting Freeze Titles  In Report Options panel, Features tab Copyright 2007, Information Builders. Slide 9

WebFOCUS USF User Meeting Freeze Columns  Freeze Columns  Only in Active HTML reports Copyright 2007, Information Builders. Slide 10

WebFOCUS USF User Meeting Freeze Columns  In Report Options panel, Format tab  Select column to freeze on Copyright 2007, Information Builders. Slide 11

WebFOCUS USF User Meeting Active Report HTML5  Only in Active HTML Report  In Report Painter, Report Options panel, Features tab Copyright 2007, Information Builders. Slide 12

WebFOCUS USF User Meeting Active Report HTML5  Supported in all up to date browsers Copyright 2007, Information Builders. Slide 13

WebFOCUS USF User Meeting Suppress chart toolbar in Active charts  Manually add into stylesheet:  TYPE=REPORT, AR_SHOW_MENUBAR=OFF,$  Can also change icons  ARICONSET=WHITE  Not supported in GUI (Report Painter) Copyright 2007, Information Builders. Slide 14

WebFOCUS USF User Meeting Report Painter Controls for ‘Guided Query’  In Report Painter, select all the possible BY’s for the user  Click the pull down to create the variable for the BY columns  Click on the & to create the variable  Do the same for the SUM columns Copyright 2007, Information Builders. Slide 15

WebFOCUS USF User Meeting HTML Composer Chain and Line Separators  In HTML Composer, when you import the report procedure, you can create ‘groups’ of parameters on the launch page using the Line Separator  Simply a way to logically group parameters on the launch screen – move the Line Separator up to do the grouping Copyright 2007, Information Builders. Slide 16

WebFOCUS USF User Meeting HTML Composer List Box features  In HTML Composer, right click on a list box to bring up additional controls  Move Items – lets the user move the items up and down in the list box   Paging – lets the user page through the list box Search – lets the user search in the list box Copyright 2007, Information Builders. Slide 17

WebFOCUS USF User Meeting Questions?

The End Questions?

Thank you!

Copyright 2007, Information Builders. Slide 18