Crystal Report Query Question
I am trying to show ALL open tickets and tickets that have been closed within the last seven days. I have tried numerous querys with no luck. I also need the ticket numbers to numerically ordered (MM/DD/YY).
Fields I need to show in report are ticket number, category, original date entered, close time.
Any help would be greatly appreciated
Re: Crystal Report Query Question
I think there is a sort parameter you can use while generating the reports.
You can check the following forum I found about it:
Here is also some additional information about the query you would like to use, it is not the same but similar so you can use it as an example: