Group by Month regardless of data

[puppy39]

I am trying to create a report of activities grouped by a Company and Month/Year but there are some month where we won't have any activites with a company and for that month it should display 0.

I know crystal reports can't create a group unless there is data but I was wondering if there is a work around this. Example under Company A I should see February 0 but February does not even show up because there is no data. Any suggestions. Thanks

Company A

January 2011 20
March 2011 5

Company B

December 2010 5
January 2011 10
February 2011 6
March 2011 15

 

[lbass]

Will the months shown remain the same? You could just use running totals that reset on change of company, and which use a formula for evaluation, e.g., month({table.date}) = 2.

-LB