Showing results for 
Search instead for 
Did you mean: 
Occasional Member - Level 2

Cognos - Join Travel Request with Expense Reports

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!

SAP Concur Employee
SAP Concur Employee



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 🙂