I'm just pulling some test records to get a feel of the data for my report.
The table I am looking at has around 50 columns.
Let's say that I only want to look at a test set of 5 records.
Is there a way to print this to only one page in a PDF?
Something like ON TABLE NOSPLIT???

Here is the car file example I was playing with.

  
TABLE FILE CAR
PRINT 
          COUNTRY
	 CAR
	 MODEL 
	 DEALER_COST
	 RETAIL_COST
	 COUNTRY
	 CAR
	 MODEL 
	 DEALER_COST
	 RETAIL_COST
	 COUNTRY
	 CAR
	 MODEL 
	 DEALER_COST
	 RETAIL_COST
	 COUNTRY
	 CAR
	 MODEL 
	 DEALER_COST
	 RETAIL_COST
	 COUNTRY
	 CAR
	 MODEL 
	 DEALER_COST
	 RETAIL_COST
WHERE RECORDLIMIT EQ 5
-* Is there some syntax for this?
-* ON TABLE NOSPLIT
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='LEGAL',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.250000,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=ON,
     FONT='ARIAL',
     SIZE=6,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=TITLE,
     STYLE=BOLD,
$
ENDSTYLE
END

-EXIT

Regards,
Max

There are a number of things you can do.

1. You can make the font smaller.
2. If the titles are longer than the data, you can us AS to rename the column.
3. You could try OVER
4. You can leave it two pages and use BYPANEL to repeat the BY phrases on the second page.

I'm sure some other folks have other ideas for you as well.

Max
I'm not sure why would you need that! If you want all the columns without the columns getting split-up, you might want to use HTML, or Excel formats.
If you really need it in a PDF, you might want to append the columns one on top of the other. Something like:

FILEDEF TEMP_CAR DISK TEMP_CAR.FTM (APPEND
-RUN

TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
DEALER_COST
RETAIL_COST
COUNTRY
ON TABLE HOLD AS TEMP_CAR FORMAT ALPHA
END

TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
DEALER_COST
RETAIL_COST
COUNTRY
ON TABLE HOLD AS TEMP_CAR FORMAT ALPHA
END

TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
DEALER_COST
RETAIL_COST
COUNTRY
ON TABLE HOLD AS TEMP_CAR FORMAT ALPHA
END

TABLE FILE TEMP_CAR
PRINT *
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='LEGAL',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=ON,
FONT='ARIAL',
SIZE=6,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=TITLE,
STYLE=BOLD,
$
ENDSTYLE
END

Well....in this case, you'll need to have all the corresponding columns with same datatypes (which is a pre-req for APPEND).

Hope this helps.

Rock On!
Syed

For PDF reports you can reduce the gap between columns and you can reduce the width of the columns.

I added this to the TYPE=REPORT declaration:

LEFTGAP=0.00, RIGHTGAP=0.00,

and this for the MODEL column:

TYPE=REPORT, COLUMN=MODEL, WRAP=0.5, $

and your report now fits on one page.

Well the user wants me to modify an existing report that meets certain criteria.
I'm just sampling the data to see if the reationships exist in order to meet the users criteria.
My output is like eight pages so I wanted to condense it down so I could better see the relationships.

Another option is to set it to landscape and page size to something like LEGAL or 11x17

Max,

I often do the same thing. Several suggestions have been made and you can use many of them in combination.

Also remember, you don't necessarily have to print all the columns to see the data relationships.

Let us know if our suggestions work for you.

To analyze the data I basically reduced the amount of columns, decreased the font size, and used orientation landscape and paper size legal.
But I wish there was a feature or setting that would allow the table to wrap on the first page and not stretch into multiple pages.
Oh well, you can't always get what you want.

Thanks Everybody,
Max

If your printer supports different page sizes then you could always up it to PAGESIZE=A3 with ORIENTATION=LANDSCAPE as you already have.

T