11/02/2011

Cognos 10 Report Studio: Every second axis label missing

I made a simple vertical bar chart that I changed it to horizontal so that axis labels would be easier to read. Some of the labels were quite long and I had manually set break after 200 characters. That way whole label would be shown. But changing chart to horizontal, I lost every second axis label!

I read cognos help troubleshoot about labels but it wasn't so clear what I need to do with my report. I share my solution here if somebody has same problems with the labels. Again, texts in the pictures are in Finnish but I wrote instructions also in English.

[1] Go to axis labels properties and set options so that you don't allow skipping but either rotation or stagger is allowed. I chose to allow stagger:
Allow 45 Degree Rotation / Salli 45 asteen kierto --> No / Ei
Allow 90 Degree Rotation / Salli 90 asteen kierto --> No / Ei
Allow Stagger / Salli porrastus --> Yes / Kyllä
Allow Skip / Salli ohitus --> No / Ei


Axis properties - labels options



In my case this wasn't enough because I had set size to the chart and there wasn't enough space for the labels. First I tested it so that I took away all the chart size settings but it didn't help. (I didn't make any changes to the report page settings.) But I find the solution:

[2] If the first step didn't help yet, set the size of the chart big enough for the labels. I needed to set chart height to 600px and after that all the labels appeared.

Size and overflow / Koko ja ylivuoto