I have a main report with two subreports, one for 2010 and the other for 2011. Each subreport groups sales by month, with a subtotal and grand total. I have supressed the detail. For 2010 I have 12 months of data, but for 2011 I have only 10 months. I would like to show the two years side by side to compare, and so I've got the Change Group Options set for each month.

Trouble is, for 2011 it only lists the 10 months for which there is data, and puts the grand total on the eleventh line. Is there a way to force the 2011 subreport to include group footers for November and December, even thought there is no sales data yet, so my two reports can be aligned?

Thanks for your help!   

I can see how using a crosstab would solve my labeling problem, but unfortunately, the data I'm accessing to do this report comes from different sources.

It sounds like Crystal doesn't allow for the formatting I need. I will probably just do it in Excel. Thanks for your quick reply.