I am creating a cross-tab report in crystal reports based on AR_InvoiceHistoryHeader and Detail. I am trying to summarize the number of shipped units per month for a particular year. I have this working fine, except that if there is no data for a given month then the month is not listed. This is only an issue because the report needs to be exportable to Excel and they like each month of a year represented with a column even if the value is 0. For instance, we went live on Sage 100 August of last year so I have no columns for Jan-Jul. I'm assuming I'll need to write a formula to accomplish this and base the crosstab on the formula. Any suggestions?

Example:

I have a new item that shipped 50 units in March and had never been shipped before. Currently I would see:

                          Mar           Total

Customer X:     50               50

What I need to see:

                          Jan          Feb         Mar         Apr         May         Jun         Jul         Aug         Sep         Oct         Nov         Dec         Total

Customer X:     0               0             50            0             0              0             0             0              0              0             0              0              50