WEBFOCUS COLUMN-TOTAL

Zynar · Apr 16, 2008

Can anyone tell me how to prevent line wrap with the 'ON TABLE COLUMN-TOTAL AS ' clause in a report request.
It is a simple report request, using the PRINT command. The total line showss as follows:
TOTALS:
999.99 999.99 999.99
I've also tried the SUMMARIZE key word.

jimster06 · Apr 17, 2008

This is a well-known issue with FOCUS and WebFOCUS. You can address it by defining a blank one-byte field and doing your major sort on it. Then
ON MYBLANKFLD COLUMN-TOTAL AS '

HTH

focwizard · Apr 22, 2008

The REASON, by the way, is that the product has to allow for the MAXIMUM possible width of each column (we don't know how large the totals will be). Since we ALSO need the total literal (*TOTAL or whatever you use), to avoid overlaying data, we move the totals down one line.

Another way to resolve this issue, is to add a 'dummy' sort field, with values of blank, after your real sort field. This effectively moves the data to the right, allowing the total literal to fit on the line with the totals.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

WEBFOCUS COLUMN-TOTAL

Zynar

Programmer

jimster06

Programmer

focwizard

Vendor

Similar threads

Part and Inventory Search

Sponsor