Cognos - Join Travel Request with Expense Reports

[oziel-alvarez]

Hello Everyone.

Is there any way I can make a report in Cognos where I can pull Travel requests that don't have expense reports?

Please let me know your findings.

Thank you!

[I344424]

Hi,

You can use the standard report below built by Concur. The report will display all completed TR that do not have a Travel Request line item associated to a report entry.

Public Folders ‎> Intelligence/Analysis - Standard Reports ‎> Travel Request‬ > Completed Travel Requests Without Expense Reports

In the report, the join is matching the Travel Request Entry Key between Travel Requests and Expense Entries. The report results are showing travel request entries that don’t have a matching expense entry. 

Hope this helps 🙂