May 16, 2007, 02:38 PM
MicheleSpacing in a PDF Report
I am creating a PDF report and putting all of the data in a subfoot and positioning each column in the subfoot. As a result, this particular PDF report is double spacing. Can anyone tell me how to eliminate the double spacing? I have pasted part of my code below. Thanks.
TABLE FILE WFMCD205
HEADING
"2"
"
- Inpatient "
"Utilization and Cost Trends (Admits) - Medical/Surgical/ICU Rollup"
" 1"
"<12 12MR <22 PMPM "
"<12 PMPM <21 % Increase <32 Admits/1000 <43 Cost/Admit <53 Days/1000 <63 Cost/Day"
SUM
PMPM_YR3 NOPRINT
PMPM_YR2 NOPRINT
AND COMPUTE
PMPM_PCT23/D7.1% = (PMPM_YR3 - PMPM_YR2) / PMPM_YR2 * 100; NOPRINT
ADMITS_1000_YR3 NOPRINT
CADMIT_YR3 NOPRINT
DAYS_1000_YR3 NOPRINT
CDAY_YR3 NOPRINT
BY PRODUCT_NAME NOPRINT
BY HSGSORT NOPRINT
BY HGROUP NOPRINT
WHERE SORTER EQ 1
ON HGROUP SUBFOOT
" "
FOOTING BOTTOM
"12 Month Rolling, Incurred through "Proprietary and Confidential "
"Actuarial Services - wfmcd205.pdf"
ON TABLE PCHOLD FORMAT PDF
-*ON TABLE HOLD AS WFMCD205 FORMAT PDF
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET PAGE-NUM OFF
ON TABLE SET SQUEEZE ON
ON TABLE NOTOTAL
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0,
BOTTOMMARGIN=0,
BOTTOMGAP=0.054889,
TOPGAP=0,
$
TYPE=SUBFOOT, ITEM=1, SIZE = 10, BOTTOMGAP=0,POSITION = .1, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=LEFT,WIDTH=1.000, $
TYPE=SUBFOOT, ITEM=3, SIZE = 10, BOTTOMGAP=0,POSITION = .87, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
TYPE=SUBFOOT, ITEM=5, SIZE = 10, BOTTOMGAP=0,POSITION = 2.44, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
TYPE=SUBFOOT, ITEM=7, SIZE = 10, BOTTOMGAP=0,POSITION = 3.98, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
TYPE=SUBFOOT, ITEM=9, SIZE = 10, BOTTOMGAP=0,POSITION = 5.29, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
TYPE=SUBFOOT, ITEM=11, SIZE = 10, BOTTOMGAP=0,POSITION = 6.56, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
TYPE=SUBFOOT, ITEM=13, SIZE = 10, BOTTOMGAP=0,POSITION = 7.80, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
TYPE=REPORT,
BORDER=OFF,
GRID=OFF,
FONT='ARIAL',
COLOR='BLACK',
STYLE=NORMAL,
SIZE=10,
SQUEEZE=.5,
ORIENTATION=LANDSCAPE,
$
May 16, 2007, 03:05 PM
Darin LeeThe only thing you have in your subfoot is " ". Is this all of your code?
May 16, 2007, 03:27 PM
mgrackinIf you are supressing every column with NOPRINT, the report still retains rows for the data eventhough you are not showing it. Add a statement to you stylesheet to reduce the font size of the DATA.
TYPE=DATA, SIZE=1,$
May 16, 2007, 03:40 PM
LeahI think even though you have everything as noprint you will get a blank line for the detail area, so your subfoot if it really is just a blank line will give another.
May 17, 2007, 07:34 AM
MicheleThanks for all of the suggestions. I must have changed the code inadvertently when I was trying to resolve my problem so the subfoot part of the code was wrong. The subfoot statement that I had in my fex should have read this way.
ON HGROUP SUBFOOT
"
"
I have, however resolved my problem. My report now single spaces. I changed my code as follows:
TABLE FILE WFMCD205
HEADING
"2"
"- Inpatient "
"Utilization and Cost Trends (Admits) - Medical/Surgical/ICU Rollup"
" 1"
"<12 12MR <22 PMPM "
"<12 PMPM <21 % Increase <32 Admits/1000 <43 Cost/Admit <53 Days/1000 <63 Cost/Day"
SUM
PMPM_YR3 AS ' ' IN 12
PMPM_YR2 NOPRINT
AND COMPUTE
PMPM_PCT23/D7.1% = (PMPM_YR3 - PMPM_YR2) / PMPM_YR2 * 100; AS ' ' IN 23
ADMITS_1000_YR3 AS ' ' IN 37
CADMIT_YR3 AS ' ' IN 44
DAYS_1000_YR3 AS ' ' IN 57
CDAY_YR3 AS ' ' IN 64
BY PRODUCT_NAME NOPRINT
BY HSGSORT NOPRINT
BY HGROUP AS ' ' IN 1
WHERE SORTER EQ 1
FOOTING BOTTOM
"12 Month Rolling, Incurred through "Proprietary and Confidential "
"Actuarial Services - wfmcd205.pdf"
ON TABLE PCHOLD FORMAT PDF
-*ON TABLE HOLD AS WFMCD205 FORMAT PDF
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET PAGE-NUM OFF
ON TABLE SET SQUEEZE ON
ON TABLE NOTOTAL
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0,
BOTTOMMARGIN=0,
BOTTOMGAP=0.054889,
TOPGAP=0,
$
TYPE=DATA, ITEM=1, SIZE = 10, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=LEFT,WIDTH=1.000, $
TYPE=DATA, ITEM=3, SIZE = 10, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
TYPE=DATA, ITEM=5, SIZE = 10, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
TYPE=DATA, ITEM=7, SIZE = 10, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
TYPE=DATA, ITEM=9, SIZE = 10, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
TYPE=DATA, ITEM=11, SIZE = 10, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
TYPE=DATA, ITEM=13, SIZE = 10, STYLE = NORMAL,FONT=ARIAL,JUSTIFY=RIGHT,WIDTH=1.000, $
Thanks all!