Hi there, newbie here!
All of our reports have the column headers going left to right (as do all the examples I've seen and somewhat understand)... but what if I want some of the columns below eachother?

For example a report print out looks something like:
___________________________________________________________
A Report About Cars
CAR Location: SHOP
CAR Issue: OIL CHANGE
TOT#_CARS TOT#_$$s TOT#_HONDAS TOT#_HONDA$$s TOT#_JAGUARS TOT_JAGUARS$$s TOT#_MERCURY TOT#_MERCURY$$s

_____________________________________________________________
...on and on one (1) line.

It should look like:
___________________________________________________________
A Report About Cars
CAR Location: SHOP
CAR Issue: OIL CHANGE

Total# Total $$s
TOT#_CARS TOT#_$$s
TOT#_HONDAS TOT#_HONDA$$s
TOT#_JAGUARS TOT_JAGUARS$$s
TOT#_MERCURY TOT#_MERCURY$$s
_____________________________________________________________

So there would be two (2) columns.
Please help!

lol I'm being baptised by FIRE in this stuff at work, ANY help would be extremely appreciated.
Thank you, Thank You, Thank You.

This message has been edited. Last edited by: Kerry,

Welcome to the forum Shawna,



Have a look at the command OVER, this may help.

Other commands to check out would be SUBHEAD or SUBFOOT.

TABLE FILE CAR
PRINT COUNTRY AS 'Country:'
OVER  CAR     AS 'Car:'
END

I would suggest getting a copy of the documentation.

Also this search link may help.

Make sure that you do your homework before asking questions, and can you update your signature, you state WebFOCUS 7, this covers a large range of versions, and knowing which one you are one will help. Adding your OS as well will help.

This message has been edited. Last edited by: Waz,

Thank You so much Waz - that worked!!
I also really, really appreciate the link to documentation. I am updating my signature and WebFOCUS stuff on here as well as you've pointed out.

While that did work for my fields, I'm finding I can't change the positioning of a Subhead on a BY field to line up properly with the other columns.

ToT# TOT_$$s
________TOT#CARS
________TOT#_HONDAS
________ TOT#_JAGUARS

Also, for some reason once I added the OVER commands I can no longer view the report as a PDF, only HTML.

This message has been edited. Last edited by: Shawna,

Shawna,
try a search on HEADALIGN=BODY to align the subheadings.

ERINP

HEADALIGN does not work in ADOBE(PDF) in 7.6.7. May work now inthe 7.7 releases, don't know. For 7.6.x releases, you need to style with POSITION=COLUMN_NAME,$

Thanks everyone so much for all the help.
ERINP and Tom - unfortunately both of those didn't work for me (I looked up all the documentation available online).

But I was able to fix both issues:
Report opens as HTML but no longer PDF- I copy/pasted all code into a new fex and it worked. Replicated issue by opening up multiple instances of the fex, saving one and closing, then closing the others.

Formatting Columns that utilize the OVER command: From Report Painter go into 'Options' on each individual column and key in a width, column name width does play a large role in setting this and not all values will be the same. Formatting all columns (15ish) took about 20 minutes.


Thanks again!
-Shawna