Problem in Creating a Chart

[morphy]

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

[Rajaggopal]

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...