Team,

I created a query by joining 2 queries to get the list of card transactions assigned to report but not submitted and send back to user. from this query, created a cross tab report to get the count of transactions based on countries.

now the issues is, we have mpre than 200K transactions in concur in above status. But report is not running as expected, report is still running for more than 2hrs returns no data.

Please confirm if we have any easy way to get the count of card transactions which are assigned to an expense report and the expense report is not submitted and send back to employee.

Note: i have the similar cross tab report to get teh count of unassigend card transaction based on country, which takes 30 mins to run and got the expected data.