Focal Point
Wide report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4071086513

January 28, 2009, 11:58 AM
Noel
Wide report
We have a wide report and our output is to HTML. Is it possible in web focus to have multiple lines per record when we generate the HTML page? Meaning 1 record will be shown in 2 to 3 lines in the html page.

thanks in advance


WebFocus 762 AS400 / DB2
January 28, 2009, 12:04 PM
RSquared
Sure, just user the OVER command.

PRINT
FIELD1
FIELD2
... OVER
FIELD10 ..

This will give you multiple lines per record


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
January 28, 2009, 02:38 PM
FrankDutch
Noel

The solution highly depends on the type of fields you want to display.
If they are all D12.2 the over will work well but if it is mixed character and numeric.....
You can create two or three long lines (new fields) put the several values together into those lines add a line number and print them.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7