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

Footing xxxxxxx
---------------------------------------

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,

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.