Focal Point
Removing page-breaks in a table request
September 25, 2008, 11:52 AM
Mighty MaxRemoving page-breaks in a table request
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
WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
September 25, 2008, 12:06 PM
GinnyJakesThere 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.
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
September 25, 2008, 12:10 PM
SyedMax
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
Using WF 7.1.7/Dev Studio
September 25, 2008, 12:31 PM
Francis MarianiFor 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.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 25, 2008, 12:59 PM
Mighty MaxWell 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.
WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
September 25, 2008, 01:13 PM
TexasStingrayAnother option is to set it to landscape and page size to something like LEGAL or 11x17
Scott
September 25, 2008, 01:16 PM
GinnyJakesMax,
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.
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
September 26, 2008, 09:18 AM
Mighty MaxTo 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
WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
September 26, 2008, 10:01 AM
Tony AIf your printer supports different page sizes then you could always up it to PAGESIZE=A3 with ORIENTATION=LANDSCAPE as you already have.
T
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | | |
WebFOCUS App Studio 8.2.06 standalone on Windows 10 | |