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

[KevinD]

@ankurlm10 if you look at the amounts of each, they are not the same. Can you send me a private message with the name of the employee this report belongs to so I can see the entire audit trail, please? 

[KevinD]

@ankurlm10 did you ever get this resolved? I haven't heard anything back from you.