COGNOS reporting - removing duplicates

[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 hello there. I'm not sure I understand how a single report could be paid on two dates. Could you provide some clarification on this please? Do you have a screenshot of this report you could share that shows the report's column titles and some data. Be sure to remove any employee names. I'd like to see exactly what you are seeing. 

[ankurlm10]

As you will see the same report paid on 23 and 24 of December. Hope i am able to clarify