Because Everyone Makes Decisions

1. Because Everyone Makes Decisions Developer Studio Topics and Demonstration Jeff Winters, Branch Technical Specialist

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

3. WebFOCUS USF User Meeting Accordion Reports - Automatic • Automatically controlled by SET command • Only in HTML. • SET EXPANDBYROW = ON • Expands downward – columns all line up

4. WebFOCUS USF User Meeting Accordion Reports - Automatic • Choose to do a Set from the Procedure Viewer

5. WebFOCUS USF User Meeting Accordion Reports - Manual • Can specify specific roll ups at each sort level • Only in HTML reports • Expands to the right

6. WebFOCUS USF User Meeting Accordion Reports - Manual • In Report Painter, Report Options panel, Features tab

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

8. WebFOCUS USF User MeetingFreeze Titles • Freeze Titles (or Footings) • Only in HTML

9. WebFOCUS USF User MeetingFreeze Titles • In Report Options panel, Features tab

10. WebFOCUS USF User MeetingFreeze Columns • Freeze Columns • Only in Active HTML reports

11. WebFOCUS USF User MeetingFreeze Columns • In Report Options panel, Format tab • Select column to freeze on

12. WebFOCUS USF User MeetingActive Report HTML5 • Only in Active HTML Report • In Report Painter, Report Options panel, Features tab

13. WebFOCUS USF User MeetingActive Report HTML5 • Supported in all up to date browsers

14. WebFOCUS USF User MeetingSuppress 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)

15. WebFOCUS USF User MeetingReport 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

16. WebFOCUS USF User MeetingHTML 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

17. WebFOCUS USF User MeetingHTML 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

18. WebFOCUS USF User MeetingQuestions? The End Questions? Thank you!