Cognos report not populating recent transactions

[PMAbrego]

I am attempting to create a query report for all Hotel transactions for a specific employee however the two most recent transactions are not included in the report? I can see them listed in the expense transaction list.

Report is needed for tax purposes.

thank you

[KevinD]

@PMAbrego could you take a screenshot of your report please so I can see the data items you used? No need to run the report, I just need to see what it looks like in Edit mode. 

[PMAbrego]

[KentCognosGuy]

Hi, I had this problem a while back. It turned out to be the Database driver I was using at the time in Cognos. I was running against an Oracle DB. I switched to native Oracle DB Driver which resolved the problem.