We are a builder and I want to be able to report on the Issue Types encountered during the each build and when and how often they are occurring. Therefore I have the following tables:
Builds - (Linked to Issue Occurrences, Page Designer Based on this table)
Issue Types - (Unique Types of Issue)
Issue Occurrences - (linked to Builds and Issue Types)
On site the guys register occurrences of different issue types against each Build as they happen.
I want to produce a report on each build that summarises the build and gives information about what issues we had and how frequently they occurred. I have a Page Designer Report done up based off the Build Table. When I drop the linked field to Issue Occurrences onto the page it gives me a list of all Issue Occurrences. What I actually want is a summarised list of these occurrences. This would be solved with a Group By operation normally but that is not available in the Page Designer Options and the Group By function for the Issue Occurrences View does not seem to affect what is displayed in the report.
Can anyone think of a clever way of doing this?
Thanks in advance,
p.s I want to put an image of my report in here which i have amended in paint to show you what i want but it wont allow me…Let me know if there is anything else I can do to help you understand the issue.