bringing list of Incidents onto a Problem Report

[mrswann]

Greetings!

We have a requirement for a Problem Report. There is a field called "related_incidents" which contains a count of related Incidents.

There is a related list on the Problem form of all the related incidents.

Is there anyway to pull a list of these incident numbers, into a column, for reporting against Problems?

[Blaze2]

I was able to do something similar through the incident table.

It gave me the list of incidents (NUMBER) with the list of associated Problems (Problem)

You can also group by Problem and get a list of all of the associated incidents

[mrswann]

Thanks - I know this could be useful from some angles. Unfortunately this requirement is really around a PDF/export scheduled report.

All incidents in one column would be best if this is possible I cannot see how.

[Blaze2]

Yeah, I have been looking since last night and the way the system is set up it is not going to give you what you need, Incidents in 1 column.

Maybe you can submit an enhancement request to SN and see if this is something they may work on for the next release?

The only other possible way is an individual report for each problem which I know you do not want to do. but it would give you a label of the problem number and list of the incidents.

[johnbarber_now_]

Hi,

Blaze was on the right path, the best way to get a report of all the incidents under a specific PRB is to go off the Incident Table in reporting and filter for the PRB you are wanting to report upon. If you don't choose to "group by problem", you will get a simple list of INTs, you can add some cleanliness to your list by adding a sort field and sort on PRB Number. Then schedule the report delivery and you should be good to go.

Note: If your list of PRB to report is long your query can get inefficient pretty quickly and in general reporting on static set of PRB# is challenging to manually maintain, so I would recommend putting a Tag on the PRBs you want in your report or a checkbox field in the PRB form, basically anything to designate the PRB as needing to be in your report, then you can filter on that designation that value, instead of a static PRB number, by:

1. Opening the "Show Related Fields" option at the bottom of your filter list: (Note: you may need to expose this option using Instance properties)

2. Find "Problem ===> Problem Fields

3. This will change the Filtered list of fields to all the PRB fields and you can then select the distinguishing field/tag you have set up and get all the PRB you want to report upon, and bring them into your list. This way you can dymaically control what data flows into the report, by simply marking the PRB that need to be on the report before it gets sent out.

I hope this helps to answer your question and you to build the reports, if it does please mark it as such.

Thank you

John B