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] uppercase lenght...

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] uppercase lenght...
 Login/Join
 
Gold member
posted
when i create a report like below

c1 c2 c3
123 4543 56765
2342344XxXXXccc1


how can i fixing the column c2 width ?
i use warp=2 , it's not good,

because the uppercase XXX width is different with lowercase Xxx , so if i have 30 pages with one report , the report width is changed when i click next page ....

so how to fixing the column=n2 width ?


Thanks,
James Yang

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET
 
Posts: 97 | Registered: August 18, 2009Report This Post
Virtuoso
posted Hide Post
quote:
i use warp=2 , it's not good

Well, warp is not a recognised style sheet declaration so it won't achieve the results you expect. You can use WRAP=n to set a column's width to any value you need as shown below:
TABLE FILE CAR
PRINT CAR
      MODEL
BY COUNTRY
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN, $
TYPE=REPORT, COLUMN=N1, WRAP=3, $
ENDSTYLE
END


I don't have a WF environment to test it but it should give you an idea.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Virtuoso
posted Hide Post
quote:
the report width is changed when i click next page

If what you want is for the report width to remain "fixed" you might need to get rid of the automatic wrapping that occurs naturally in HTML and set each column's width explicitly.

TABLE FILE ..
ON TABLE SET STYLE *
TYPE=REPORT, WRAP=OFF, $
TYPE=REPORT, COLUMN=N1, WRAP=3, $
TYPE=REPORT, COLUMN=N2, WRAP=2, $
...
ENDSTYLE
END


You can also research and play with the SQUEEZE=n style sheet declaration to try out different alternatives.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Master
posted Hide Post
James, Which output format you are looking for? In case of HTML and PDF output format, use WRAP as suggested by Neftali.
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Gold member
posted Hide Post
quote:
SQUEEZE=n


thanks njsden ,

it's not work well , use WRAP can't fixing the column width.

i used

ON TABLE HOLD AS REPORT1 FORMAT HTMTABLE
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$

Thanks Ram Prasad E
output format is HTMTABLE


Thanks,
James Yang


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET
 
Posts: 97 | Registered: August 18, 2009Report This Post
Expert
posted Hide Post
Would using a proportional font in conjunction with your stylesheet syntax produce the results that you are looking for?

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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Gold member
posted Hide Post
hi Toony ,

my report is like below,

  

id  name count |
1   xaa  10    |
2   aaa  10    |
3   bbb  20    |
               |
    next page  |
----------------

click next page

id  name   count |
4   XXX    10    |
5   AAA    10    |
6   BBB    20    |
                 |
    next page    |
------------------



the 2th page width is longer than 1th.

....

i used
TYPE=REPORT, WRAP=OFF, $
TYPE=REPORT, COLUMN=N1, WRAP=1, $
TYPE=REPORT, COLUMN=N2, WRAP=1, $
TYPE=REPORT, COLUMN=N3, WRAP=1, $

this way ,it's not work well.
i think the reson is uppercase lenght...

XXX.LENGHT = 3
xxx.LENGHT = 3 ...too

so the page width look different..


Thanks,
James Yang


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET
 
Posts: 97 | Registered: August 18, 2009Report This Post
Expert
posted Hide Post
Is your report in HTML only?

By the way, only one "o" Wink

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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report 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] uppercase lenght...

Copyright © 1996-2020 Information Builders