COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: morphy on 07 Feb 2009 09:04:56 AM

Title: Problem in Creating a Chart
Post by: morphy on 07 Feb 2009 09:04:56 AM
Hi all,

I am having some problem in creating a Chart.

It is quite strange because I am used to create charts with Report Studio and also because the Table I used is very simple... ???

The table contains only 3 Columns:
-->MONTH (nvarchar);
-->YEAR (nvarchar);
-->VALUE (numeric).

The Query is simple too:

SELECT MONTH, YEAR, VALUE
FROM TABLE;

I created also a Prompt in order to filter the YEAR.

I selected the Query from the Properties Panel then I drag&drop:

-->the YEAR in the Series area;
-->the MONTH in the Columns area (x-axis),
-->the VALUE in the Measure area (y-axis).

That's it!

But It doesn't work.

I expect to find all the months (Jan, Feb, Mar...) on the X-axis with the appropriate values on the Y-Axis but when I run the Report, I obtain an empty chart, without bars, data and values.

I don't know..?!?

Can anyone help me???

I suppose It is due to Types of Data but they look correct...

Please can anyone help me?

Thanks to Everybody.
Ciao
Matty
Title: Re: Problem in Creating a Chart
Post by: Rajaggopal on 11 Feb 2009 12:30:08 AM
My guess is that the problem lies in the YEAR prompt... You said YEAR was an nvarchar right... So there could be problems when applying that filter... Try removing that prompt and running the chart again to see if you can get any data...