Customising reports

[Bob320]

HI all,

I am trying to create reports similar to the ones shown in the attached PDF.

(I understand I may have to have a separate report for each page)

Just to explain the first one (second page) it shows number of resolved incidents meeting/breaching SLAs for the last week.

I have selected/joined the correct tables but the issue I have is being able to create extra columns that contain manipulated data such as: counts of incident categories and splitting the categories field so i can break them down further (The current value in category is HARDWARE - PC)

I guess what I wanted to know is if there is a way to manipulate the data so I can produce these kind of reports?

Or is there an alternative to produce a report that mimics the one shown in the pdf?

Thanks!

20160912.pdf