Hi,

I have tried using Wrap,Squeeze for reducing column width for my pdf report.
Has anyone succeeded in adjusting the column width for pdf reports.
Please respond.

This message has been edited. Last edited by: FP Mod Chuck,

Srajeevan

Column headings can be the issue if they are too long. Reducing font size if possible will also help.

My report has couple of hold files and i join using MORE command and display the report using a BY field and an ACROSS field.
I used LEFTGAP and RIGHTGAP but couln't find much difference.
How can i reduce column title or ACROSS field.
Is there is any wF stylesheet commands to do it?

Srajeevan

If you right mouse on the field and choose column title you can modify the text. You can also reduce the font size with a right mouse click and choose font.

Hi Chuck,

I have already reduced the font-size and Column text is also not so long.
I wanted to know if i can reference ACROSS fields using any WF stylesheets commands like we do for COLUMNS.
eg: TYPE=DATA or TYPE=REPORT
Then i can apply SQUEEZE or WRAP to ACROSS fields.That is what my intention.
Correct me if i am wrong.

Thanks

My report is also complicated.

  
DEFINE FILE ACTIVITIES_DB
Defyear/YY=OFFICER_DAILY_DATE;
Defmonth/MT=OFFICER_DAILY_DATE;
Defmonthchar/A5V=IF Defmonth EQ 1 THEN 'JAN' ELSE IF Defmonth EQ 2 THEN 'FEB' ELSE IF Defmonth EQ 3 THEN 'MAR' ELSE IF Defmonth EQ 4 THEN 'APR' ELSE IF Defmonth EQ 5 THEN 'MAY' ELSE IF Defmonth EQ 6 THEN 'JUN' ELSE IF Defmonth EQ 7 THEN 'JUL' ELSE IF Defmonth EQ 8 THEN 'AUG' ELSE IF Defmonth EQ 9 THEN 'SEP' ELSE IF Defmonth EQ 10 THEN 'OCT' ELSE IF Defmonth EQ 11 THEN 'NOV' ELSE 'DEC';
FILE_CLASS_DASHBD_DESC/A75V=IF FILE_CLASS_DASHBD EQ '0900' THEN 'Homicide' ELSE IF FILE_CLASS_DASHBD EQ '1100' THEN 'Sexual Assault' ELSE IF FILE_CLASS_DASHBD EQ '1200' THEN 'Robbery' ELSE IF FILE_CLASS_DASHBD EQ '1300' THEN 'Assault' ELSE IF FILE_CLASS_DASHBD EQ '2200' THEN 'Burglary' ELSE IF FILE_CLASS_DASHBD EQ '2300' THEN 'Larceny' ELSE IF FILE_CLASS_DASHBD EQ '3500' THEN 'Drugs' ELSE IF FILE_CLASS_DASHBD EQ '5000' THEN 'Obstruction' ELSE IF FILE_CLASS_DASHBD EQ '54002' THEN 'OUI' ELSE IF FILE_CLASS_DASHBD EQ '93001' THEN 'Traffic Accident' ELSE LCWORD3( 75, FILECLASS_DESC, 'A75' );
FILE_CLASS_DASHBD/A5=IF FILE_CLASS_CODE EQ '54002' THEN '54002' ELSE IF FILE_CLASS_CODE EQ '93001' THEN '93001' ELSE EDIT( FILE_CLASS_CODE, '9999' );
VIOLENT_FLAG/I9=IF FILE_CLASS_DASHBD IN ( '1300', '1200', '1100', '900' ) THEN 1 ELSE 0;
END
TABLE FILE ACTIVITIES_DB
SUM
	COMPUTE VAL1/I8 = CNT.ACTIVITY_ID;
	COMPUTE VALACTIVITYID/A100V = FPRINT(VAL1, 'I8', 'A100V');
BY LOWEST ACTIVITY_TYPE_DESC
BY Defyear
BY TOTAL COMPUTE ROWLABEL/A20V = 'Year ' | EDIT(Defyear);
WHERE Defyear IN ('2016','2017');
WHERE RECORDLIMIT EQ 1000000
WHERE READLIMIT EQ 10000000
WHERE DISTRICT EQ '1';
ON TABLE HOLD AS EXTDATA
END
-RUN

DEFINE FILE EXTDATA
SALES1/I8=IF Defyear EQ 2016 THEN VAL1 ELSE 0;
SALES2/I8=IF Defyear EQ 2017 THEN VAL1 ELSE 0;
END
TABLE FILE EXTDATA
SUM
     COMPUTE VAL/I8 = ( SALES2 - SALES1 );
     COMPUTE VALACTIVITYID/A100V = FPRINT(VAL, 'I8', 'A100V');
     -*COMPUTE ICON/A100V = IF ( SALES2 - SALES1 ) GT 0 THEN EXTDATA.EXTDATA.UP_ARROW ELSE EXTDATA.EXTDATA.DOWN_ARROW;
