please help to show always 12 column as month in crosstab

[tanyasharma]

Hi!
I am working on crosstab report and I have months as columns. My problem is that when report gets values for January, Febuary it prints only these two months but I want to show complete 12 months as columns on the report. If no values is coming for any month reports should print zero in the summarized field.
waiting for response.....

 

[dgillz]

You must popoulate the raw data with a number, even if it is zero, to get the crosstab to recognize this and show all 12 months. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[rhinok]

Since you will always have 12 (13 if you have a Grand Total column) columns, you have an ideal scenario for a custom crosstab. Basically, you need to create a report that mimics the look and feel of a crosstab.

Check out Howard Hammerman's FAQ (faq149-1219) for more information.