Graph without data

[mrcool]

Hi frnds,

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



Thanks,
S

[mikegreen]

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

[mrcool]

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

[anoop_ind2]

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

[mrcool]

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




Thanks,
S