Print Page - Chart not showing all the values of x-axis

Title: Chart not showing all the values of x-axis
Post by: Starfish2201 on 17 Dec 2012 02:22:11 PM

Hi Gurus,

I have a chart in my report page, and I am using SQL (native) to pull the data from data source. In the SQL, I am doing count. I want to show count of projects in each region/area. But when I point the chart to the native SQL and run the report, its picking only value for x-axis( the first value) and only displaying 1 bar.

Can anyone please help me in this?

Thanks
Paddy

Title: Re: Chart not showing all the values of x-axis
Post by: blom0344 on 18 Dec 2012 08:39:37 AM

Uh, did you use region/area in the chart for the series?

Title: Re: Chart not showing all the values of x-axis
Post by: Starfish2201 on 18 Dec 2012 11:33:44 AM

Hi blom0344,

Yeah I already added that to the series.

However I assigned the query to the report page and that resolved the issue.

Thank you so much for your response !!! :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Starfish2201 on 17 Dec 2012 02:22:11 PM