Download - WebFOCUS New Features
![Page 1: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/1.jpg)
April 20, 2012
Version 7 Release 7.03
Ira Kaplan
WebFOCUS New Features
1
![Page 2: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/2.jpg)
References
2
http://documentation.informationbuilders.com/masterindex/docdetail.asp?docid=2775
http://documentation.informationbuilders.com/masterindex/docdetail.asp?docid=2872
New Features Quick View Interactive Diagram 7.7.03
WebFOCUS New Features 7.7.03
![Page 3: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/3.jpg)
3
![Page 4: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/4.jpg)
Active Technologies for Mobile Web Apps
4
![Page 5: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/5.jpg)
Full Screen View
5
![Page 6: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/6.jpg)
Active Report on iPad in Web App View
6
![Page 7: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/7.jpg)
Report Painter: Accordion Report
7
![Page 8: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/8.jpg)
Accordion Report
8
![Page 9: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/9.jpg)
Accordion Report
9
![Page 10: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/10.jpg)
Accordion Report Not Set
10
![Page 11: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/11.jpg)
Accordion Report: Off
11ON TABLE SET EXPANDBYROW OFF
![Page 12: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/12.jpg)
Accordion Report: Only show top level
12ON TABLE SET EXPANDBYROW ON
![Page 13: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/13.jpg)
Accordion Report: Only show top level
13ON TABLE SET EXPANDBYROW ON
Gerry says:Only show top level is identical to InfoAssist behavior
![Page 14: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/14.jpg)
Accordion Report: Expand n levels [1]
14ON TABLE SET EXPANDBYROW 1
![Page 15: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/15.jpg)
Accordion Report: Expand n levels [2]
15ON TABLE SET EXPANDBYROW 2
![Page 16: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/16.jpg)
Accordion Report: Checked, Automatic Expansion… Off
16
ON TABLE SET EXPANDABLE ON ON TABLE SET EXPANDBYROW OFF
![Page 17: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/17.jpg)
Accordion Report: Expand Everything
17ON TABLE SET EXPANDBYROW ALL
![Page 18: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/18.jpg)
Report Painter: Active Reports
Sizing a Grid Component with Respect to its Container
18
![Page 19: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/19.jpg)
Active Report Size Is Not Bounded by Container
19
![Page 20: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/20.jpg)
Active Report Size Is Bounded by Container
20
![Page 21: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/21.jpg)
Document Composer Respects Style Settings
21
![Page 22: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/22.jpg)
Document Composer Respects Style Settings
22
Gerry says:Ignore the scroll bars where ARREPORTSIZE = FLOWING. Will not appear on output.
![Page 23: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/23.jpg)
Active Report Size: LINES-PER-PAGE
23
![Page 24: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/24.jpg)
InfoAssist
24
![Page 25: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/25.jpg)
Dynamic Reference Line
25
![Page 26: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/26.jpg)
Dynamic Reference Line , continued
26
Where do I find it?
![Page 27: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/27.jpg)
Developer Studio Enhancements
27
![Page 28: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/28.jpg)
Empty Report: The Report
28
![Page 29: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/29.jpg)
Empty Report: The Report
29
![Page 30: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/30.jpg)
Empty Report: OFF
30
![Page 31: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/31.jpg)
Empty Report: ON
31
![Page 32: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/32.jpg)
Empty Report: ANSI
32
![Page 33: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/33.jpg)
Empty Report
33
Controlling Output When TABLE Request Retrieves Zero Records
ANSIProduces 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.
ONProduces an empty report (column headings with no content). This was the default behavior in prior releases.
OFFProduces 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.
![Page 34: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/34.jpg)
Server Enhancements
34
![Page 35: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/35.jpg)
App Move
35
Move the entire contents of one application to another.
APP MOVE app1[/app1a...] app2[/app2a...]
app1 is the sourceapp2 is the destination (must be created first)
Nested applications are supported
APP MOVE is destructive, deletes source applicationMay use APP COPY to retain source application
APP PATH ibisamp ibidemo user_forum_originalAPP CREATE user_forum_movedAPP MOVE user_forum_original user_forum_moved
![Page 36: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/36.jpg)
Reporting Language Enhancements
36
![Page 37: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/37.jpg)
LCWORD3
37
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(length, string, output)
![Page 38: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/38.jpg)
LCWORD3 Example
38
LCWORD3(length, string, output)
DEFINE FILE EMPLOYEEMYVAL1/A10='O'CONNOR'S';MYVAL2/A10='o'connor's';LC1/A10 = LCWORD3(10, MYVAL1, 'A10');LC2/A10 = LCWORD3(10, MYVAL2, 'A10');ENDTABLE FILE EMPLOYEESUM LAST_NAME NOPRINT MYVAL1 LC1 MYVAL2 LC2END
MYVAL1 LC1 MYVAL2 LC2------ --- ------ ---O'CONNOR'S O'Connor's o'connor's O'Connor's
![Page 39: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/39.jpg)
Retrieving the Current Date in Any Valid Format Date-Time Value, too
39
{&DATE|&DATX}fmt
&DATE Keeps trailing blanks&DATEX Drops trailing blanksFmt Any valid date or date-time format
Dialog Manager Technique
![Page 40: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/40.jpg)
&DATE Examples
40
-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/11MDYY = 05/09/2011YYM = 2011/05MDY = 05/09/11YYQ = 2011 Q2MBDBYY = 05 09 2011YYMtr = 2011, MayHYYMDS = 2011/05/09 14:06:26
![Page 41: WebFOCUS New Features](https://reader036.vdocuments.us/reader036/viewer/2022062410/568157d3550346895dc55a97/html5/thumbnails/41.jpg)
Thank you
41