data duplication issue. Please advise.

[Former Member]

Hi,

I created a multiprovider on notification item and causes. I need Cause code from causes and Damage code from Items. When i report on this multiprovider data is getting duplicated.

I tried. Excluding # one's it's wprking but missing out some records like the notifications without cause code/damage code. But i want all the notifications to be displayed in my report without duplications.

I tried infoset option there also same issue Not all the notifications in Items are not there in causes.

I think multiprovider can solve the issue if i keep cause code or damage code in free chars but they want both to be displayed in the report.

I appreciate your response.

Thanks,

Naveen

[Former Member · Accepted solution]

I would combine this data first in an ODS. That will combine the data for you and you can report on a single line granted you create the ODS key properly.

Brian