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
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,
WebFOCUS 7.6.7 WIN XP Excel, PDF, HTML
October 19, 2011, 04:53 PM
Waz
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.
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,
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 20, 2011, 10:39 AM
Shawna
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.
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,
WebFOCUS 7.6.7 WIN XP Excel, PDF, HTML
October 20, 2011, 11:02 AM
ERINP
Shawna, try a search on HEADALIGN=BODY to align the subheadings.
ERINP
WebFOCUS 7.6.9
Reporting client Windows 2003 Service pack 2 using IIS and TomCat 5.5 Reporting Server OS/400 V5R4M0 Outputs: HTML, Excel, PDF, CSV, and Flat Files
October 20, 2011, 02:37 PM
Tom Flynn
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.