Charts By Month

[dnetzley]

I have created several charts of an activity by month using a simple query to aggregate the data. When I do the results only include the months that have data, i.e., if there was no activity for a given month the month is left out of the chart. Is there a way to force the x axis to increment monthly even if the data value for the month is 0? I am using stacked bar charts.

Thanks

dnetzley

[NeoPa]

You would need a data source that returned the months to start with. From there you could use a LEFT JOIN into your data results.

[dnetzley]

Thanks. I was hopeing there was a way to increment the month in code but the table idea is simple and easy.

dnetzley

[NeoPa]

You can use code to populate the table if you like, but I'm pretty sure you can't return a dataset from code like, say, a Cursor in T-SQL.