Job Report-CORRECTION

Todd,

Is it possible to get a synopsis of these (Report Builder) performance
tips, or are they posted somewhere that I haven't looked?

Dan Maddox
Pactiv Corp

At 11:00 AM 10/10/2003 -0500, you wrote:
>Just a thought....but on what usually is a HUGE table like LaborDtl maybe
>using seperate date tests (>= and <=) rather than In-Range would yield a
>lot better performance. In-Range forces processing to the client rather
>than at the server and can be 10 times slower. If you have several years
>of labor data it can make a big difference. I generally avoid In-Range
>and In-List per the great RB Performance Tips session at the 1999 user
>conference (pre-Perspectives) give by Mark Pladson. I've had reports go
>from 3+ hrs down to 30 seconds to run.
>
>-Todd C.
>
>-----Original Message-----
>From: Karen Brodniak [mailto:karen.brodniak@...]
>Sent: Friday, October 10, 2003 10:52 AM
>To: vantage@yahoogroups.com
>Subject: RE: [Vantage] Job Report-CORRECTION
>
>
>Spell Check changed the name of the master table--master table should be
>LaborDtl.
>
>Karen Brodniak
>Accounting Manager
>425-742-7011 X44
>Fax 425-353-8945
>karen.brodniak@...
>
>-----Original Message-----
>From: Jim Horton [mailto:jim.horton@...]
>Sent: Friday, October 10, 2003 6:05 AM
>To: vantage@yahoogroups.com
>Subject: [Vantage] Job Report
>
>
>I'm trying to make a report in report builder that will tell me how many
>hours were on a job during the week, and also give me the total hours on the
>same job. Anybody have anything close to this or can point me in the
>correct direction.
>
>
>
>Jim Horton
>Information Systems
>Tel: 269-668-3377
>Fax: 269-668-5132
>www.Mol-Son.com
>
>
>
>Yahoo! Groups Sponsor
>
>ADVERTISEMENT
>
>< http://rd.yahoo.com/M=244522.3707890.4968055.1261774/D=egroupweb/S=17050071
>83:HM/A=1595054/R=0/SIG=124ukap9t/* http://ashnin.com/clk/muryutaitakenattogy
>o?YH=3707890&yhad=1595054> Click Here!
>
>< http://us.adserver.yahoo.com/l?M=244522.3707890.4968055.1261774/D=egroupmai
>l/S=:HM/A=1595054/rand=161098183>
>
>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/.
>< http://groups.yahoo.com/group/vantage/files/.>
>(2) To search through old msg's goto:
>http://groups.yahoo.com/group/vantage/messages
>< 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
>< http://groups.yahoo.com/group/vantage/links>
>
>Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
>< http://docs.yahoo.com/info/terms/> .
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>Yahoo! Groups Sponsor
>
><http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>
>
>
><http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=436392987>
>
>
>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
><http://docs.yahoo.com/info/terms/> .
>
>
>
>
>[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/
Hi Gang,
Â
Does anyone out there have a decent job cost report similar to what I have
below?  Basically it is a quick way to compare profitability over a series
of jobs.  I used report builder and have a join that is multiplying the
number of "Man Hours" times the number of shipments from the job. If there
is 1 shipment or a receipt to inventory, it works fine. Two shipment from a
job, and it doubles.  My report may be clunky, JobHead - JobAsmbl, JobHead -
JobProd, JobHead - Part, JobHead -Â LaborDtl, JobHead - OrderDtl
Â
Any useful tips or reports would be greatly appreciated. Incidentally, this
is the form of a report from the old system that the bosses are used to
seeing, so I was trying to replicate it best as I can.


Thanks,

Daniel C. Spoerl
Estimator/MIS Manager
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax:Â Â Â (419) 535-0565Â
Personal E-fax: (707) 897-1708Â
Email:Â Â Â HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
"http://www.toledometalspinning.com/"http://www.toledometalspinning.com
HYPERLINK "http://www.toledometalspinning.com/products_configurator.htm" \n



Â


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002




[Non-text portions of this message have been removed]
Dang it stripped out my image:

Here is what I have so far:

Job# Qty Shipped Last Date ship Matl Cost Total Man Hours Unit$ Tot Rev.
Sub Cost Lab&Bur Cost Total Cost
033259 57 11/8/02 $196.61 33.64 $21 $1,197.00 0 $2075.82 $2,272.43
033005 30 9/23/02 $ 99.00 20.96 $21 $ 630.00 0 $1459.66 $1,558.66


Thanks,
Dan


-----Original Message-----
From: dans@... [mailto:dans@...]
Sent: Monday, November 11, 2002 2:58 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Job Report


Hi Gang,
Â
Does anyone out there have a decent job cost report similar to what I have
below?  Basically it is a quick way to compare profitability over a series
of jobs.  I used report builder and have a join that is multiplying the
number of "Man Hours" times the number of shipments from the job. If there
is 1 shipment or a receipt to inventory, it works fine. Two shipment from a
job, and it doubles.  My report may be clunky, JobHead - JobAsmbl, JobHead -
JobProd, JobHead - Part, JobHead -Â LaborDtl, JobHead - OrderDtl
Â
Any useful tips or reports would be greatly appreciated. Incidentally, this
is the form of a report from the old system that the bosses are used to
seeing, so I was trying to replicate it best as I can.


Thanks,

Daniel C. Spoerl
Estimator/MIS Manager
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax:Â Â Â (419) 535-0565Â
Personal E-fax: (707) 897-1708Â
Email:Â Â Â HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
"http://www.toledometalspinning.com/"http://www.toledometalspinning.com
HYPERLINK "http://www.toledometalspinning.com/products_configurator.htm" \n



Â


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002




[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/


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002
Anyone have a RB report that shows completed jobs and give an efficiency % for each job and operation? We have been using the canned "Production Detail" report, but it is very cumbersome to select "closed", type in part number, then select the proper job from the list. an RB report that shows all jobs by part number would be a lot easier for us. Maybe this has been improved with the newer releases of Vantage?

I looked in the files area of the Yahoo Groups, but none popped out at me.

Thanks,
John Mueske
Hiatt Manufacturing, Inc.
Vantage 5.00.331

[Non-text portions of this message have been removed]
I'm trying to make a report in report builder that will tell me how many hours were on a job during the week, and also give me the total hours on the same job. Anybody have anything close to this or can point me in the correct direction.



Jim Horton
Information Systems
Tel: 269-668-3377
Fax: 269-668-5132
www.Mol-Son.com
You should be able to use Laborite as your Master Table and get all the
information you need from this same table. Filter the report using
Laborite.ClockInDate IN-RANGE 10/05/203,10/11/2003 (example).

Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...

-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Friday, October 10, 2003 6:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Report


I'm trying to make a report in report builder that will tell me how many
hours were on a job during the week, and also give me the total hours on the
same job. Anybody have anything close to this or can point me in the
correct direction.



Jim Horton
Information Systems
Tel: 269-668-3377
Fax: 269-668-5132
www.Mol-Son.com



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=244522.3707890.4968055.1261774/D=egroupweb/S=17050071
83:HM/A=1595054/R=0/SIG=124ukap9t/*http://ashnin.com/clk/muryutaitakenattogy
o?YH=3707890&yhad=1595054> Click Here!

<http://us.adserver.yahoo.com/l?M=244522.3707890.4968055.1261774/D=egroupmai
l/S=:HM/A=1595054/rand=161098183>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
Spell Check changed the name of the master table--master table should be
LaborDtl.

Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...

-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Friday, October 10, 2003 6:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Report


I'm trying to make a report in report builder that will tell me how many
hours were on a job during the week, and also give me the total hours on the
same job. Anybody have anything close to this or can point me in the
correct direction.



Jim Horton
Information Systems
Tel: 269-668-3377
Fax: 269-668-5132
www.Mol-Son.com



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=244522.3707890.4968055.1261774/D=egroupweb/S=17050071
83:HM/A=1595054/R=0/SIG=124ukap9t/*http://ashnin.com/clk/muryutaitakenattogy
o?YH=3707890&yhad=1595054> Click Here!

<http://us.adserver.yahoo.com/l?M=244522.3707890.4968055.1261774/D=egroupmai
l/S=:HM/A=1595054/rand=161098183>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
Just a thought....but on what usually is a HUGE table like LaborDtl maybe using seperate date tests (>= and <=) rather than In-Range would yield a lot better performance. In-Range forces processing to the client rather than at the server and can be 10 times slower. If you have several years of labor data it can make a big difference. I generally avoid In-Range and In-List per the great RB Performance Tips session at the 1999 user conference (pre-Perspectives) give by Mark Pladson. I've had reports go from 3+ hrs down to 30 seconds to run.

-Todd C.

-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Friday, October 10, 2003 10:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Job Report-CORRECTION


Spell Check changed the name of the master table--master table should be
LaborDtl.

Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...

-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Friday, October 10, 2003 6:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Report


I'm trying to make a report in report builder that will tell me how many
hours were on a job during the week, and also give me the total hours on the
same job. Anybody have anything close to this or can point me in the
correct direction.



Jim Horton
Information Systems
Tel: 269-668-3377
Fax: 269-668-5132
www.Mol-Son.com



Yahoo! Groups Sponsor

ADVERTISEMENT

< http://rd.yahoo.com/M=244522.3707890.4968055.1261774/D=egroupweb/S=17050071
83:HM/A=1595054/R=0/SIG=124ukap9t/* http://ashnin.com/clk/muryutaitakenattogy
o?YH=3707890&yhad=1595054> Click Here!

< http://us.adserver.yahoo.com/l?M=244522.3707890.4968055.1261774/D=egroupmai
l/S=:HM/A=1595054/rand=161098183>

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/.
< http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
< 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
< http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/> .




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



Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=436392987>

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 <http://docs.yahoo.com/info/terms/> .




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