Solutions for issues and Tips on customizing the cognos chart reports

In order to change the properties you can select on the properties pane properties. Few of the properties depend on other properties. You can customize the chart reports in cognos very easily depending upon some arithmetic, logic or conditional expressions statements if you know how to use conditional variables. But there are many other customizations other than conditional variable customizations in cognos for changing the report display properties, format options like header, footer, labels, titles, grouping, summarizations,performance tuning like query performance, database performance etc.



Following are the Important customizations that are to be known in Customizing charts reports in Cognos:
Cognos issue: How to show or Hide the title subtitle or footer in a chart?
Solution: Below the option Chart Titles,select and change the Title or Subtitle or Footer property.

Cognos issue: How to show or Hide the legend options or baselines markers or notes in a chart?
Solution: Below the option for Chart Annotations, select on the the Legend or Baselines or Markers or Notes property and modify as per the need.

Cognos issue: How to show or Hide the axes in chart?
Solution: Below the option for Axes, select Y1 or Y2 or Ordinal Axis's property and change it.

Cognos issue: How to show or Hide the axis line or axis title in Cognos charts?
Solution: Click on the Y-axis and in the options pane, below the General Modify the properties for Axis Line and Title

Cognos issue: How to show or Hide the gridlines in chart report types?
Solution: click on the y-axis or the ordinal axis. Below the General button, you find the Gridlines/ Minor Gridlines as a property, change it.

Cognos issue: How to display the border around the legend?
Solution: Click on the legend icon. Below the General, alter the property called borders.

Cognos issue: How can i make the Chart display in different 3D appearance?
you can do that by changing the Depth or Visual Angle property in general options.

Cognos issue: How to show or Hide the border around the chart object?
Solution: Modify the property called border property under the charts properties box.

Cognos issue: How can i display the tooltips?
Note: Some of the pdfs cannot render the tooltips.
Solution: to change this, you can simply modify the tooltips property.

Cognos issue: How to change the options like range or interval in Y-Axis properties?
Solution: you can select the options Minimum value, Maximum Value, Scale interval, Scale Property Under the options General.

Cognos issue: How can i modify the data format
Click on the y-axis and below option Data, you find the Data Format property, change it.

Cognos issue: How to alter ordinal axis properties like label truncation or skip interval?
Click on the ordinal axis. Below the option General, Click on the Truncation -> Allow Rotation or Allow Stagger or Allow Skip property.

Cognos issue: I have a white space around the chart, How can i remove it.
Click on the option for Padding/Margin property and change it.

You can find the below options under the options Color and BackGround.

Cognos issue: How to change the colors of the lines and bars in charts?
Change the Palette or Conditional Palette property.

Cognos issue: Apply a palette to a series
Change the Series Color property.

Cognos issue: Change the default color or font for all chart elements
change the Background Color, Foreground Color, or Fill Effects property.
And you can also change the Font or Relative Alignment property, below the opions for Font & Text.

Cognos issue: How can i Insert a background image or watermark in a chart report?
Go to the Background Image property and change it.

Cognos issue: Override the default font or color for axes and chart values
Select the lock icon in the toolbar and unlock the chart object,You can also Click on the chart body by clicking on the place between the axes, and modify the Background Color or Foreground Color or Font or Fill Effects property.

Cognos issue: How can i Resize the chart
Below the options for Positioning, modify the Size & Overflow property.

Cognos issue: Insert a background image or watermark in the chart body, that is, the space between the axes
Select the lock icon in the toolbar and unlock the chart object, click on the chart body by clicking between the axes, and change the Background Image property.

12 comments:

Anonymous said...

Very thank full for your help.....this is the place where we get real stuff

Anonymous said...

Hello Krishan sir....can you guide me how to create charts without meassures?????

And can u post some real time scenarios???

Anonymous said...

Sir can you guide me How to test the report??

Anonymous said...

Hello sir....can you tellme how datamodel helps in real time in cognos???with real time scenario

Krish said...

Hi Raj,

Sure, i shall update with what u asked for? :)

Cheers,
Krihan

Anonymous said...

How to display values over the bars in cognos 8.4

Thanks,

Anonymous said...

I have a case where we have to dynamically change the color of the line depending upon a condition and by using conditional palette in the chart options I have created a string variable so that based on the variable from the query my color of the line should vary but I am unable to get the correct colors which I specified using this string variable in the conditional variable. please help me with this.

Thanks in advance.

chiranjeevi said...

Hi
have an issue: i drag Text item in to the working area of Report studio, when i select that text item and am trying to change source type property Text to data item but am unable see the data item under the source type property, can any one suggest me.
Thanks

Anonymous said...

You are great. We love you.

Kwame from Atlanta (USA)

Anonymous said...

combination chart(Bar) in cognos10 has 4 categories. They all display values above the bar. If we new item to the category, the 5th bar appears but the value does not appear on top.

Tried :

Clicked on series and general properties--> Show value has options like clustered/None/stacked.

But not the regular ones.

How can i get that value on top

any ideas?

Unknown said...

Hi,
Raj i need to real time scenario in fwm & report stdio. plz sand me this email address rajeshcognos25@gmail.com

Unknown said...

Hi, sir
i need to interview question in cognos

Post a Comment