I've searched this forum and documentation, but haven't been able to figure out how to create a column in my output with the same value for every row. I know how to do this in SQL, but not in WebFocus.

Here's what I currently have:

 
DEFINE FILE NEW_REPORT
Count/I1=ABS(1);
END
TABLE FILE NEW_REPORT

SUM
   CNT.Count AS 'Count'
....
 

We tried:
1 AS 'Count'
and got an error. Any suggestions?

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

Hi,

Maybe try a PRINT instead of COUNT.

Best Regards,

Jimmy Pang

That worked!

For future reference, here is the line I used:

 PRINT CNT.Count AS 'Count' 

Thanks!
Theresa