1 / 43

WebFOCUS New Features

WebFOCUS New Features. Version 7 Release 7.03. Ira Kaplan. May 10, 2012. References. WebFOCUS New Features 7.7.03. New Features Quick View Interactive Diagram 7.7.03. http://documentation.informationbuilders.com/masterindex/docdetail.asp?docid=2775.

darcie
Download Presentation

WebFOCUS New Features

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. WebFOCUS New Features Version 7 Release 7.03 Ira Kaplan May 10, 2012

  2. References WebFOCUS New Features 7.7.03 New Features Quick View Interactive Diagram 7.7.03 http://documentation.informationbuilders.com/masterindex/docdetail.asp?docid=2775 http://documentation.informationbuilders.com/masterindex/docdetail.asp?docid=2872

  3. Active Technologies for Mobile Web Apps

  4. Full Screen View

  5. Active Report on iPad in Web App View

  6. Report Painter: Accordion Report

  7. Accordion Report

  8. Accordion Report

  9. Accordion Report Not Set

  10. Accordion Report: Off ON TABLE SET EXPANDBYROW OFF

  11. Accordion Report: Only show top level ON TABLE SET EXPANDBYROW ON

  12. Accordion Report: Only show top level Gerry says: Only show top level is identical to InfoAssist behavior ON TABLE SET EXPANDBYROW ON

  13. Accordion Report: Expand n levels [1] ON TABLE SET EXPANDBYROW 1

  14. Accordion Report: Expand n levels [2] ON TABLE SET EXPANDBYROW 2

  15. Accordion Report: Checked, Automatic Expansion… Off ON TABLE SET EXPANDABLE ON ON TABLE SET EXPANDBYROW OFF

  16. Accordion Report: Expand Everything ON TABLE SET EXPANDBYROW ALL

  17. Report Painter: Active Reports Sizing a Grid Component with Respect to its Container

  18. Active Report Size Is Not Bounded by Container

  19. Active Report Size Is Bounded by Container

  20. Document Composer Respects Style Settings

  21. Document Composer Respects Style Settings Gerry says: Ignore the scroll bars where ARREPORTSIZE = FLOWING. Will not appear on output.

  22. Active Report Size: LINES-PER-PAGE

  23. InfoAssist

  24. Dynamic Reference Line

  25. Dynamic Reference Line , continued Where do I find it?

  26. Developer Studio Enhancements

  27. Empty Report: The Report

  28. Empty Report: The Report

  29. Empty Report: OFF

  30. Empty Report: ON

  31. Empty Report: ANSI

  32. Empty Report Controlling Output When TABLE Request Retrieves Zero Records • ANSI • Produces a single-line report and displays the missing data character or a zero if a COUNT is requested. In each case, &RECORDS will be 0, and &LINES will be 1. • If the SQL Translator is invoked, ANSI automatically replaces OFF as the default setting for EMPTYREPORT. • ON • Produces an empty report (column headings with no content). This was the default behavior in prior releases. • OFF • Produces no report output. OFF is the default value except for SQL Translator requests. ANSI replaces OFF as the default setting for the EMPTYREPORT parameter, so the results are the same as for the ANSI setting.

  33. Server Enhancements

  34. App Move Move the entire contents of one application to another. APP MOVE app1[/app1a...] app2[/app2a...] APP PATH ibisampibidemouser_forum_originalAPP CREATE user_forum_movedAPP MOVE user_forum_originaluser_forum_moved app1 is the source app2 is the destination (must be created first) Nested applications are supported APP MOVE is destructive, deletes source application May use APP COPY to retain source application

  35. Reporting Language Enhancements

  36. LCWORD3 LCWORD3(length, string, output) The LCWORD3 function converts the letters in a character string to mixed-case by converting the first letter of each word to uppercase and converting every other letter to lowercase. In addition, a single quotation mark indicates that the next letter should be converted to uppercase as long as it is neither followed by a blank nor the last character in the input string.

  37. LCWORD3 Example LCWORD3(length, string, output) DEFINE FILE EMPLOYEE MYVAL1/A10='O'CONNOR'S'; MYVAL2/A10='o'connor's'; LC1/A10 = LCWORD3(10, MYVAL1, 'A10'); LC2/A10 = LCWORD3(10, MYVAL2, 'A10'); END TABLE FILE EMPLOYEE SUM LAST_NAME NOPRINT MYVAL1 LC1 MYVAL2 LC2 END MYVAL1 LC1 MYVAL2 LC2 ------ --- ------ --- O'CONNOR'S O'Connor's o'connor's O'Connor's

  38. Retrieving the Current Date in Any Valid Format Date-Time Value, too Dialog Manager Technique {&DATE|&DATX}fmt &DATE Keeps trailing blanks &DATEX Drops trailing blanks Fmt Any valid date or date-time format

  39. &DATE Examples -TYPE DATE = &DATE -TYPE MDYY = &DATEMDYY -TYPE YYM = &DATEYYM -TYPE MDY = &DATEMDY -TYPE YYQ = &DATEYYQ -TYPE MBDBYY = &DATEMBDBYY -TYPE YYMtr = &DATEYYMtr -TYPE HYYMDS = &DATEHYYMDS DATE = 05/09/11 MDYY = 05/09/2011 YYM = 2011/05 MDY = 05/09/11 YYQ = 2011 Q2 MBDBYY = 05 09 2011 YYMtr = 2011, May HYYMDS = 2011/05/09 14:06:26

  40. Subtotals Below the Line (Default) TABLE FILE CAR PRINT CAR.CARREC.MODEL CAR.BODY.SALES BY LOWEST CAR.ORIGIN.COUNTRY BY LOWEST CAR.COMP.CAR ON CAR.ORIGIN.COUNTRY SUBTOTAL AS '*TOTAL' ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ ENDSTYLE END

  41. Subtotals Above the Line SET SUBTOTALS = ABOVE TABLE FILE CAR PRINT CAR.CARREC.MODEL CAR.BODY.SALES BY LOWEST CAR.ORIGIN.COUNTRY BY LOWEST CAR.COMP.CAR ON CAR.ORIGIN.COUNTRY SUBTOTAL AS '*TOTAL' ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ ENDSTYLE END

  42. Thank you

More Related