no getting solu'n for to fix columns 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 every time. If no values is coming for any month reports should print zero in the summarized field.
waiting for response.....

 

[dgillz]

This is the way crosstabs work - no data, no column (or row).

To fix this, you need to put dummy data - even if it is a zero dollar or quantity - in your database, at least one record per month. Then all 12 columns will appear.

Alternatively, look at the FAQ section for "manual" crosstabs. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com