WEBFOCUS COLUMN-TOTAL

[Zynar]

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]

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]

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.