180 likes | 347 Views
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
E N D
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
WebFOCUS USF User Meeting Accordion Reports - Automatic • Automatically controlled by SET command • Only in HTML. • SET EXPANDBYROW = ON • Expands downward – columns all line up
WebFOCUS USF User Meeting Accordion Reports - Automatic • Choose to do a Set from the Procedure Viewer
WebFOCUS USF User Meeting Accordion Reports - Manual • Can specify specific roll ups at each sort level • Only in HTML reports • Expands to the right
WebFOCUS USF User Meeting Accordion Reports - Manual • In Report Painter, Report Options panel, Features tab
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
WebFOCUS USF User MeetingFreeze Titles • Freeze Titles (or Footings) • Only in HTML
WebFOCUS USF User MeetingFreeze Titles • In Report Options panel, Features tab
WebFOCUS USF User MeetingFreeze Columns • Freeze Columns • Only in Active HTML reports
WebFOCUS USF User MeetingFreeze Columns • In Report Options panel, Format tab • Select column to freeze on
WebFOCUS USF User MeetingActive Report HTML5 • Only in Active HTML Report • In Report Painter, Report Options panel, Features tab
WebFOCUS USF User MeetingActive Report HTML5 • Supported in all up to date browsers
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)
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
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
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
WebFOCUS USF User MeetingQuestions? The End Questions? Thank you!