[SOLVED] Error while using multi verb(SUM,PRINT) with OVER command
Hi,
I have to create a report in form display style along with 2 fields in tabular format(multiple rows for 2 fields and all other columns value will be only one )
The report will look like,
-------------------------------------------- Heading1 company name Heading2 Report Name Heading3 Project Number Heading4 Page No. -------------------------------------------- Project Data ============ (Form display with SUM verb and OVER command)
Status : Closed Start Date : 01/01/2001 End Data : 12/12/2004
Project Team ============= (Tabular display with PRINT verb)
Project Manager : Johney Joseph Client Contact : Jaison Security Rep : Dizusa Real Estate Mgr : Karthik
I have used the OVER to the columns other than project Data. The project data is actually coming from only 2 fields as "Position" and "Name" in database. More clearly , the 4 positions and 4 names in the above example are coming as the data of 2 columns in the table, as "position" and "name" against the inputed project number (WHERE). To achieve this tried to use SUM command to the columns other than Project Data and PRINT command to the position and Name (Project Data). But if I use OVER command for SUM along with the PRINT , I am getting the error "WEBFOCUS request statement with more than one verb" . Is there any other method I can solve the issue?
Attaching my sample code,
SET CENT-ZERO = ON
SET EMPTYREPORT = ON
SET NODATA = ' ';
-SET &ECHO=ALL ;
SET CSSURL=http://ddgdmk6.fmr.com:51000/approot/dg_code/csty.css
-DEFAULT &P_PRG_NUM='12543'
-DEFAULT &FMT ='HTML'
DEFINE FILE PROJ
PROJDATA/A30 = '';
END
TABLE FILE PROJ
SUM
PROJDATA AS 'Project Data ' OVER
STATUS AS 'Status' OVER
START_DATE AS 'Start Date' OVER
COMPLETION_DATE AS 'End Date' OVER
PROJDATA AS 'Project Team' OVER
PRINT
POSITION AS ' '
NAME AS ' '
HEADING
"XXXXX Company"
"Project Report"
"Project Number 12543"
WHERE PROJECT_NUMBER EQ '&P_PRG_NUM';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
STYLES .......
Thanks and regards, Johney Joseph.This message has been edited. Last edited by: Kerry,
Version 7.6.11 Webfocus installed in AIX 5.3, desktop PC: Windows-XP based Output: Excel, HTML, PDF
October 14, 2008, 06:50 AM
<JG>
Sorry it's not possible to use OVER any where other than the last part of a multi-verb request. (basic restriction)
For what you are doing though all you need is a subhead
DEFINE FILE PROJ PROJDATA/A30 = ''; END TABLE FILE PROJ PRINT POSITION AS ' ' NAME AS ' ' BY PROJECT_NUMBER NOPRINT ON PROJECT_NUMBER SUBHEAD "Project Data "Status "Start Date "End Date "Project Team HEADING "XXXXX Company" "Project Report" "Project Number WHERE PROJECT_NUMBER EQ '&P_PRG_NUM'; etc.