Wondering if anyone has created a Cross Tab Crystal Report that shows by each category, the number of Incidents logged by Support Group.
I've got a nice-ish report but I'm struggling to pull in results for categories against which no Incidents have been logged. I thought a right outer join on the IM Incident table would pull them in but then it conflicts with the 'Date Logged' paramater in place, e.g.
If you enter a date range for all of the month of May
But no Incidents have been logged for category 'Modem'
then nothing is returned...but I'd really like Modem to be returned showing no Incidents logged.
Any advice gratefully received!!!