cross-tab with 12 fixe columns (1 for each month)

[Budjette]

Hi,

I have a cross-tab group by month for the columns. When I have no data in a particular month, it doesn't show in the cross-tab. Is there a way that I can have 12 months all the time?

Thanks,

Budjette

 

[HowardHammerman]

You cannot do this using the cross tab expert. You will have to create a manual cross tab report. Group by your row field and then create twelve formulas of the type:

if month({table.date}) = 1 then {table.number} else 0

Sum these to the group defined by your row field.

There is more to it. You will have to control for the year as well. You can turn this into a rolling date report using a parameter for the start date.

Call if you need help.

Howard Hammerman,
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[Budjette]

Hi Howard,

Thanks for the quick answer. I'll work on that on monday and keep you in touch.

Have a good week-end.

Budjette