If you are using report builder their are a couple of ways to fix this: A
simple approach would be to add a "COUNTER" type calculated field. Count
each time that job duplicates that is messing you up. Then on the report you
can create additional calculated fields for the information you want such as
MYJOBQTY = IIF(COUNTER =1,JOBHEAD.PRODQTY,0). Then run an aggregate on
MYJOBQTY to get the part total or whatever your looking for. The sorts &
groups can get a little confusing with this but I Hope this helps.
Patrick Winter
-----Original Message-----
From: B_Stinger [mailto:bstenglein@...]
Sent: Friday, December 21, 2001 8:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Reports with Customer Name
There is a recurring problem that I face when dealing with the
Vantage Database. When asked to create a report dealing with Job
information I am invariably asked to include the Customer Name with
the job. I understand that Customers are only directly linked to the
Sales Order and that I need to use the Job Prod table to link the Job
with the Order. The Problem I always face is that if an order has
more that one release, I get duplicated records, because the Job Prod
table contains the Order # once for each release. This makes doing
any sort of calculation of Job Data, difficult if not impossible,
when adding the Customer Name, at least with the skills that I have.
What would be great is to have a One to One link between the Job and
the Order, or a field in the Job tables somewhere that can reference
a customer number that it is being made for. Does anybody else
struggle with this problem? Are there reporting techniques to work
around it that I'm not aware of? I know in Crystal you can suppress
duplicates, but they still add up in the calculation, eventhough you
don't see them. If there is some interest out there I was thinking
of sending a request to Mark Pladson to see if something could be
done.
Brian Stenglein
Clow Stamping Co.
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/
simple approach would be to add a "COUNTER" type calculated field. Count
each time that job duplicates that is messing you up. Then on the report you
can create additional calculated fields for the information you want such as
MYJOBQTY = IIF(COUNTER =1,JOBHEAD.PRODQTY,0). Then run an aggregate on
MYJOBQTY to get the part total or whatever your looking for. The sorts &
groups can get a little confusing with this but I Hope this helps.
Patrick Winter
-----Original Message-----
From: B_Stinger [mailto:bstenglein@...]
Sent: Friday, December 21, 2001 8:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Reports with Customer Name
There is a recurring problem that I face when dealing with the
Vantage Database. When asked to create a report dealing with Job
information I am invariably asked to include the Customer Name with
the job. I understand that Customers are only directly linked to the
Sales Order and that I need to use the Job Prod table to link the Job
with the Order. The Problem I always face is that if an order has
more that one release, I get duplicated records, because the Job Prod
table contains the Order # once for each release. This makes doing
any sort of calculation of Job Data, difficult if not impossible,
when adding the Customer Name, at least with the skills that I have.
What would be great is to have a One to One link between the Job and
the Order, or a field in the Job tables somewhere that can reference
a customer number that it is being made for. Does anybody else
struggle with this problem? Are there reporting techniques to work
around it that I'm not aware of? I know in Crystal you can suppress
duplicates, but they still add up in the calculation, eventhough you
don't see them. If there is some interest out there I was thinking
of sending a request to Mark Pladson to see if something could be
done.
Brian Stenglein
Clow Stamping Co.
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/