Transcript Slide 1

WebFOCUS New Features
Version 7 Release 7.03
April 20, 2012
Ira Kaplan
1
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
2
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 ibisamp ibidemo
user_forum_originalAPP CREATE
user_forum_movedAPP MOVE
user_forum_original user_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
-----O'CONNOR'S
LC1
--O'Connor's
MYVAL2
-----o'connor's
LC2
--O'Connor's
38
Retrieving the Current Date in Any Valid Format
Date-Time Value, too
Dialog Manager Technique
{&DATE|&DATX}fmt
&DATE
&DATEX
Fmt
Keeps trailing blanks
Drops trailing blanks
Any valid date or date-time format
39
&DATE Examples
-TYPE
-TYPE
-TYPE
-TYPE
-TYPE
-TYPE
-TYPE
-TYPE
DATE = &DATE
MDYY = &DATEMDYY
YYM = &DATEYYM
MDY = &DATEMDY
YYQ = &DATEYYQ
MBDBYY = &DATEMBDBYY
YYMtr = &DATEYYMtr
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
Thank you
41