COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: mrcool on 06 Jan 2006 12:23:54 AM

Title: [Solved]Text Orientation
Post by: mrcool on 06 Jan 2006 12:23:54 AM
HI friends,

Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, In a list report the text orientation shold be display as bottom to top and left to right.

Please find the attachment for the example.

Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 
Title: Re: Text Orientation
Post by: mrcool on 09 Jan 2006 12:22:48 AM
HI frnds....

                   If that case is not possible can i get the text orientation as below:

                   M
                   R
                   C
                   O
                   O
                   L

Thanks,
S
Title: Re: Text Orientation
Post by: jolly on 09 Jan 2006 02:06:06 AM
Hi mrcool,

attached a solution to solve your Problem. There are several steps to include a new Toolbox Item to your CRN.

Okay, lets go.

1. Step
Put this

<string id="IDS_EL_List_Vertical">Vertical List</string>

into the File X:\PROGRAM FILES\COGNOS\CRN\WEBCONTENT\PAT\RES\REPORTSTUDIO_EN.XML
in the Section

<section name="RSB" type="UI">

-------------------------------------------------------------------------------------------------------------------------

2. Step
there after put this

<ListItem idsLabel="IDS_EL_List_Vertical" idsTooltip="IDS_EL_List_Vertical" smallIcon="icon_list_vertical.gif" xptr="StandardComponents.xml#List_Vertical"/>

into the File X:\PROGRAM FILES\COGNOS\CRN\WEBCONTENT\PAT\TOOLBOX.XML

in the Section

<ListViews>

   <ListView id="LayoutView" classPrefix="clsListItem_tb">
      <ListItems>

------------------------------------------------------------------------------------------------------------------

3. Step
there after put This

Ã,  Ã,  <!-- Vertical_List -->
Ã,  Ã,  <toolboxControl id="List_Vertical">
Ã,  Ã,  Ã,  Ã,  <createNewFrame>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  <list>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  <listColumnTitles>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  <style>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  <CSS value="background-color:#0066FF;writing-mode:tb-rl;filter:flipH() flipV();color:white;border-bottom:2.25pt ridge #CCFFFF"/>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  </style>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  </listColumnTitles>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  <listColumns>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  <style>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  <CSS value="border:2.25pt ridge #CCFFFF"/>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  </style>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  </listColumns>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  <style>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  <CSS value="border-collapse:collapse;border:2.25pt ridge #CCFFFF"/>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  </style>
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  </list>
Ã,  Ã,  Ã,  Ã,  </createNewFrame>
Ã,  Ã,  </toolboxControl>


into the File X:\PROGRAM FILES\COGNOS\CRN\WEBCONTENT\PAT\STANDARDCOMPONENTS.XML

---------------------------------------------------------------------------------------------------------------------

4. Step

there after copy the File "ICON_LIST_VERTICAL.GIF"

in the DirectoryÃ,  "X:\PROGRAM FILES\COGNOS\CRN\WEBCONTENT\PAT\IMAGES"

----------------------------------------------------------------------------------------------------------------------

The Line with the Text "writing-mode:tb-rl;filter:flipH() flipV();" is the solution for your Problem.
tb-rl = writing-mode from (t)op to (b)ottom, (r)ight to (l)eft then flip this in vertical AND horizontal.

I have attached the GIF-File an two PicÃ,´s where you can see, where you find the new Toolbox-Item and how the Solution looks like.

Btw. This and the "Existing Format" included in CRN are only working in HTML-Output. I dosnÃ,´t work if you show it in PDF or XLS. That is the answer from Cognos Support. :-(

Hope that helps a little.

Cu Jolly
Title: Re: Text Orientation
Post by: mrcool on 09 Jan 2006 03:38:55 AM
Hi buddy...it worked fine...In our case we need both horizontal and vertical at a time...Plz check the attachment for your reference.
Title: Re: Text Orientation
Post by: mrcool on 09 Jan 2006 05:06:09 AM
Hi Frnds....Finally I have found the sol to my issue...

Add the style in default_layout.css which is located @ cognos\crn\webcontent\cr1

The following Syntax is to be added...
.myStyle { font-family: Arial, Helvetica, sans-serif; font-size: 11px; color: #000000;writing-mode: tb-rl; filter: flipH() flipV(); width: 15px; }

Apply this style to the list column (which has to be changed) using the CLASS  Property from the properties Window...
                                         Thanks for your postings.... :)
                           
Title: Re: [Solved]Text Orientation
Post by: mrcool on 09 Jan 2006 05:11:52 AM
And special Thanks to jolly... :)
Title: Re: [Solved]Text Orientation
Post by: phani1979 on 07 Feb 2006 08:59:17 AM
Hai
I have the same issues once, but upto now i coudn't solve it. I posted a topic in this forum
Can i ask u one thing, what  option did u choose in reportstudio  (either is it a textbox or created a toolbox)
Can u be more specific
I had gone through this topic, i  had tried this, but no result
Can u help me
sudhakar
Title: Re: [Solved]Text Orientation
Post by: phani1979 on 07 Feb 2006 12:45:43 PM
Hey ,Thanks for giving step by step index,,,,
I am able to solve it, I done it,I can see it report studio.
If  have some doubt, let me take a textbox and named it as SALES.
If wanns display in this vertical fashion
How can i do this,Is this same procedure.For that what tags should i use.
Can anyone reply.
Sudhakar