Report on Risk Assessment answers

[Mickey_Cegon]

I need to create a report that gives me the answers to the Risk Assessments on Change Requests. No matter how I do this, I'm coming up empty. I see that the responses are in the survey_response table, but I don't see where the Task number field is. I see that on the Change Request, the Risk Assessment Related List is the task_assessment table. But, if I write a report on the task_assessment table, I only get the regular Helpdesk survey responses. I really would like to do something where my Change Manager can see all the responses for a Risk Assessment, grouped by Change Request Number. I would have liked to do a Pivot Table similar to the Helpdesk Survey pivot table reports, but the answers to my Risk Assessment are not numerical, they are Yes/No and High/Med/Low, etc.

Would I need to create a Database view? I see the Task number when I look at the Risk Assessment Related List, but how do I tie that together with the actual answers to the Risk Assessment?

Any help would be appreciated.

Mickey Cegon
FBL Financial Group, Inc.

[madhvi]

Hi,

i am working in Fuji.I tried creating report way you have done,but in output got only 1 change task in report.

[drewnorman]

Does this feature still work in Istanbul?