Report Builder Help!

Yahoo Archive
1
Joy,
Go into your joins and make them left outer joins, that might help.

Warren R. Eddy
Information Services Manager
National Tube Form
A Leggett & Platt Company
Phone: (219) 478-2363 ext 217
Fax: (219) 478-1043
Warren.Eddy@...

-----Original Message-----
From: jfekkes@... [mailto:jfekkes@...]
Sent: Friday, November 02, 2001 1:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Builder Help!

Sarah,

Thank you. I think this is getting me closer... I have changed the
report and joined the RcvDtl to the JobOper. However, it is now
excluding many receivers. I am working on the report to see what is
common with the receivers that did print on report.

Your recommendation about getting costs for invoices was a great
idea. As we did find many discrepancies...but they want what
actually was received for the month. I am actually trying to match
up against accountings report, which is just by vendor not particular
plating processes (and they used receivers).

I'll try talking them into using invoices.

Joy

In vantage@y..., sarah.vareschi@n... wrote:
> I would try joining rcvDtl to JobOper than joboper to jobasmbl
>
> Another thing to consider is if the costs entered at receiving are
always
> accurate. If, not, it may be better to get the cost from the
invoice
> detail.
>
> HTH,
>
> Sarah


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/
2
After much frustration...I have given up...any help anyone could provide
will be appreciated.
I have been trying to create a report to capture our costs for
Subcontracting by Vendor by Oper Code (we subcontract out our plating, but
without PO's...therefore we would have to look at Rcvdtl and JobOper tables
to gain the dollars from Rcvdtl and the OperCode for the type of plating
(which is the only place we are recording the type of plating).

The report works fine, however, there are jobs that have two subcontract
routing steps. The report seems to look at both and then repeat the
receiving information twice for both routing steps.

Tables are joined as such: RcvDtl to Vendor
RcvDtl to JobAsmbl
JobAsmbl to JobOper

Thanks in advance,

Joy Fekkes
Jaco, Inc
140 Constitution Blvd.
Franklin, MA 02038
Email: jfekkes@...
Website: www.jacoinc.com
3
I would try joining rcvDtl to JobOper than joboper to jobasmbl

Another thing to consider is if the costs entered at receiving are always
accurate. If, not, it may be better to get the cost from the invoice
detail.

HTH,

Sarah
4
Joy -

Don't forget to filter the RcvDtl.JobSeqType as "S" for subcontract
and the join needed between RcvDtl.JobSeq and JobOper.OprSeq.

Hope this helps,

Misha 1, Ltd.
Calvin Dekker
Tel: 630-893-1305
Fax: 630-893-1307
email: calvin@...
-----Original Message-----
From: Fekkes, Joy [mailto:jfekkes@...]
Sent: Friday, November 02, 2001 7:31 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Builder Help!


After much frustration...I have given up...any help anyone could provide
will be appreciated.
I have been trying to create a report to capture our costs for
Subcontracting by Vendor by Oper Code (we subcontract out our plating, but
without PO's...therefore we would have to look at Rcvdtl and JobOper
tables
to gain the dollars from Rcvdtl and the OperCode for the type of plating
(which is the only place we are recording the type of plating).

The report works fine, however, there are jobs that have two subcontract
routing steps. The report seems to look at both and then repeat the
receiving information twice for both routing steps.

Tables are joined as such: RcvDtl to Vendor
RcvDtl to JobAsmbl
JobAsmbl to JobOper

Thanks in advance,

Joy Fekkes
Jaco, Inc
140 Constitution Blvd.
Franklin, MA 02038
Email: jfekkes@...
Website: www.jacoinc.com


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]
5
Sarah,

Thank you. I think this is getting me closer... I have changed the
report and joined the RcvDtl to the JobOper. However, it is now
excluding many receivers. I am working on the report to see what is
common with the receivers that did print on report.

Your recommendation about getting costs for invoices was a great
idea. As we did find many discrepancies...but they want what
actually was received for the month. I am actually trying to match
up against accountings report, which is just by vendor not particular
plating processes (and they used receivers).

I'll try talking them into using invoices.

Joy

In vantage@y..., sarah.vareschi@n... wrote:
> I would try joining rcvDtl to JobOper than joboper to jobasmbl
>
> Another thing to consider is if the costs entered at receiving are
always
> accurate. If, not, it may be better to get the cost from the
invoice
> detail.
>
> HTH,
>
> Sarah