Case: 32261090 Product: MF Release: 706 Primary OS: MVS Date: 98/08/24
Case information refers to the Product, Release, and OS for which this question was asked. The solution may apply to other Products, Releases, and Operating Systems.
Symptom:
How to print a report that will contain...
Put a trailing comma at the end of each
title to suppress under-lines under the
headers.
TABLE FILE CAR
PRINT TYPE AS 'Type,'
BY COUNTRY AS 'Country,'
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF, $
ENDSTYLE
END
I goofed...try this (or something like it) instead.
TABLE FILE CAR
SUM TYPE
BY COUNTRY
ON COUNTRY PAGE-BREAK
ON TABLE HOLD
END
-RUN
DEFINE FILE CAR ADD
TPAGE/I6 = &LINES;
END
SET PAGE=OFF
TABLE FILE CAR
HEADING
"<TABPAGENO OF <TPAGE PAGES"
PRINT TYPE
BY COUNTRY
ON COUNTRY PAGE-BREAK
END
TABLE FILE CAR
PRINT TYPE
BY COUNTRY
ON COUNTRY PAGE-BREAK
ON TABLE HOLD
END
-RUN
DEFINE FILE CAR ADD
TPAGE/I6 = &RECORDS;
END
SET PAGE=OFF
TABLE FILE CAR
HEADING
"<TABPAGENO OF <TPAGE PAGES"
PRINT TYPE
TPAGE
BY COUNTRY
ON COUNTRY PAGE-BREAK
END
Why are you doing the define after the TABLE FILE request?
This is code that I used to populate a drop down box.
DEFINE FILE COMPANY
OPTCOMPANY/A80 = '<OPTION VALUE="' | CMPY_NUMBER || '">' | CMPY_NAME;
END
TABLE FILE COMPANY
SUM OPTCOMPANY
BY CMPY_NAME NOPRINT
&COMPWHER
WHERE...
Syntax: How to Specify a Base URL
SET BASEURL=url where:
url
Is the fully-qualified directory in which additional HTML files, graphics files, and Java applet CLASS files reside. The URL must begin with http:// and end with a closing delimiter (/).
Example: Specifying a Base URL
The...
Try setting the FONT size smaller via stylesheet commands.
ON TABLE SET STYLE *
TYPE=REPORT, SIZE=9,GRID=OFF, LEFTMARGIN=.25, RIGHTMARGIN=.25, FONT=COURIER, $
ENDSTYLE
DEFINE FILE CAR
SUBA/I6 = 55;
SUBB/I6 = 75;
END
TABLE FILE CAR
PRINT SUBA
SUBB
COMPUTE PCT/D6.2 = ((SUBB - SUBA)/SUBB) * 100;
BY COUNTRY
ON COUNTRY RECOMPUTE
ON COUNTRY SUB-TOTAL
IF RECORDLIMIT EQ 5
END
Returns
PAGE 1
COUNTRY SUBA SUBB PCT
ENGLAND 55 75 26.67
*TOTAL...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.