Cross Tab Sort and Exclusion
I have a cross tab that maps closing dates over the prior 13 months and looks like this:
Total
Total 3,004
Sep-08 137
Aug-08 220
Jul-08 251
Jun-08 201
May-08 168
Apr-08 263
Mar-08 212
Feb-08 163
Jan-08 142
Dec-07 100
Nov-07 176
Oct-07 149
Sep-07 109
Jan-00 713
I have mapped everything that is not within the prior 13 month range to Jan 1, 2000. I have used record selection to grab records based on multiple criteria. It looks at cases opened in the prior 13 months and cases closed in the prior 13 months. This looks at opened and closed dates. The 713 is just everything in the past 13 months that doesn't have a closed date. When I don't map it to Jan-00 it displays a blank row. I tried to do a specific order sort but when I ran my report today it did not include Sep-08, not that its difficult to add the month once a month, but is it possible to exclude Jan-00 when its printing the cross-tab and then sort the remaining ones in descending order [most recent month prior to oldest]? I am new to Crystal Reports. I thought it may be in the Formula as Group Sort Order and something like this
if {@Closed Month}= date(2000,01,01) then [not sure of what function to exclude] else {@Closed Month} crDescendingOrder
thank you all for the support so far