Focal Point
[CLOSED] Display data vertically

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

January 19, 2012, 03:09 PM
WF DEV
[CLOSED] Display data vertically
Is it possible to display column's data verically in PDF Format

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


WebFocus 7.6.9
Win XP Dev.Studio
Excel, PDF, HTML
January 19, 2012, 04:24 PM
Waz
The OVER command may be what you want, but an example would be useful.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

January 20, 2012, 09:30 AM
WF DEV
We need to display data something like this(rotate displayed data 90 degrees)


Col1 Col2 Col3

X X X
X X X
X X X
X X X
X X X
X X X


WebFocus 7.6.9
Win XP Dev.Studio
Excel, PDF, HTML
January 22, 2012, 03:41 PM
Waz
Not sure I understand.

You want the report to be:

Col1 X X X X X X
Col2 X X X X X X
Col3 X X X X X X

?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

January 23, 2012, 08:13 AM
njsden
I think WF DEV means this:



I don't know how to do that in PDF. I think I've seen some workarounds in this forum to have something like that in HTML/Excel by using some particular combination of CSS keywords but I don't think that is transferable to PDF.



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.
January 23, 2012, 08:13 AM
atturhari
quote:
Originally posted by WF DEV:
We need to display data something like this(rotate displayed data 90 degrees)


Col1 Col2 Col3

X X X
X X X
X X X
X X X
X X X
X X X


Try, TYPE=REPORT, COLUMN=Col1, WRAP=0.1,$
or lesser value for WRAP


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
January 23, 2012, 09:07 AM
WF DEV
njsden You are correct . It is exactly what I meant. I saw a few posts how to rotate column title, but I did not see anything as far as data rotation concerns.


WebFocus 7.6.9
Win XP Dev.Studio
Excel, PDF, HTML
January 23, 2012, 02:36 PM
Waz
The chances of doing data rotation in PDF is virtually zero, the column title rotate works on known values, and is a bit lengthy in its implementation.

To do the same with data would take for ever.

The issue is that to rotate the data, the actual layout of the report would have to change, as the hieght of the rows would have to change, and then perhaps extra pages would need to be added.

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


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

January 23, 2012, 04:34 PM
<FreSte>
Waz is right; it looks like s*** (in IE) Big Grin

TABLE FILE CAR
  SUM 
    DEALER_COST
  BY COUNTRY
  BY CAR
  ON TABLE HOLD AS HLDRPRT1 FORMAT HTMTABLE
  ON TABLE SET STYLE *
  TYPE=DATA, COLUMN=DEALER_COST, CLASS=rotate1 ,$
  ENDSTYLE
END
-RUN

-HTMLFORM BEGIN
<html>
<style>
.rotate1 {
    color:red;
    writing-mode: tb-rl;
    filter: flipv fliph;
}
</style>
<body>
!IBI.FIL.HLDRPRT1;
</body>
</html>

-HTMLFORM END

January 23, 2012, 05:10 PM
Prarie
I don't know...that doesn't look so bad - you made it happen...
January 23, 2012, 05:16 PM
Waz
Doing it in a browser/Excel is the easy place to do it.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

January 24, 2012, 11:11 AM
WF DEV
Thank you guys for your replies I will relate
this info to my user


WebFocus 7.6.9
Win XP Dev.Studio
Excel, PDF, HTML
January 24, 2012, 01:00 PM
Doug
One more for you, if you want this in PDF: PDF Text Effect