# Crystal Report for Inventory History

Frank,

I know you have probably spent more time on this than you care to but
would it be possible to get a copy of your last version saved back to
8.5. I still didn't get the three month total to work.

Thanks
Todd

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Thursday, February 17, 2005 10:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report for Inventory History

What I have done in the past is create a function called tran in scope

If parttran.trandate >= today() - 90
then partran.tranqty
else 0

You can sum or avg this f(x) and you should have it

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, February 17, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report for Inventory History

I am writing a Crystal Report that summarizes inventory use by month. I
am
using the following 2 formulas to first determine previous month from
current day and then to group usage into months for the previous 12
months.

datevar PrevMonth1 := dateserial(year(currentdate),month(currentdate),1
- 1)

ToText(Year({PartTran.TranDate}), "##") + " - " + ToText(12 -
Month({PartTran.TranDate}), "##") + " - " +
MonthName(Month({PartTran.TranDate}))

I then need to provide an average use for the last twelve months and for
the
last three months. The average of the last twelve months is easy, sum
the
TranQty from above formula and divide by twelve. I am stuck however
trying
to create a formula that will average the use of the last three months.
Can
anyone get me on track?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender
immediately by return e-mail, delete this e-mail and destroy any copies.
Any
dissemination or use of this information by a person other than the
intended
recipient is unauthorized and may be illegal.

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
(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:

<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it be
copied in any way. If received in error, please delete and notify the
sender via e-mail or sales@... quoting the name of the sender.
Messages sent via this medium may be subject to delays, non-delivery and
unauthorized alteration. This e-mail has been prepared using information
believed by the author to be reliable and accurate. Unless expressly
stated otherwise, this e-mail does not form part of a legally binding
contract or agreement between recipient and Innovative Office Products,
Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments. It is, therefore, your responsibility to scan
attachments (if any).

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
(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:

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
I am writing a Crystal Report that summarizes inventory use by month. I
am using the following 2 formulas to first determine previous month from
current day and then to group usage into months for the previous 12
months.

datevar PrevMonth1 := dateserial(year(currentdate),month(currentdate),1
- 1)

ToText(Year({PartTran.TranDate}), "##") + " - " + ToText(12 -
Month({PartTran.TranDate}), "##") + " - " +
MonthName(Month({PartTran.TranDate}))

I then need to provide an average use for the last twelve months and for
the last three months. The average of the last twelve months is easy,
sum the TranQty from above formula and divide by twelve. I am stuck
however trying to create a formula that will average the use of the last
three months. Can anyone get me on track?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[Non-text portions of this message have been removed]
What I have done in the past is create a function called tran in scope

If parttran.trandate >= today() - 90
then partran.tranqty
else 0

You can sum or avg this f(x) and you should have it

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, February 17, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report for Inventory History

I am writing a Crystal Report that summarizes inventory use by month. I am
using the following 2 formulas to first determine previous month from
current day and then to group usage into months for the previous 12 months.

datevar PrevMonth1 := dateserial(year(currentdate),month(currentdate),1
- 1)

ToText(Year({PartTran.TranDate}), "##") + " - " + ToText(12 -
Month({PartTran.TranDate}), "##") + " - " +
MonthName(Month({PartTran.TranDate}))

I then need to provide an average use for the last twelve months and for the
last three months. The average of the last twelve months is easy, sum the
TranQty from above formula and divide by twelve. I am stuck however trying
to create a formula that will average the use of the last three months. Can
anyone get me on track?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the sender
immediately by return e-mail, delete this e-mail and destroy any copies. Any
dissemination or use of this information by a person other than the intended
recipient is unauthorized and may be illegal.

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
(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:

<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
Frank,

This works great to select the records however it is not allowing me to
sum or average on it. Any suggestions?

Todd

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Thursday, February 17, 2005 10:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report for Inventory History

What I have done in the past is create a function called tran in scope

If parttran.trandate >= today() - 90
then partran.tranqty
else 0

You can sum or avg this f(x) and you should have it

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, February 17, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report for Inventory History

I am writing a Crystal Report that summarizes inventory use by month. I
am
using the following 2 formulas to first determine previous month from
current day and then to group usage into months for the previous 12
months.

datevar PrevMonth1 := dateserial(year(currentdate),month(currentdate),1
- 1)

ToText(Year({PartTran.TranDate}), "##") + " - " + ToText(12 -
Month({PartTran.TranDate}), "##") + " - " +
MonthName(Month({PartTran.TranDate}))

I then need to provide an average use for the last twelve months and for
the
last three months. The average of the last twelve months is easy, sum
the
TranQty from above formula and divide by twelve. I am stuck however
trying
to create a formula that will average the use of the last three months.
Can
anyone get me on track?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender
immediately by return e-mail, delete this e-mail and destroy any copies.
Any
dissemination or use of this information by a person other than the
intended
recipient is unauthorized and may be illegal.

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
(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:

<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it be
copied in any way. If received in error, please delete and notify the
sender via e-mail or sales@... quoting the name of the sender.
Messages sent via this medium may be subject to delays, non-delivery and
unauthorized alteration. This e-mail has been prepared using information
believed by the author to be reliable and accurate. Unless expressly
stated otherwise, this e-mail does not form part of a legally binding
contract or agreement between recipient and Innovative Office Products,
Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments. It is, therefore, your responsibility to scan
attachments (if any).

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
(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:

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.
What version of crystal do you have?

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, February 17, 2005 11:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report for Inventory History

Frank,

This works great to select the records however it is not allowing me to sum
or average on it. Any suggestions?

Todd

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Thursday, February 17, 2005 10:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report for Inventory History

What I have done in the past is create a function called tran in scope

If parttran.trandate >= today() - 90
then partran.tranqty
else 0

You can sum or avg this f(x) and you should have it

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, February 17, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report for Inventory History

I am writing a Crystal Report that summarizes inventory use by month. I am
using the following 2 formulas to first determine previous month from
current day and then to group usage into months for the previous 12 months.

datevar PrevMonth1 := dateserial(year(currentdate),month(currentdate),1
- 1)

ToText(Year({PartTran.TranDate}), "##") + " - " + ToText(12 -
Month({PartTran.TranDate}), "##") + " - " +
MonthName(Month({PartTran.TranDate}))

I then need to provide an average use for the last twelve months and for the
last three months. The average of the last twelve months is easy, sum the
TranQty from above formula and divide by twelve. I am stuck however trying
to create a formula that will average the use of the last three months. Can
anyone get me on track?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the sender
immediately by return e-mail, delete this e-mail and destroy any copies. Any
dissemination or use of this information by a person other than the intended
recipient is unauthorized and may be illegal.

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
(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:

<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views
of the sender and not necessarily the views of the company. The email and
any files transmitted with it are confidential to the intended recipient at
the e-mail address to which it has been addressed. It may not be disclosed
or used by any other than that addressee, nor may it be copied in any way.
If received in error, please delete and notify the sender via e-mail or
sales@... quoting the name of the sender. Messages sent via this
medium may be subject to delays, non-delivery and unauthorized alteration.
This e-mail has been prepared using information believed by the author to be
reliable and accurate. Unless expressly stated otherwise, this e-mail does
not form part of a legally binding contract or agreement between recipient
and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or
attachments. It is, therefore, your responsibility to scan attachments (if
any).

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
(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:

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the sender
immediately by return e-mail, delete this e-mail and destroy any copies. Any
dissemination or use of this information by a person other than the intended
recipient is unauthorized and may be illegal.

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
(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:

<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
Developer 8.5.3.975

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Thursday, February 17, 2005 11:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report for Inventory History

What version of crystal do you have?

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, February 17, 2005 11:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report for Inventory History

Frank,

This works great to select the records however it is not allowing me to
sum
or average on it. Any suggestions?

Todd

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Thursday, February 17, 2005 10:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report for Inventory History

What I have done in the past is create a function called tran in scope

If parttran.trandate >= today() - 90
then partran.tranqty
else 0

You can sum or avg this f(x) and you should have it

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, February 17, 2005 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report for Inventory History

I am writing a Crystal Report that summarizes inventory use by month. I
am
using the following 2 formulas to first determine previous month from
current day and then to group usage into months for the previous 12
months.

datevar PrevMonth1 := dateserial(year(currentdate),month(currentdate),1
- 1)

ToText(Year({PartTran.TranDate}), "##") + " - " + ToText(12 -
Month({PartTran.TranDate}), "##") + " - " +
MonthName(Month({PartTran.TranDate}))

I then need to provide an average use for the last twelve months and for
the
last three months. The average of the last twelve months is easy, sum
the
TranQty from above formula and divide by twelve. I am stuck however
trying
to create a formula that will average the use of the last three months.
Can
anyone get me on track?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender
immediately by return e-mail, delete this e-mail and destroy any copies.
Any
dissemination or use of this information by a person other than the
intended
recipient is unauthorized and may be illegal.

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
(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:

<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views
of the sender and not necessarily the views of the company. The email
and
any files transmitted with it are confidential to the intended recipient
at
the e-mail address to which it has been addressed. It may not be
disclosed
or used by any other than that addressee, nor may it be copied in any
way.
If received in error, please delete and notify the sender via e-mail or
sales@... quoting the name of the sender. Messages sent via this
medium may be subject to delays, non-delivery and unauthorized
alteration.
This e-mail has been prepared using information believed by the author
to be
reliable and accurate. Unless expressly stated otherwise, this e-mail
does
not form part of a legally binding contract or agreement between
recipient
and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept
responsibility for any loss or damage arising from the use of this email
or
attachments. It is, therefore, your responsibility to scan attachments
(if
any).

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
(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:

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender
immediately by return e-mail, delete this e-mail and destroy any copies.
Any
dissemination or use of this information by a person other than the
intended
recipient is unauthorized and may be illegal.

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
(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:

<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it be
copied in any way. If received in error, please delete and notify the
sender via e-mail or sales@... quoting the name of the sender.
Messages sent via this medium may be subject to delays, non-delivery and
unauthorized alteration. This e-mail has been prepared using information
believed by the author to be reliable and accurate. Unless expressly
stated otherwise, this e-mail does not form part of a legally binding
contract or agreement between recipient and Innovative Office Products,
Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments. It is, therefore, your responsibility to scan
attachments (if any).

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
(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:

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.