Thad:
Is there a reason that you don't use the summary only version of Vantage's
existing Production Detail Report? That might put you out of your misery,
and it is current with data collection, purchasing and so - on, plus gives a
nice little comparison between actual and estimated... If you do the
summary, select one job and it takes about two seconds to print.
Just an idea from the trenches.
Yes, I know the print is small.
Lydia
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Monday, May 21, 2001 11:42 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage]
I'm having some trouble writing a particular reportbuilder report.
What I want to do is to list, for a particular job, list the total in-house
operations cost and hours, the total subcontract cost and hours, and the
total cost of materials. I am using JobOper to pull the Operations costs,
linking it to the JobHead, the master table, by Jubnum.
This works fine, until I try to link the materials table to JobNum. When I
do so, I get duplicate operation entries, one duplicate for every material
line.
Am I using the wrong master table? Is there any way to get a materials
total cost on the same Reportbuilder Report with operations total cost?
Thanks in advance for your help.
Best regards,
Thaddeus
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Is there a reason that you don't use the summary only version of Vantage's
existing Production Detail Report? That might put you out of your misery,
and it is current with data collection, purchasing and so - on, plus gives a
nice little comparison between actual and estimated... If you do the
summary, select one job and it takes about two seconds to print.
Just an idea from the trenches.
Yes, I know the print is small.
Lydia
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Monday, May 21, 2001 11:42 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage]
I'm having some trouble writing a particular reportbuilder report.
What I want to do is to list, for a particular job, list the total in-house
operations cost and hours, the total subcontract cost and hours, and the
total cost of materials. I am using JobOper to pull the Operations costs,
linking it to the JobHead, the master table, by Jubnum.
This works fine, until I try to link the materials table to JobNum. When I
do so, I get duplicate operation entries, one duplicate for every material
line.
Am I using the wrong master table? Is there any way to get a materials
total cost on the same Reportbuilder Report with operations total cost?
Thanks in advance for your help.
Best regards,
Thaddeus
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/