Hi I am new to crystal and I am using Crystal XI so I apologize for the ignorance. I am self teaching!! I work at Help Desk and I am tasked with creating a "Top Ten" report based on category usage. Meaning, we need to run a report and see what the top ten most used categories tickets were logged under. (Category would be something like "password reset", network printer, etc).
I was able to get the report to pull everything that I need and it's sorted to pull the Top used categories but when checking my numbers, I realized a problem. In our ticketing system some of our categories are listed in a "Parent/Child" format.
Example:
Parent Category = PRINTER
Child Category = NETWORK, JAM, INK,etc.
So my question really is how do I get the report to group the children categories "under" the Parent category and give a sum of all of them. Then have that total be the number that the report sorts on for the "Top Ten".
Again I apologize for this long post, but I am very new to this with only self taught training! Any help would be greatly appreciated.
IP Logged
