Skip to Content
Author's profile photo Didier MAZOUE

Display vertical labels in tables

Display vertical labels in tables

Sometimes we have to display tables on a single page (or on a restricted number of pages).

The issue with this challenge is that the data to be displayed in a column is too large so the tables is displayed on multiple pages.

The hint is to turn the data vertically for a given dimension (or measure or detail).

To do it you just need to create a variable per dimension.

The generic formula is:

=Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([MyDimension];”a”;”a”+Char(10));”b”;”b”+Char(10));”c”;”c”+Char(10));”d”;”d”+Char(10));”e”;”e”+Char(10));”f”;”f”+Char(10));”g”;”g”+Char(10));”h”;”h”+Char(10));”i”;”i”+Char(10));”j”;”j”+Char(10));”k”;”k”+Char(10));”l”;”l”+Char(10));”m”;”m”+Char(10));”n”;”n”+Char(10));”o”;”o”+Char(10));”p”;”p”+Char(10));”q”;”q”+Char(10));”r”;”r”+Char(10));”s”;”s”+Char(10));”t”;”t”+Char(10));”u”;”u”+Char(10));”v”;”v”+Char(10));”w”;”w”+Char(10));”x”;”x”+Char(10));”y”;”y”+Char(10));”z”;”z”+Char(10));”A”;”A”+Char(10));”B”;”B”+Char(10));”C”;”C”+Char(10));”D”;”D”+Char(10));”E”;”E”+Char(10));”F”;”F”+Char(10));”G”;”G”+Char(10));”H”;”H”+Char(10));”I”;”I”+Char(10));”J”;”J”+Char(10));”K”;”K”+Char(10));”L”;”L”+Char(10));”M”;”M”+Char(10));”N”;”N”+Char(10));”O”;”O”+Char(10));”P”;”P”+Char(10));”Q”;”Q”+Char(10));”R”;”R”+Char(10));”S”;”S”+Char(10));”T”;”T”+Char(10));”U”;”U”+Char(10));”V”;”V”+Char(10));”W”;”W”+Char(10));”X”;”X”+Char(10));”Y”;”Y”+Char(10));”Z”;”Z”+Char(10));” “;” “+Char(10));”0″;”0″+Char(10));”1″;”1″+Char(10));”2″;”2″+Char(10));”3″;”3″+Char(10));”4″;”4″+Char(10));”5″;”5″+Char(10));”6″;”6″+Char(10));”7″;”7″+Char(10));”8″;”8″+Char(10));”9″;”9″+Char(10));”-“;”-“+Char(10));”_”;”_”+Char(10))

You just need to copy this formula and replace “[MyDimension]” by the appropriate dimension name, measure name or detail name.

Vertical labels.png

As you can see, the table can now be displayed on a single page or on a much more limited number of pages.

You can download the Web Intelligence report attached to that publication.

Didier MAZOUE

Assigned tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hey Didier, great webi trick !!!

      I´m just affraid that it can have an impact over the performance of the report.

      ]Regards,

      ogerio

      Author's profile photo Former Member
      Former Member

      Hi Didier, Its a nice trick.

      Can you explain in detail about how the formula works

      Author's profile photo Didier MAZOUE
      Didier MAZOUE
      Blog Post Author

      Hi,

      I replace all characters in the dimension/measure/detail by adding Char(10) after each character: this will add a line feed after each character.

      Example: Replace([MyDimension];"a";Char(10)) to add a line feed after each "a".


      Didier

      Author's profile photo Former Member
      Former Member

      Ok thank you!!

      for the explanation. will try in my free time once...

      Author's profile photo Kuldeep Ghosh
      Kuldeep Ghosh

      A very helpful trick!

      As Rogerio said, can there be any impact on performance?

      - Kuldeep

      Author's profile photo Former Member
      Former Member

      HI Didier,

      very nice Trick. could you explain more how it turned in to vertical?

      As you mentioned  it provides Line feed what do you mean by line feed

      Thanks,

      Varun

      Author's profile photo Mahboob Mohammed
      Mahboob Mohammed

      Hi Varun,

      Line Feed means going to the next line, like we press Enter in Word doc/Text file to go to the next line.

      Check this out:

      Dave’s Adventures in Business Intelligence; Displaying UserResponse() Values On Separate Rows

      Thanks,

      Mahboob Mohammed

      Author's profile photo WILLIAM MARCY
      WILLIAM MARCY

      Great Webi trick !

      You've been added to Webi 4.x tricks : summary for a better visibility. Keep posting !

      William