data duplication issue. Please advise.
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.
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.