Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Subhead ? or bust ?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Subhead ? or bust ?
 Login/Join
 
Master
posted
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
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 242 | Location: Minneapolis | Registered: February 16, 2006Report This Post
Master
posted Hide Post
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
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report This Post
Master
posted Hide Post
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
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Subhead ? or bust ?

Copyright © 1996-2020 Information Builders