430 likes | 744 Views
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.
E N D
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 http://documentation.informationbuilders.com/masterindex/docdetail.asp?docid=2872
Accordion Report: Off ON TABLE SET EXPANDBYROW OFF
Accordion Report: Only show top level ON TABLE SET EXPANDBYROW ON
Accordion Report: Only show top level Gerry says: Only show top level is identical to InfoAssist behavior ON TABLE SET EXPANDBYROW ON
Accordion Report: Expand n levels [1] ON TABLE SET EXPANDBYROW 1
Accordion Report: Expand n levels [2] ON TABLE SET EXPANDBYROW 2
Accordion Report: Checked, Automatic Expansion… Off ON TABLE SET EXPANDABLE ON ON TABLE SET EXPANDBYROW OFF
Accordion Report: Expand Everything ON TABLE SET EXPANDBYROW ALL
Report Painter: Active Reports Sizing a Grid Component with Respect to its Container
Document Composer Respects Style Settings Gerry says: Ignore the scroll bars where ARREPORTSIZE = FLOWING. Will not appear on output.
Dynamic Reference Line , continued Where do I find it?
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.
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
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.
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
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
&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
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
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