×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Formatting the view/output of report

Formatting the view/output of report

Formatting the view/output of report

(OP)
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.

RE: Formatting the view/output of report

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

Option 1: Put it in a heading

TABLE FILE MYFILE
"FIELD1: <KOUNT1"
"FIELD2: <KOUNT2"
"FIELD3: <COUNT3"
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'
...

RE: Formatting the view/output of report

(OP)
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

RE: Formatting the view/output of report

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close