November 10, 2005, 06:54 PM
GregVertical 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
PrarieNot 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
GregMy 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
TerryWJust 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
KerryHi 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,
Kerry