Cross Tab and Showing Past Dates

[hgraybill]

I have a cross tab that shows the dates and qty's on Customer Orders, like below in Cross Tab 1. The problem I'm having is I want past months to show as 0, like the second example, Cross Tab 2. I tried doing this in a manual cross tab, but I don't know how to do it without making a formula for every date range. For example, I would need to create a formula for January 2009 all the way way through December 2012.

Is there any way around this?

Cross Tab 1
6/2009 7/2009 8/2009
Part1234 10 20 50
Part5678 20 0 90


Cross Tab 2 (what I would like to show)

1/2009 2/2009 3/2009 4/2009 5/2009 6/2009
Part1234 0 0 0 0 0 10
Part5678 0 0 0 0 0 20

Please let me know if you need more information to help answer my question.

Thanks,
Heather

 

[Madawc]

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back.

If you can change the data, you could have a dummy 'part' that had an entry for every month. This would allow a regular crosstab to be used, but I'd suppose that you'd need to show the dummy for this to work. (I've never tried it.)

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10