Formatting the view/output of report

[pvuppa1]

Can anyone tell me how to change the view of my report from
field1 field2 field3 field4
value1 value2 value3 value4
to something like this
field1 value1
field2 value2
field3 value3
field4 value4
I know it sounds stupid but, im fairly new to webfocus.
My fex is as follows, all my fields are record counts for some parameter query.
DEFINE FILE MYFILE

TABLE FILE MYFILE
SUM
KOUNT1 AS 'Field1'
KOUNT2 AS 'Field2'
KOUNT3 AS 'Field3'
KOUNT4 AS 'Field4'

Please help..Everything works fine now but I need to change the display.

 

[gizzy17]

There are a couple of ways that you could do this.

Option 1: Put it in a heading

TABLE FILE MYFILE
&quot;FIELD1: <KOUNT1&quot;
&quot;FIELD2: <KOUNT2&quot;
&quot;FIELD3: <COUNT3&quot;
BY SORTFIELD PAGE-BREAK


Option 2: Use the OVER command

TABLE FILE MYFILE
SUM AFIELD 'TEXT OVER TEXT'
OVER KOUNT1 AS 'FIELD1'
OVER KOUNT2 AS 'FIELD2'
OVER KOUNT3 AS 'FILED3'
...

 

[pvuppa1]

Hi gizzy,
Thanks for ur reply, it works within the heading i mean option1 but when i try using OVER command it dint work. IS it SUM AFIELD 'TEXT OVER TEXT'
OVER KOUNT1 AS 'FIELD1'
.....
or am i missing something?
Thanks again

 

[gizzy17]

Using option 2, you will have the first field show with a title over the field value as with any request. This could also be considered your first line. You can remove this line by using the NOPRINT command.

Try this --

TABLE FILE CAR
PRINT CAR NOPRINT
OVER COUNTRY AS 'Country:'
OVER MODEL AS 'Model:'
OVER SEATS AS 'Seats:'
BY COUNTRY NOPRINT
BY MODEL NOPRINT
END