Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Column Width adjustment for PDF Reports

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Column Width adjustment for PDF Reports
 Login/Join
 
Platinum Member
posted
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,


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 229 | Location: MI | Registered: September 13, 2017Report This Post
Virtuoso
posted Hide Post
Srajeevan

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


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Platinum Member
posted Hide Post
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?


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 229 | Location: MI | Registered: September 13, 2017Report This Post
Virtuoso
posted Hide Post
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.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Platinum Member
posted Hide Post
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


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 229 | Location: MI | Registered: September 13, 2017Report This Post
Platinum Member
posted Hide Post
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.


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 229 | Location: MI | Registered: September 13, 2017Report This Post
Virtuoso
posted Hide Post
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.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Virtuoso
posted Hide Post
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,
$


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Column Width adjustment for PDF Reports

Copyright © 1996-2020 Information Builders