chart with date

[fwhorton]

Hello: I am trying to create a bar chart (x=month, y=$)that spans one year (Jan.-Dec.). But if the only dates in my table are Jan.-Mar. then the report only shows those month. If the only date in my table is Jan. then the chart only shows one huge bar. Is there a way to show show all 12 months but without bars? One person suggested creating a table with all the months and do a left join. Is there a way to use subdatasets?

 

 

Any suggesstions are greatly appreciated.

 

 

fw.

[svenn]

You could do this in your SQL. Create 12 buckets then place your data in the appropriate bucket. the syntax would depend on what data base you are using.