# Time Phase Report
**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2004-01-19 10:17 UTC
**Views:** 985
**Replies:** 3
**URL:** https://www.epiusers.help/t/time-phase-report/2335
---
## Post #1 by @system
---
## Post #2 by @system
We have a problem with the time phase material report in Vantage. I have two purchased, stocked parts that are set up exactly the same with a minimum on hand of 25, one has 9 in stock one has 11 in stock. One part is printing on the report, but the other is not. Have any of you seen this problem? I researched it for about an hour today, but can't find anything that is different between the items. I also identified more parts that are not printing on the report, but are well below minimum.
Any input would be appreciated from you guys.
Thanks
Paul Lipham
ASPI
Paull@...Hello Group,
Has anyone had any luck with building a Crystal 8.5 Time Phase
Report? I've been working on it and have an unresolved problem - I
need the Total OnHand Quantity for each given part within the
company. I currently get it by having a separate report called
OnHand. It is grouped on PartNum and has PartBin.OnHand as the
detail. I subtotal the detail into the footer of the group. I hide
the group header and detail, but display the group footer containing
the PartNum and OnHand subtotal. This can be exported to an excel
file. I then read this into Timephase. My question is how to
integrate this OnHand subtotaling into the timephase report without
using subreports? I tried subreports and it took Crystal about 4
hours to provide a preview.
Any help is greatly appreciated. Thanks.
---
## Post #4 by @system
Try linking to the PartWhse table and using the OnHandQty field, in theory
you would be doing a timephase for that part in a particular warehouse, if
you don't have a bunch of warehouses setup or are using virtual warehouses
within your plant this will get you the onhand total without adding up a
bunch of bins in a sub report (crystal) or extra sort/group in report
builder.
Patrick Winter
-----Original Message-----
From: johndeligdisch [mailto:
johndeligdisch@...]
Sent: Monday, January 19, 2004 8:41 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Time Phase Report
Hello Group,
Has anyone had any luck with building a Crystal 8.5 Time Phase
Report? I've been working on it and have an unresolved problem - I
need the Total OnHand Quantity for each given part within the
company. I currently get it by having a separate report called
OnHand. It is grouped on PartNum and has PartBin.OnHand as the
detail. I subtotal the detail into the footer of the group. I hide
the group header and detail, but display the group footer containing
the PartNum and OnHand subtotal. This can be exported to an excel
file. I then read this into Timephase. My question is how to
integrate this OnHand subtotaling into the timephase report without
using subreports? I tried subreports and it took Crystal about 4
hours to provide a preview.
Any help is greatly appreciated. Thanks.
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
To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/