Print Page - Graph without data

Title: Graph without data
Post by: mrcool on 21 Feb 2006 07:10:04 AM

Hi frnds,

How do we get a graph display all 12 months labels on x-axis even if there is no data.

Thanks,
S

Title: Re: Graph without data
Post by: mikegreen on 21 Feb 2006 07:35:25 AM

We do an outer join to a calendar table we created that includes all dates... It works for us as our data supports this type of join and display; but I can see it not working for some types of data..

Cheers,

Mike

Title: Re: Graph without data
Post by: mrcool on 21 Feb 2006 11:28:33 PM

Hi Mike Thanx 4 ur reply..I will try with this...

Title: Re: Graph without data
Post by: anoop_ind2 on 22 Feb 2006 12:54:27 AM

Also, if you do not have a table which gives you all the dates you could create a tabular set which would give you empty values for all the months. More like creating yourself a temporary table inside reportnet with which you can union your table to get all the months.

An extra field Quantity1 is being created so as to have the query run something against the database. Attached is a go sales example. Lemme know if this helps

Title: Re: Graph without data
Post by: mrcool on 22 Feb 2006 03:31:52 AM

Hi..Thanks..The issue got solved...

Thanks,
S

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: mrcool on 21 Feb 2006 07:10:04 AM