Focal Point
[CLOSED] uppercase lenght...

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/711101844

May 22, 2010, 05:25 AM
Yangyang
[CLOSED] uppercase lenght...
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
May 22, 2010, 10:50 AM
njsden
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.
May 22, 2010, 10:55 AM
njsden
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.
May 23, 2010, 02:20 AM
Ram Prasad E
James, Which output format you are looking for? In case of HTML and PDF output format, use WRAP as suggested by Neftali.


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
May 23, 2010, 11:54 PM
Yangyang
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
May 24, 2010, 01:44 AM
Tony A
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 
May 24, 2010, 02:02 AM
Yangyang
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
May 24, 2010, 10:33 AM
Tony A
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