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.
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 🙂