SSRS Proforma Duplicating Misc Charge

[TomAlexander]

Was either ShipToNum or ConNum an excluded column in the RDD?

[BKen (Brian Ken)]

Tom,
No, ShipToNum and ShpConNum were not excluded on Order Header:

and ShipToNum and ConNum were not excluded on CustCnt:

[jkane (John Kane)]

Never use the key field. Always leave it blank.

[BKen (Brian Ken)]

John,
Can you explain why? The field help does not sound too ominous.

[jkane (John Kane)]

Just from experience, I forget when I figured it out. Anytime I have tried using that field the report won’t work. Once I remove it it generally does.