Report Builder help with DMR and Reason Codes

Hi,
Yes, I had that thought also, but the ReasonType field is not in the
DMR table.
Thanks,
Judy


Message: 2
Date: Fri, 4 Oct 2002 07:55:37 -0500
From: "Winter, Patrick" <pjw@...>
Subject: RE: Report Builder help with DMR and Reason Codes

You should try to use the Reason.ReasonType field in the join.
The primary index is Company, ReasonType, ReasonCode.
This would just select the DMR or Material reason and not duplicate.

Patrick

-----Original Message-----
From: Judy Stauduhar [mailto:jstauduhar@...]
Sent: Thursday, October 03, 2002 4:49 PM
To: Vantage@Yahoogroups. Com (E-mail)
Subject: [Vantage] Report Builder help with DMR and Reason Codes


Hi,
I have a problem on a report with repeating entries, and I think I
know why but not sure if I can do anything about it. It is a DMR report for
our suppliers. The problem is that I have the DMRActn table linked to the
reason code table, so I can get the reason description to print out on the
report. On the DMRActn table you can only link through reason code, not
reason type. Somehow we have the same reason code in DMR's and Inventory
Adjustments. These are the ones we are getting repeat entries on. Any
ideas?
Thanks,
Judy
Hi,
I have a problem on a report with repeating entries, and I think I
know why but not sure if I can do anything about it. It is a DMR report for
our suppliers. The problem is that I have the DMRActn table linked to the
reason code table, so I can get the reason description to print out on the
report. On the DMRActn table you can only link through reason code, not
reason type. Somehow we have the same reason code in DMR's and Inventory
Adjustments. These are the ones we are getting repeat entries on. Any
ideas?
Thanks,
Judy
You should try to use the Reason.ReasonType field in the join.
The primary index is Company, ReasonType, ReasonCode.
This would just select the DMR or Material reason and not duplicate.

Patrick

-----Original Message-----
From: Judy Stauduhar [mailto:jstauduhar@...]
Sent: Thursday, October 03, 2002 4:49 PM
To: Vantage@Yahoogroups. Com (E-mail)
Subject: [Vantage] Report Builder help with DMR and Reason Codes


Hi,
I have a problem on a report with repeating entries, and I think I
know why but not sure if I can do anything about it. It is a DMR report for
our suppliers. The problem is that I have the DMRActn table linked to the
reason code table, so I can get the reason description to print out on the
report. On the DMRActn table you can only link through reason code, not
reason type. Somehow we have the same reason code in DMR's and Inventory
Adjustments. These are the ones we are getting repeat entries on. Any
ideas?
Thanks,
Judy


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/