Do you need the materials details or just the total? If you are only
looking for the total, you can get that from the JobAssembly Table...
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Monday, May 21, 2001 2:42 PM
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/
looking for the total, you can get that from the JobAssembly Table...
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Monday, May 21, 2001 2:42 PM
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/