Reporting

[Ajith A Pillai]

Hi All, 

I have a requirement to create a report which is rejected at any of the stages

For e.g,: In a RITM we have set 4 levels of approvals i.e. two of them group level approvals and 2 of them are from users manager and department head.

I wanted  to generate a report like how much request are rejected from the first group and how are rejected by second group even first level has been approved. Although even approved from both the group level, need to showcase how much are rejected by manager and how much are rejected by Department head.

How can we achieve this report. Is any one implemented such reports, please help me with the full steps to achieve this.

Thanks in Advance!!

Regards

Ajith

[Mark Manders]

You will need to have some kind of reference to define which approval is in which step (even if it's just in the description of the approval). Otherwise it will just be a count of the number of approvals/rejects.

What is the purpose of this report? What value will this report bring? What is the goal behind the data? What do you want to improve?

If you have a way of identifying the approval steps, you could create a database view and create a report on that.