Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Not what you were looking for? View more on this topic or Ask a question