Where can I find expense report approvers?

[npham578]

Hi. I am trying to produce a report that shows expense report number, expense submitted by, and who is the expense approver. Is this possible via Query Studios. Thanks.

[KevinD]

@npham578 this is possible. If you are familiar with building reports in Query Studio than you would just need to add the following data items to the report:

1. Employee

2. Report Name or Report ID

3. Default Approver

Those are the bare minimum data items based on what you stated in your post. Obviously you can add more if you would like.

If you aren't sure where any of the data items I listed are located, you can use the Search option in Cognos 11.

Let me know if you have any issues.

[npham578]

Hi Kevin,

Is it correct to use  "submitted by a delegatee" and "approved by a delegatee" in addition to the fields you listed? 

So is "delegate name" only at the report header level? Is there a way to populate the field for every item?

Thanks.