Inspection Que report

Jasper,

FirstArt is the table.


Patrick Winter
Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Wednesday, July 20, 2005 12:22 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Inspection Que report

Is there a way to create a "time" report that gives a listing of everything
in the "inspection" que awaiting approval, the "date: & time" it got in
there and a accumulated time??

Sample
12323221-1 receipt 7/18/05 9:05 am que
time 56 hrs ( at time of the report) ???

What tables would I look at?

Thanks,

Jasper





[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
Yahoo! Groups Links
Is there a way to create a "time" report that gives a listing of everything in the "inspection" que awaiting approval, the "date: & time" it got in there and a accumulated time??

Sample
12323221-1 receipt 7/18/05 9:05 am que time 56 hrs ( at time of the report) ???

What tables would I look at?

Thanks,

Jasper





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

I've enclosed a sql server statement that does this. It sorts out
"garbage receipts" that are stuck there from early buggier vantage days
(xtblGarbageReceiptsForInspection) , and ages the date of the receipt
with a CASE statement. I actually deliver this to the users via an
Excel spreadsheet with an external database import into a pivot table.

SELECT TOP 100 PERCENT dbo.tblVendor.Name AS VendorName,
dbo.tblRcvHead.PackSlip, dbo.tblRcvDtl.PackLine,
dbo.tblRcvHead.ReceiptDate, dbo.tblRcvHead.PONum, dbo.tblRcvDtl.POLine,
dbo.tblRcvDtl.PORelNum, dbo.tblRcvDtl.JobNum, dbo.tblRcvDtl.PartNum,
dbo.tblRcvDtl.PartDescription, dbo.tblRcvDtl.OurQty,
dbo.tblRcvDtl.VendorQty, dbo.tblRcvDtl.PassedQty,
dbo.tblRcvDtl.FailedQty, dbo.tblRcvDtl.LotNum, dbo.tblJobHead.PartNum AS
JobPart, ISNULL(dbo.tblSchedPri.Description, '') AS JobPriority,
dbo.tblSchedPri.PriorityFactor AS JobPriorityFactor,
ISNULL(dbo.tblJobHead.ProjectID, ISNULL(dbo.tblPORel.ProjectID, '')) AS
ProjectId, dbo.tblPOHeader.Character02 AS Requisitioner, CASE WHEN
DATEDIFF(d, dbo.tblRcvHead.ReceiptDate, GETDATE())> 90 THEN 'Gt90' WHEN
DATEDIFF(d, dbo.tblRcvHead.ReceiptDate, GETDATE()) > 30 THEN 'Gt30' ELSE
'Lt30' END AS AgedDateRcv

FROM dbo.tblPORel RIGHT OUTER JOIN
dbo.xtblGarbageReceiptsForInspection RIGHT OUTER JOIN dbo.tblRcvHead
INNER JOIN dbo.tblRcvDtl ON dbo.tblRcvHead.Company =
dbo.tblRcvDtl.Company AND dbo.tblRcvHead.VendorNum =
dbo.tblRcvDtl.VendorNum AND dbo.tblRcvHead.PackSlip =
dbo.tblRcvDtl.PackSlip AND dbo.tblRcvHead.PONum = dbo.tblRcvDtl.PONum ON
dbo.xtblGarbageReceiptsForInspection.PackSlip = dbo.tblRcvDtl.PackSlip
AND dbo.xtblGarbageReceiptsForInspection.PartNum =
dbo.tblRcvDtl.PartNum AND
dbo.xtblGarbageReceiptsForInspection.VendorNum = dbo.tblRcvDtl.VendorNum
ON dbo.tblPORel.PONum = dbo.tblRcvDtl.PONum AND dbo.tblPORel.POLine =
dbo.tblRcvDtl.POLine AND dbo.tblPORel.PORelNum = dbo.tblRcvDtl.PORelNum
AND dbo.tblPORel.Company = dbo.tblRcvDtl.Company LEFT OUTER JOIN
dbo.tblPOHeader ON dbo.tblRcvHead.Company = dbo.tblPOHeader.Company AND
dbo.tblRcvHead.PONum = dbo.tblPOHeader.PONum LEFT OUTER JOIN
dbo.tblVendor ON dbo.tblRcvHead.Company = dbo.tblVendor.Company AND
dbo.tblRcvHead.VendorNum = dbo.tblVendor.VendorNum LEFT OUTER JOIN
dbo.tblJobHead LEFT OUTER JOIN dbo.tblSchedPri ON dbo.tblJobHead.Company
= dbo.tblSchedPri.Company AND dbo.tblJobHead.SchedCode =
dbo.tblSchedPri.SchedCode ON
dbo.tblRcvDtl.Company = dbo.tblJobHead.Company AND
dbo.tblRcvDtl.JobNum = dbo.tblJobHead.JobNum

WHERE (dbo.tblRcvDtl.InspectionPending = 1) AND
dbo.xtblGarbageReceiptsForInspection.PackSlip IS NULL
ORDER BY dbo.tblRcvHead.ReceiptDate, dbo.tblRcvDtl.PartNum

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Wednesday, July 20, 2005 1:22 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Inspection Que report

Is there a way to create a "time" report that gives a listing of
everything in the "inspection" que awaiting approval, the "date: &
time" it got in there and a accumulated time??

Sample
12323221-1 receipt 7/18/05 9:05 am
que time 56 hrs ( at time of the report) ???

What tables would I look at?

Thanks,

Jasper





[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
Yahoo! Groups Links
Steve,

How do I transfer this sql statement into Report builder?

-----Original Message-----
From: Steve Wirch [mailto:wirch@...]
Sent: Wednesday, July 20, 2005 4:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Inspection Que report


Hi Jasper,

I've enclosed a sql server statement that does this. It sorts out
"garbage receipts" that are stuck there from early buggier vantage days
(xtblGarbageReceiptsForInspection) , and ages the date of the receipt
with a CASE statement. I actually deliver this to the users via an
Excel spreadsheet with an external database import into a pivot table.

SELECT TOP 100 PERCENT dbo.tblVendor.Name AS VendorName,
dbo.tblRcvHead.PackSlip, dbo.tblRcvDtl.PackLine,
dbo.tblRcvHead.ReceiptDate, dbo.tblRcvHead.PONum, dbo.tblRcvDtl.POLine,
dbo.tblRcvDtl.PORelNum, dbo.tblRcvDtl.JobNum, dbo.tblRcvDtl.PartNum,
dbo.tblRcvDtl.PartDescription, dbo.tblRcvDtl.OurQty,
dbo.tblRcvDtl.VendorQty, dbo.tblRcvDtl.PassedQty,
dbo.tblRcvDtl.FailedQty, dbo.tblRcvDtl.LotNum, dbo.tblJobHead.PartNum AS
JobPart, ISNULL(dbo.tblSchedPri.Description, '') AS JobPriority,
dbo.tblSchedPri.PriorityFactor AS JobPriorityFactor,
ISNULL(dbo.tblJobHead.ProjectID, ISNULL(dbo.tblPORel.ProjectID, '')) AS
ProjectId, dbo.tblPOHeader.Character02 AS Requisitioner, CASE WHEN
DATEDIFF(d, dbo.tblRcvHead.ReceiptDate, GETDATE())> 90 THEN 'Gt90' WHEN
DATEDIFF(d, dbo.tblRcvHead.ReceiptDate, GETDATE()) > 30 THEN 'Gt30' ELSE
'Lt30' END AS AgedDateRcv

FROM dbo.tblPORel RIGHT OUTER JOIN
dbo.xtblGarbageReceiptsForInspection RIGHT OUTER JOIN dbo.tblRcvHead
INNER JOIN dbo.tblRcvDtl ON dbo.tblRcvHead.Company =
dbo.tblRcvDtl.Company AND dbo.tblRcvHead.VendorNum =
dbo.tblRcvDtl.VendorNum AND dbo.tblRcvHead.PackSlip =
dbo.tblRcvDtl.PackSlip AND dbo.tblRcvHead.PONum = dbo.tblRcvDtl.PONum ON
dbo.xtblGarbageReceiptsForInspection.PackSlip = dbo.tblRcvDtl.PackSlip
AND dbo.xtblGarbageReceiptsForInspection.PartNum =
dbo.tblRcvDtl.PartNum AND
dbo.xtblGarbageReceiptsForInspection.VendorNum = dbo.tblRcvDtl.VendorNum
ON dbo.tblPORel.PONum = dbo.tblRcvDtl.PONum AND dbo.tblPORel.POLine =
dbo.tblRcvDtl.POLine AND dbo.tblPORel.PORelNum = dbo.tblRcvDtl.PORelNum
AND dbo.tblPORel.Company = dbo.tblRcvDtl.Company LEFT OUTER JOIN
dbo.tblPOHeader ON dbo.tblRcvHead.Company = dbo.tblPOHeader.Company AND
dbo.tblRcvHead.PONum = dbo.tblPOHeader.PONum LEFT OUTER JOIN
dbo.tblVendor ON dbo.tblRcvHead.Company = dbo.tblVendor.Company AND
dbo.tblRcvHead.VendorNum = dbo.tblVendor.VendorNum LEFT OUTER JOIN
dbo.tblJobHead LEFT OUTER JOIN dbo.tblSchedPri ON dbo.tblJobHead.Company
= dbo.tblSchedPri.Company AND dbo.tblJobHead.SchedCode =
dbo.tblSchedPri.SchedCode ON
dbo.tblRcvDtl.Company = dbo.tblJobHead.Company AND
dbo.tblRcvDtl.JobNum = dbo.tblJobHead.JobNum

WHERE (dbo.tblRcvDtl.InspectionPending = 1) AND
dbo.xtblGarbageReceiptsForInspection.PackSlip IS NULL
ORDER BY dbo.tblRcvHead.ReceiptDate, dbo.tblRcvDtl.PartNum

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Wednesday, July 20, 2005 1:22 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Inspection Que report

Is there a way to create a "time" report that gives a listing of
everything in the "inspection" que awaiting approval, the "date: &
time" it got in there and a accumulated time??

Sample
12323221-1 receipt 7/18/05 9:05 am
que time 56 hrs ( at time of the report) ???

What tables would I look at?

Thanks,

Jasper





[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
Yahoo! Groups Links








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
Yahoo! Groups Links
Hi Jasper,

Sorry, I supplied the over-engineered answer.

At the simplest case, the tables you need to look at are RcvHead and
RcvDtl. Filter on RcvDtl.InspectionPending = 1. Join on company,
VendorNum, and PackingSlip.

I guess I wouldn't do anything new in report builder, since it's being
phased out. We are using either sql server, or direct access via Excel.
As I phase out report-builder reports I delete them. I view this as
being one of the most time-consuming tasks of 8.0 conversion since we
used to use 50-100 report builder queries to run the business.

You should be able to open Microsoft Excel,

pull down Data > Import External Data > New Database Query.

Choose your Vantage ODBC connection, and uncheck the "Use the query
wizard to create/edit queries".

MS Query should open. (If it doesn't you need to install the add-in).

Click the SQL button, and paste the sql in.

It will object to at least the following:
- progress will have a problem with the RIGHT OUTER JOINS,
- the table xtblGarbageReceiptsForInspection won't exist as I use it
to store ancient bogus packing slips that had a data integrity problem,
- All of the dbo.'s will need to be changed to PUB,
- I've included the PO files for additional information, you may not
want to,
- We prioritize our jobs, and virtually all of our received material
is from subcontractors on Jobs, you may not do this, and won't need the
job tables,

Take care,

Steve




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Thursday, July 21, 2005 8:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Inspection Que report

Steve,

How do I transfer this sql statement into Report builder?

-----Original Message-----
From: Steve Wirch [mailto:wirch@...]
Sent: Wednesday, July 20, 2005 4:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Inspection Que report


Hi Jasper,

I've enclosed a sql server statement that does this. It sorts out
"garbage receipts" that are stuck there from early buggier vantage days
(xtblGarbageReceiptsForInspection) , and ages the date of the receipt
with a CASE statement. I actually deliver this to the users via an
Excel spreadsheet with an external database import into a pivot table.

SELECT TOP 100 PERCENT dbo.tblVendor.Name AS VendorName,
dbo.tblRcvHead.PackSlip, dbo.tblRcvDtl.PackLine,
dbo.tblRcvHead.ReceiptDate, dbo.tblRcvHead.PONum, dbo.tblRcvDtl.POLine,
dbo.tblRcvDtl.PORelNum, dbo.tblRcvDtl.JobNum, dbo.tblRcvDtl.PartNum,
dbo.tblRcvDtl.PartDescription, dbo.tblRcvDtl.OurQty,
dbo.tblRcvDtl.VendorQty, dbo.tblRcvDtl.PassedQty,
dbo.tblRcvDtl.FailedQty, dbo.tblRcvDtl.LotNum, dbo.tblJobHead.PartNum AS
JobPart, ISNULL(dbo.tblSchedPri.Description, '') AS JobPriority,
dbo.tblSchedPri.PriorityFactor AS JobPriorityFactor,
ISNULL(dbo.tblJobHead.ProjectID, ISNULL(dbo.tblPORel.ProjectID, '')) AS
ProjectId, dbo.tblPOHeader.Character02 AS Requisitioner, CASE WHEN
DATEDIFF(d, dbo.tblRcvHead.ReceiptDate, GETDATE())> 90 THEN 'Gt90' WHEN
DATEDIFF(d, dbo.tblRcvHead.ReceiptDate, GETDATE()) > 30 THEN 'Gt30' ELSE
'Lt30' END AS AgedDateRcv

FROM dbo.tblPORel RIGHT OUTER JOIN
dbo.xtblGarbageReceiptsForInspection RIGHT OUTER JOIN dbo.tblRcvHead
INNER JOIN dbo.tblRcvDtl ON dbo.tblRcvHead.Company =
dbo.tblRcvDtl.Company AND dbo.tblRcvHead.VendorNum =
dbo.tblRcvDtl.VendorNum AND dbo.tblRcvHead.PackSlip =
dbo.tblRcvDtl.PackSlip AND dbo.tblRcvHead.PONum = dbo.tblRcvDtl.PONum ON
dbo.xtblGarbageReceiptsForInspection.PackSlip = dbo.tblRcvDtl.PackSlip
AND dbo.xtblGarbageReceiptsForInspection.PartNum =
dbo.tblRcvDtl.PartNum AND
dbo.xtblGarbageReceiptsForInspection.VendorNum = dbo.tblRcvDtl.VendorNum
ON dbo.tblPORel.PONum = dbo.tblRcvDtl.PONum AND dbo.tblPORel.POLine =
dbo.tblRcvDtl.POLine AND dbo.tblPORel.PORelNum = dbo.tblRcvDtl.PORelNum
AND dbo.tblPORel.Company = dbo.tblRcvDtl.Company LEFT OUTER JOIN
dbo.tblPOHeader ON dbo.tblRcvHead.Company = dbo.tblPOHeader.Company AND
dbo.tblRcvHead.PONum = dbo.tblPOHeader.PONum LEFT OUTER JOIN
dbo.tblVendor ON dbo.tblRcvHead.Company = dbo.tblVendor.Company AND
dbo.tblRcvHead.VendorNum = dbo.tblVendor.VendorNum LEFT OUTER JOIN
dbo.tblJobHead LEFT OUTER JOIN dbo.tblSchedPri ON dbo.tblJobHead.Company
= dbo.tblSchedPri.Company AND dbo.tblJobHead.SchedCode =
dbo.tblSchedPri.SchedCode ON
dbo.tblRcvDtl.Company = dbo.tblJobHead.Company AND
dbo.tblRcvDtl.JobNum = dbo.tblJobHead.JobNum

WHERE (dbo.tblRcvDtl.InspectionPending = 1) AND
dbo.xtblGarbageReceiptsForInspection.PackSlip IS NULL
ORDER BY dbo.tblRcvHead.ReceiptDate, dbo.tblRcvDtl.PartNum

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Wednesday, July 20, 2005 1:22 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Inspection Que report

Is there a way to create a "time" report that gives a listing of
everything in the "inspection" que awaiting approval, the "date: &
time" it got in there and a accumulated time??

Sample
12323221-1 receipt 7/18/05 9:05 am
que time 56 hrs ( at time of the report) ???

What tables would I look at?

Thanks,

Jasper





[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
Yahoo! Groups Links








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
Yahoo! Groups Links








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
Yahoo! Groups Links
Great!

Thanks Steve!!

-----Original Message-----
From: Steve Wirch [mailto:wirch@...]
Sent: Thursday, July 21, 2005 8:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Inspection Que report


Hi Jasper,

Sorry, I supplied the over-engineered answer.

At the simplest case, the tables you need to look at are RcvHead and
RcvDtl. Filter on RcvDtl.InspectionPending = 1. Join on company,
VendorNum, and PackingSlip.

I guess I wouldn't do anything new in report builder, since it's being
phased out. We are using either sql server, or direct access via Excel.
As I phase out report-builder reports I delete them. I view this as
being one of the most time-consuming tasks of 8.0 conversion since we
used to use 50-100 report builder queries to run the business.

You should be able to open Microsoft Excel,

pull down Data > Import External Data > New Database Query.

Choose your Vantage ODBC connection, and uncheck the "Use the query
wizard to create/edit queries".

MS Query should open. (If it doesn't you need to install the add-in).

Click the SQL button, and paste the sql in.

It will object to at least the following:
- progress will have a problem with the RIGHT OUTER JOINS,
- the table xtblGarbageReceiptsForInspection won't exist as I use it
to store ancient bogus packing slips that had a data integrity problem,
- All of the dbo.'s will need to be changed to PUB,
- I've included the PO files for additional information, you may not
want to,
- We prioritize our jobs, and virtually all of our received material
is from subcontractors on Jobs, you may not do this, and won't need the
job tables,

Take care,

Steve




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Thursday, July 21, 2005 8:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Inspection Que report

Steve,

How do I transfer this sql statement into Report builder?

-----Original Message-----
From: Steve Wirch [mailto:wirch@...]
Sent: Wednesday, July 20, 2005 4:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Inspection Que report


Hi Jasper,

I've enclosed a sql server statement that does this. It sorts out
"garbage receipts" that are stuck there from early buggier vantage days
(xtblGarbageReceiptsForInspection) , and ages the date of the receipt
with a CASE statement. I actually deliver this to the users via an
Excel spreadsheet with an external database import into a pivot table.

SELECT TOP 100 PERCENT dbo.tblVendor.Name AS VendorName,
dbo.tblRcvHead.PackSlip, dbo.tblRcvDtl.PackLine,
dbo.tblRcvHead.ReceiptDate, dbo.tblRcvHead.PONum, dbo.tblRcvDtl.POLine,
dbo.tblRcvDtl.PORelNum, dbo.tblRcvDtl.JobNum, dbo.tblRcvDtl.PartNum,
dbo.tblRcvDtl.PartDescription, dbo.tblRcvDtl.OurQty,
dbo.tblRcvDtl.VendorQty, dbo.tblRcvDtl.PassedQty,
dbo.tblRcvDtl.FailedQty, dbo.tblRcvDtl.LotNum, dbo.tblJobHead.PartNum AS
JobPart, ISNULL(dbo.tblSchedPri.Description, '') AS JobPriority,
dbo.tblSchedPri.PriorityFactor AS JobPriorityFactor,
ISNULL(dbo.tblJobHead.ProjectID, ISNULL(dbo.tblPORel.ProjectID, '')) AS
ProjectId, dbo.tblPOHeader.Character02 AS Requisitioner, CASE WHEN
DATEDIFF(d, dbo.tblRcvHead.ReceiptDate, GETDATE())> 90 THEN 'Gt90' WHEN
DATEDIFF(d, dbo.tblRcvHead.ReceiptDate, GETDATE()) > 30 THEN 'Gt30' ELSE
'Lt30' END AS AgedDateRcv

FROM dbo.tblPORel RIGHT OUTER JOIN
dbo.xtblGarbageReceiptsForInspection RIGHT OUTER JOIN dbo.tblRcvHead
INNER JOIN dbo.tblRcvDtl ON dbo.tblRcvHead.Company =
dbo.tblRcvDtl.Company AND dbo.tblRcvHead.VendorNum =
dbo.tblRcvDtl.VendorNum AND dbo.tblRcvHead.PackSlip =
dbo.tblRcvDtl.PackSlip AND dbo.tblRcvHead.PONum = dbo.tblRcvDtl.PONum ON
dbo.xtblGarbageReceiptsForInspection.PackSlip = dbo.tblRcvDtl.PackSlip
AND dbo.xtblGarbageReceiptsForInspection.PartNum =
dbo.tblRcvDtl.PartNum AND
dbo.xtblGarbageReceiptsForInspection.VendorNum = dbo.tblRcvDtl.VendorNum
ON dbo.tblPORel.PONum = dbo.tblRcvDtl.PONum AND dbo.tblPORel.POLine =
dbo.tblRcvDtl.POLine AND dbo.tblPORel.PORelNum = dbo.tblRcvDtl.PORelNum
AND dbo.tblPORel.Company = dbo.tblRcvDtl.Company LEFT OUTER JOIN
dbo.tblPOHeader ON dbo.tblRcvHead.Company = dbo.tblPOHeader.Company AND
dbo.tblRcvHead.PONum = dbo.tblPOHeader.PONum LEFT OUTER JOIN
dbo.tblVendor ON dbo.tblRcvHead.Company = dbo.tblVendor.Company AND
dbo.tblRcvHead.VendorNum = dbo.tblVendor.VendorNum LEFT OUTER JOIN
dbo.tblJobHead LEFT OUTER JOIN dbo.tblSchedPri ON dbo.tblJobHead.Company
= dbo.tblSchedPri.Company AND dbo.tblJobHead.SchedCode =
dbo.tblSchedPri.SchedCode ON
dbo.tblRcvDtl.Company = dbo.tblJobHead.Company AND
dbo.tblRcvDtl.JobNum = dbo.tblJobHead.JobNum

WHERE (dbo.tblRcvDtl.InspectionPending = 1) AND
dbo.xtblGarbageReceiptsForInspection.PackSlip IS NULL
ORDER BY dbo.tblRcvHead.ReceiptDate, dbo.tblRcvDtl.PartNum

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Wednesday, July 20, 2005 1:22 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Inspection Que report

Is there a way to create a "time" report that gives a listing of
everything in the "inspection" que awaiting approval, the "date: &
time" it got in there and a accumulated time??

Sample
12323221-1 receipt 7/18/05 9:05 am
que time 56 hrs ( at time of the report) ???

What tables would I look at?

Thanks,

Jasper





[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
Yahoo! Groups Links








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
Yahoo! Groups Links








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
Yahoo! Groups Links








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
Yahoo! Groups Links