Focal Point
Vertical Field Placement

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

November 10, 2005, 06:54 PM
Greg
Vertical Field Placement
Is there a way using the report painter to have the fields run down the left side of the page rather than the default placement of horizontal across the top?
November 10, 2005, 08:17 PM
Prarie
Not sure how to do it in Report Painter...but in the Text Editor you can use "OVER"

TABLE FILE CAR
PRINT CAR OVER
BODY
END

This will put the fields on the left side of the page one after another.
November 11, 2005, 01:33 PM
Greg
My header looks like this:

TABLE FILE TDT_RETN
PRINT
RETGROSS
RETEXEMPT
RETAXABLE
BY ACCOUNT CODE
HEADING

If I change the PRINT line to
PRINT TDT_RETN OVER (using TDT_RETN instead of CAR)

I get an error when running the report:

TDT_RETN Field not recognized. TDT_RETN is the name of the table used in the .mas file.

Sorry if this is dumb question, but I am really new at Webfocus and no nothing about the Focus language.

Is CAR a table name or a focus command?
November 11, 2005, 01:33 PM
TerryW
Just a minor syntax error, try this:

TABLE FILE TDT_RETN
PRINT RETGROSS OVER
RETEXEMPT OVER
RETAXABLE
BY ACCOUNT CODE
November 18, 2005, 04:08 PM
Kerry
Hi Greg,

Have you got a chance to try Terry's suggestion? Did the code resolve the issue?

CAR is not a FOCUS command. It is a sample table that Information Builders provides along with the product for testing purpose. There are some other files of the same property, e.g. EMPDATA, MOVIES, etc. For people who don't have a particular database to work with, the CAR file can be treated as a mini-database to test the procedure coded in FOCUS.

Hope this info helps.

Cheers, Big Grin

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.