Focal Point
[SOLVED] Subhead ? or bust ?

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3947056626

November 28, 2012, 11:42 AM
Tomsweb
[SOLVED] Subhead ? or bust ?
I have created a splash page showing Work Orders which were opened in the last 30 days.
There are two kinds here, CUSTOMER WORK ORDERS and just WORK ORDERS.

Here is the report as it is coded now:

quote:

OPEN WORK ORDER FOR LAST <= 30 DAYS
CUSTOMER ORDERS AND WORK ORDERS
DATE: November 28, 2012

WDC WORKDESC COUNT

OPEN CUSTOMER WORK ORDERS

058 REINSPECT FOR SERVICE LEAK 4
303 CURB STOP INOPERABLE 2

OPEN WORK ORDERS

303 CURB STOP INOPERABLE 5
058 REINSPECT FOR SERVICE LEAK 2
258 LOCATE/ADJUST VALVE BOX 2


Here is the code for it:

 
DEFINE FILE SPL2                                               
DLT/A2 = '<=';                                                 
ASGST/A30 = IF ASSIGNEE EQ 'SM06' THEN 'OPEN CUSTOMER ORDERS'  
				ELSE 'OPEN WORK ORDERS';     
END

TABLE FILE SPL2 
" OPEN WORK ORDER FOR LAST <DLT 30 DAYS "
" CUSTOMER ORDERS AND WORK ORDERS "
" DATE: &DATEMtrDYY "
" "
SUM SWDC
BY ASGST NOPRINT
BY HIGHEST SWDC NOPRINT
BY ASSIGNEE NOPRINT
BY WDC
BY WORKDESC
ON ASGST SKIP-LINE SUBHEAD
" "
" <ASGST     "
ON TABLE SET PAGE NOPAGE
END
-RUN
 


I am trying to reformat it to look like this:

quote:

OPEN WORK ORDER FOR LAST <= 30 DAYS
CUSTOMER ORDERS AND WORK ORDERS
DATE: November 28, 2012

OPEN CUSTOMER WORK ORDERS

WDC WORKDESC COUNT
058 REINSPECT FOR SERVICE LEAK 4
303 CURB STOP INOPERABLE 4


OPEN WORK ORDERS

WDC WORKDESC COUNT
303 CURB STOP INOPERABLE 5
058 REINSPECT FOR SERVICE LEAK 2
258 LOCATE/ADJUST VALVE BOX 2


I have been looking through the doc and I cannot find an example for something like this.

Has anyone tried this?

Thanks.

This message has been edited. Last edited by: Tomsweb,


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
November 28, 2012, 12:31 PM
Norb Eckert
Why don't you do a compound report? Split the report into 2 runs and combine it together?


prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9
November 28, 2012, 12:59 PM
Tomsweb
I am actually trying that as we speak.


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
November 28, 2012, 01:11 PM
Tomsweb
Can a compound report be created in Mainframe FOCUS 7.6.5 ?


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36