Time Phase Report

Yahoo Archive
1
I've been able to duplicate the Time Phase Report using exports into Access
(including a version that calculates material demand based on sales order
build requirements, not jobs) using a couple dozen nested queries. Access
works quite well for this.

I'd also be very interested to hear of anyone that used Crystal
successfully.

Todd Gilbert
Altair Technologies, Inc.

-----Original Message-----
From: johndeligdisch [mailto:johndeligdisch@...]
Sent: Monday, January 19, 2004 6: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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12c5f678n/M=267637.4116730.5333196.1261774/D=egroup
web/S=1705007183:HM/EXP=1074609678/A=1945638/R=0/*http://www.netflix.com/Def
ault?mqso=60178383&partid=4116730> click here

<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmai
l/S=:HM/A=1945638/rand=588586318>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
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@...
3
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.
4
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/