BY  LOWEST EXTDATA.EXTDATA.ACTIVITY_TYPE_DESC
BY TOTAL COMPUTE Defyear/YY = 9999;
BY TOTAL COMPUTE ROWLABEL/A20V = 'Diff';
ON TABLE NOTOTAL
ON TABLE HOLD AS DIFFDATA
END
-RUN
DEFINE FILE DIFFDATA
UP_ARROW/A100V = '<img src="/approot/images/scp/uparrow.jpg" style="width:20px;height:20px;">';
DOWN_ARROW/A100V= '<img src="/approot/images/scp/downarrow.jpg" style="width:20px;height:20px;">';
LOGO/A100V = IF DIFFDATA.DIFFDATA.VAL GT 0 THEN UP_ARROW ELSE DOWN_ARROW;
END
TABLE FILE DIFFDATA
SUM
     -*COMPUTE VALACTIVITYID/A100V = IF DIFFDATA.DIFFDATA.VAL GT 0 THEN UP_ARROW ELSE DOWN_ARROW;
	 COMPUTE VALACTIVITYID/A100V = LOGO;
BY  LOWEST DIFFDATA.DIFFDATA.ACTIVITY_TYPE_DESC
BY TOTAL COMPUTE Defyear/YY = 9999;
BY TOTAL COMPUTE ROWLABEL/A20V = 'Icon';
ON TABLE NOTOTAL
ON TABLE HOLD AS DIFFICON
ON TABLE SET STYLE *
$
TYPE = DATA,COLUMN=VALACTIVITYID, IMAGE= LOGO ,SIZE=(2.0 .5),$
ENDSTYLE
END
-RUN
TABLE FILE EXTDATA
SUM
     EXTDATA.EXTDATA.VALACTIVITYID AS ''
BY  LOWEST EXTDATA.EXTDATA.ACTIVITY_TYPE_DESC AS 'DETROIT'
ACROSS LOWEST EXTDATA.EXTDATA.Defyear NOPRINT
ACROSS EXTDATA.EXTDATA.ROWLABEL AS ''
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     INCLUDE = IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENblackbluepurple.sty,
$
     PAGESIZE='10 x 14',
     TYPE=REPORT, ORIENTATION=LANDSCAPE,GRID=ON,SQUEEZE =ON,$
TYPE=REPORT,
     FONT='IBIDEFAULT',
     SIZE=6,
     COLOR='BLACK',
     BACKCOLOR=RGB(223 223 235),
$
TYPE = REPORT,COLUMN = N2,LEFTGAP=1,RIGHTGAP=-6,$
TYPE = REPORT,COLUMN = N1,LEFTGAP=1,RIGHTGAP=-2,$
TYPE = REPORT,COLUMN = N3,LEFTGAP=-4,RIGHTGAP=-6,$
TYPE = REPORT,COLUMN = N4,LEFTGAP=-4,RIGHTGAP=-2,$
TYPE=DATA,
     FONT='TAHOMA',
     SIZE=6,
     COLOR=RGB(71 68 88),
     BACKCOLOR=( RGB(223 223 235) RGB(173 173 199) ),
$
TYPE=ACROSSVALUE,
     FONT='TAHOMA',
     SIZE=6,
     COLOR=RGB(71 68 88),
     BACKCOLOR=RGB(173 173 199),
     STYLE=BOLD,
$
ENDSTYLE
MORE
FILE DIFFDATA
MORE
FILE DIFFICON
END
-RUN

Unfortunately the fex is very messy.

Srajeevan

ACROSSTITLE and ACROSSVALUE are stylesheet commands. But when I use WRAP it appears to tie it to the columns I have selected under the stylesheet command REPORT. So if you select all your across columns you can use WRAP but I don't see SQUEEZE as a option.

TYPE=ACROSSTITLE, is for the title of the across field : title of ROWLABEL
TYPE=ACROSSVALUE, is for the value of the across field : value of ROWLABEL

You can also perform such as this to reach ACROSS data under the across field

TYPE=DATA,
     COLUMN=VALACTIVITYID(*),
     FONT='TAHOMA',
     SIZE=6,
     COLOR=RGB(71 68 88),
     BACKCOLOR=( RGB(223 223 235) RGB(173 173 199) ),
$
TYPE=DATA,
     COLUMN=VALACTIVITYID(1),
     SIZE=10,
$
TYPE=DATA,
     COLUMN=VALACTIVITYID(3),
     SIZE=12,
$
TYPE=DATA,
     ACROSSCOLUMN=VALACTIVITYID,
     JUSTIFY=RIGHT,
$