Approval Status Cognos

[nlynch91]

Hi All,

Hoping you can help here. I have a report created here but i need to filter for these statuses in green. As you can see, i have created a filter to the report for approval status which has these statuses associated to it. When i run the report, all i see is status approved and none of these statuses below? Can you advise if this is filtering out the statuses i have in the filter and is only showing approval statuses that don't have them or am i adding these statuses incorrectly? Also there is a prompt on the report, can i ask, does anyone know why the options ' run prior week' etc are available on the left hand side 'screenshot attached'. When you select one, the date doesn't update, you still have to do it manually..Its the same for 'earliest date' button. This also doesn't change the date? Any links would be helpful here also.

Cheers,

Niall 

[Khayan]

Hello Niall,
Let me try to help with some infos. First of all, it seems you are using a customized report, so some behaviors here could be different from the standard reports already available in the system.
About the prompt selection. There you have 3 options:
*Run Prior Week
*Run Prior Month
*Use Date Range
My understand is that only when you select the option 'Use Date Range' the filter will need your selection in the calendar date.
If you select 'Prior Week' or 'Prior Month' no action is required in the calendar.

I believe your 'Approval Status' is not working once the options added don't match with the options available for the field 'Approval Status'.
You will need to filter for the options available, for example the ones available in the column 'Status' of your screenshot, as Approved, Sent Back to Employee,  Submitted & Pending Approval, etc.

Hope it helps you! 🙂

[KevinD]

@nlynch91 what is the name of the report you are working with and is there a copy of it in your My Content folder?

[nlynch91]

Thanks All,

I think we've sorted this since.

Cheers,

Niall