rotation of Cross tab column header to 90

building reports webintelligence
1

Hi All,

I am using BOXI R 3.0 . Is it possible to rotate Cross tab column header to 90 degree in Webi?

I have checked other post and tried using HTMl but deosnt seems to work…

Have anybody faced same issue before?

Regards

chin2G (BOB member since 2010-10-02)

2

I guess you can push this back to the universe.
Assuming your universe is built on top of the Oracle, you can create an object with the select logic as following:

“select regexp_replace(your_Dimension,’([A-Za-z0-9])’, ‘\1’||’
’) from dual”

This will insert a
after each character in your dimension.

And you can put this object as Column header, then change the column header cell read mode as “HTML”.

Then you are good to go.

RogerLiu (BOB member since 2010-10-19)

3

Hi RogerLiu,

Thanks for prompt response… but i want in below format as attached

Can someone help here pls?

Regards

vertical.JPG

chin2G (BOB member since 2010-10-02)

4

I can think of 2 ways to do this.

  1. You can need to use CSS-approach.

Here is a code sample(Tested in Mozilla Firefox 10.0, as attached snapshot):

=“<div Style="-moz-transform: rotate(-90deg);">Test”

Put the above code into a cell , and read it as HTML.

For other browsers, you might refer to the following page.

http://css-tricks.com/snippets/css/text-rotation/

  1. You can use pictures(more efforts,not recommended). Use hyperlink to load picture as your cell content.
    rotate.jpg

RogerLiu (BOB member since 2010-10-19)

5

It’s not working in BOE 3.1. Is there some setting or process that needs to be activated in order for this to work? The only thing I’ve been able to see with HTML is bold and italic and that only shows up in Enhanced View Mode. Also, I need be able to publish the report to a PDF file and if the HTML isn’t going to translate to PDF, there’s no point in continuing. Please help. If I can’t get this working, an entire set of reports will have to be redesigned by the users and they’re on a tight deadline.

sandman_max (BOB member since 2012-03-06)

6

AFAIK, using HTML is the only way to accomplish this, and as you already know, doesn’t travel well. Try approach #2 above if you need to export to PDF.

HTH

NMG

mcnelson :uk: (BOB member since 2008-10-09)

7

You can use the “REGEXP_REPLACE” and “Reverse” oracle functions at the query level:
Reverse(Replace(REGEXP_REPLACE(tablename.columnname, ‘(.)’, '\1 ‘),’ ',chr(10))) “state”

Try the above formula at the report query level by editing the query to use freehandsql.

friend (BOB member since 2006-07-03)