Thank you so much for the help.
It is so easy to make that report now,
Thanks to Troy also for another suggestion.
It is so easy to make that report now,
Thanks to Troy also for another suggestion.
Part.method is the field in the part table that says whether a part has a
method or not.
Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com
"Helping Business Make Intelligent Use of Technology"
-----Original Message-----
From: sharma_nalini [mailto:sharma_nalini@...]
Sent: Tuesday, October 15, 2002 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Report for those BOM is created
I have to make a report with just few fields
Partnum, Part Description, BOM = yes/no
But i am not able to find out the relation ship ir the feild which
tells me that.
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/
method or not.
Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com
"Helping Business Make Intelligent Use of Technology"
-----Original Message-----
From: sharma_nalini [mailto:sharma_nalini@...]
Sent: Tuesday, October 15, 2002 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Report for those BOM is created
I have to make a report with just few fields
Partnum, Part Description, BOM = yes/no
But i am not able to find out the relation ship ir the feild which
tells me that.
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/
In Crystal, I would join Part table to PartMtl table with a Left Outer Join. Link Part.PartNum --> PartMtl.PartNum and Part.company --> Part.company.
In the report, use a formula.
If isnull({PartMtl.PartNum}) then NO
else YES.
The isnull({PartMtl.PartNum} statement will be TRUE if there is no matching PartMtl.PartNum (ie. No BOM for that part).
You might get duplicate records in this report if there is more than one REV for the PartMtl.PartNum. To eliminate these duplicates, Join the PartRev table to the PartMtl table by PartNum and by RevisionNum. Then filter the report by the "PartRev.Approved" field.
Troy Funte
Liberty Electronics
In the report, use a formula.
If isnull({PartMtl.PartNum}) then NO
else YES.
The isnull({PartMtl.PartNum} statement will be TRUE if there is no matching PartMtl.PartNum (ie. No BOM for that part).
You might get duplicate records in this report if there is more than one REV for the PartMtl.PartNum. To eliminate these duplicates, Join the PartRev table to the PartMtl table by PartNum and by RevisionNum. Then filter the report by the "PartRev.Approved" field.
Troy Funte
Liberty Electronics
----- Original Message -----
From: sharma_nalini
To: vantage@yahoogroups.com
Sent: Tuesday, October 15, 2002 11:01 AM
Subject: [Vantage] Part Report for those BOM is created
I have to make a report with just few fields
Partnum, Part Description, BOM = yes/no
But i am not able to find out the relation ship ir the feild which
tells me that.
Yahoo! Groups Sponsor
ADVERTISEMENT
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 the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]