Adding field info of different Record lines

system · January 18, 2002, 4:52pm

If you did this in Crystal, you could Create a formula which would extract the matching part of the job number (less the -rw part) such as Left({JobNum},4). Then create your Job Group on the Formula rather than just the Job Number. This will lump job 1234 with 1234-rw into the same group. That way you can combine SUM calculations for the group.

Just an idea.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Dennis Houghton
To: vantage@yahoogroups.com
Sent: Friday, January 18, 2002 2:44 PM
Subject: [Vantage] Adding field info of different Record lines

Hello Group,
maybe someone out there can help with this.
I have a job costing ratio report that list the closed jobs by date range.
Each record line shows the total cost of the job and the sales dollars and gives a ratio. Here is the problem I have, we create a seperate job in vantage for the rework.
It has the same job number as the original job except it has a -rw after it. On reports the rework job will show up immediately under the original job. This is good and all costs of the original job and the rework job appear on the report together. The problem lies in that I have to manually calculate the parent job and rework job costs together and ratio to sales dollars on the report. sometimes there are several rework jobs on each report and can get time consuming. Is there a way to get this done by calculations and conditional printing or something automatic when the report is ran? I'm not sure how to go about this. maybe an if statement when a job with "-rw" shows to perform calcualtions? maybe not, oh well, thanks in advance
anyway.
dennis

[Non-text portions of this message have been removed]

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]

system · January 18, 2002, 2:42pm

Hello Group,
maybe someone out there can help with this.
I have a job costing ratio report that list the closed jobs by date range.
Each record line shows the total cost of the job and the sales dollars and gives a ratio. Here is the problem I have, we create a seperate job in vantage for the rework.
It has the same job number as the original job except it has a -rw after it. On reports the rework job will show up immediately under the original job. This is good and all costs of the original job and the rework job appear on the report together. The problem lies in that I have to manually calculate the parent job and rework job costs together and ratio to sales dollars on the report. sometimes there are several rework jobs on each report and can get time consuming. Is there a way to get this done by calculations and conditional printing or something automatic when the report is ran? I'm not sure how to go about this. maybe an if statement when a job with "-rw" shows to perform calcualtions? maybe not, oh well, thanks in advance
anyway.
dennis

[Non-text portions of this message have been removed]

system · January 18, 2002, 3:01pm

Try a calculated field using SUBSTRING and PREVIOUS commands.
IIF(SUBSTRING(JOBNUMBER,?,?) = "-rw",PREVIOUS(JOBCOSTS) + JOBCOSTS,0)

I hope you get the idea, the syntax and database record field names in the
example are not exact.

Just an idea.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a

-----Original Message-----
From: Dennis Houghton [mailto:dennis@...]
Sent: Friday, January 18, 2002 1:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding field info of different Record lines

Hello Group,
maybe someone out there can help with this.
I have a job costing ratio report that list the closed jobs by date range.
Each record line shows the total cost of the job and the sales dollars and
gives a ratio. Here is the problem I have, we create a seperate job in
vantage for the rework.
It has the same job number as the original job except it has a -rw after it.
On reports the rework job will show up immediately under the original job.
This is good and all costs of the original job and the rework job appear on
the report together. The problem lies in that I have to manually calculate
the parent job and rework job costs together and ratio to sales dollars on
the report. sometimes there are several rework jobs on each report and can
get time consuming. Is there a way to get this done by calculations and
conditional printing or something automatic when the report is ran? I'm not
sure how to go about this. maybe an if statement when a job with "-rw" shows
to perform calcualtions? maybe not, oh well, thanks in advance
anyway.
dennis

[Non-text portions of this message have been removed]

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/