COGNOS reporting Duplicate entries

[ankurlm10]

Hello Everyone,

I need help with a COGNOS report. Our daily report includes details of paid expense reports based on the payment confirmation date. If a single expense report is paid on two dates, Cognos sends records for both dates, causing duplicate entries in the receiving application.

I want to restrict Cognos from sending data on the second payment date. Data is needed only for the first payment confirmation date.

If you have a similar report, I'd appreciate your insights.

Thank you!

[KevinD]

@ankurlm10 I replied to the post you made in another forum. 

For future reference, you shouldn't need to post in multiple forums as I am on the Community daily and looking at all new posts. 🙂

You have to give some time for myself or others to see your post as we are likely in different time zones than you.