Crystal Question Solved

Yahoo Archive
1
I had 2 fields that I calculated in Crystal. I used the 2 calculated
fields( {Early} and {Late})in the following statement, and I am getting the
proper data.

If {@Early} = 0

then

if {@Late} = 0

then

1



else

0



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Todd Caughey
Sent: Thursday, October 02, 2008 9:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Question



Not too familiar with the BAQ results side of this but when I 've had this
sort of reporting problem in the past it has usually been the result of a
mismatch somewhere in the lines versus release levels...such as one source
not matching the other one for one...or it taking the last release due date
for a line with multiple releases I usually end up either examining the data
source (in the case the BAQReportResult data) or in Crystal add the fields
used in the formual temporarily to the output so I can right click and
examine the raw data from the source and then walk through the formula
manually. It usually (eventually) results in an "Aaahaaa" moment. Not to
assume you have not done this already but just incase not it may be a
starting point.
-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Jeff Stockard
Sent: Thursday, October 02, 2008 8:07 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Question

I am trying to get a Crystal report that shows me the Early, Late and On
Time deliveries. I have the formula below. The first line that matches the
criteria gets the number 1 like it is supposed to do. All of the other
lines that match the criteria get the number 0. I don't know why the
formula only works once. Does anyone know what I am missing?

Thank you

Jeff

If
{BAQReportResult.PORel.DueDate}-{BAQReportResult.RcvDtl.ReceiptDate}+{BAQRep
ortResult.Vendor.LateBuffer}=0

then

1

else

0

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>] On
Behalf Of
carolpelowski
Sent: Wednesday, October 01, 2008 4:37 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Material substitutions

Can anyone tell me if Vantage will allow reduction of a material on a
job & replacement/substitution of a differenct component with the
remaining requirement?

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

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





[Non-text portions of this message have been removed]
2
Can anyone tell me if Vantage will allow reduction of a material on a
job & replacement/substitution of a differenct component with the
remaining requirement?
3
You can issue any material to meet the demand for another material. If
the total quantity matches, it will recognize once it is issued
complete as well.
--- In vantage@yahoogroups.com, "carolpelowski" <carolpelowski@...>
wrote:
>
> Can anyone tell me if Vantage will allow reduction of a material on a
> job & replacement/substitution of a differenct component with the
> remaining requirement?
>
4
I am trying to get a Crystal report that shows me the Early, Late and On
Time deliveries. I have the formula below. The first line that matches the
criteria gets the number 1 like it is supposed to do. All of the other
lines that match the criteria get the number 0. I don't know why the
formula only works once. Does anyone know what I am missing?

Thank you

Jeff



If
{BAQReportResult.PORel.DueDate}-{BAQReportResult.RcvDtl.ReceiptDate}+{BAQRep
ortResult.Vendor.LateBuffer}=0

then

1

else

0



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
carolpelowski
Sent: Wednesday, October 01, 2008 4:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Material substitutions



Can anyone tell me if Vantage will allow reduction of a material on a
job & replacement/substitution of a differenct component with the
remaining requirement?





[Non-text portions of this message have been removed]
5
Not too familiar with the BAQ results side of this but when I 've had this sort of reporting problem in the past it has usually been the result of a mismatch somewhere in the lines versus release levels...such as one source not matching the other one for one...or it taking the last release due date for a line with multiple releases I usually end up either examining the data source (in the case the BAQReportResult data) or in Crystal add the fields used in the formual temporarily to the output so I can right click and examine the raw data from the source and then walk through the formula manually. It usually (eventually) results in an "Aaahaaa" moment. Not to assume you have not done this already but just incase not it may be a starting point.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jeff Stockard
Sent: Thursday, October 02, 2008 8:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Question


I am trying to get a Crystal report that shows me the Early, Late and On
Time deliveries. I have the formula below. The first line that matches the
criteria gets the number 1 like it is supposed to do. All of the other
lines that match the criteria get the number 0. I don't know why the
formula only works once. Does anyone know what I am missing?

Thank you

Jeff

If
{BAQReportResult.PORel.DueDate}-{BAQReportResult.RcvDtl.ReceiptDate}+{BAQRep
ortResult.Vendor.LateBuffer}=0

then

1

else

0

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
carolpelowski
Sent: Wednesday, October 01, 2008 4:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Material substitutions

Can anyone tell me if Vantage will allow reduction of a material on a
job & replacement/substitution of a differenct component with the
remaining requirement?

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





[Non-text portions of this message have been removed]
6
I have a BAQ that feeds Crystal.

I have two calculated fields in my BAQ:

1. Early, OnTime, Late

if (ShipHead.ShipDate - OrderRel.ReqDate) < 0
then "Early"
else if (ShipHead.ShipDate - OrderRel.ReqDate) = 0
then "OnTime"
else if (ShipHead.ShipDate - OrderRel.ReqDate) > 0
then "Late"
else "Z"

Field Type = Character

2. # of Days

(integer(ShipHead.ShipDate) - integer(OrderRel.ReqDate))

Field Type = Integer

Not sure if this helps...
Thanks
Patty Buechler

--- In vantage@yahoogroups.com, Todd Caughey <caugheyt@...> wrote:
>
> Not too familiar with the BAQ results side of this but when I 've
had this sort of reporting problem in the past it has usually been
the result of a mismatch somewhere in the lines versus release
levels...such as one source not matching the other one for one...or
it taking the last release due date for a line with multiple
releases I usually end up either examining the data source (in the
case the BAQReportResult data) or in Crystal add the fields used in
the formual temporarily to the output so I can right click and
examine the raw data from the source and then walk through the
formula manually. It usually (eventually) results in an "Aaahaaa"
moment. Not to assume you have not done this already but just incase
not it may be a starting point.
> -Todd C.
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of Jeff Stockard
> Sent: Thursday, October 02, 2008 8:07 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Question
>
>
> I am trying to get a Crystal report that shows me the Early, Late
and On
> Time deliveries. I have the formula below. The first line that
matches the
> criteria gets the number 1 like it is supposed to do. All of the
other
> lines that match the criteria get the number 0. I don't know why the
> formula only works once. Does anyone know what I am missing?
>
> Thank you
>
> Jeff
>
> If
> {BAQReportResult.PORel.DueDate}-{BAQReportResult.RcvDtl.ReceiptDate}
+{BAQRep
> ortResult.Vendor.LateBuffer}=0
>
> then
>
> 1
>
> else
>
> 0
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
Behalf Of
> carolpelowski
> Sent: Wednesday, October 01, 2008 4:37 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Material substitutions
>
> Can anyone tell me if Vantage will allow reduction of a material on
a
> job & replacement/substitution of a differenct component with the
> remaining requirement?
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
7
Hi Patty,

> I have two calculated fields in my BAQ:
>
> 1. Early, OnTime, Late
>
> if (ShipHead.ShipDate - OrderRel.ReqDate) < 0
> then "Early"
> else if (ShipHead.ShipDate - OrderRel.ReqDate) = 0
> then "OnTime"
> else if (ShipHead.ShipDate - OrderRel.ReqDate) > 0
> then "Late"
> else "Z"
>
> Field Type = Character
>
> 2. # of Days

You might be able to make the report easier by creating more calculated
fields. If you had five fields:

Early: if (ShipHead.ShipDate - OrderRel.ReqDate) < 0 then 1 else 0
OnTime: if (ShipHead.ShipDate - OrderRel.ReqDate) = 0 then 1 else 0
Late: if (ShipHead.ShipDate - OrderRel.ReqDate) > 0 then 1 else 0
daysEarly: if (ShipHead.ShipDate - OrderRel.ReqDate) < then
(integer(ShipHead.ShipDate) - integer(OrderRel.ReqDate)) else 0
daysLate: if (ShipHead.ShipDate - OrderRel.ReqDate) > 0 then
(integer(ShipHead.ReqDate) - integer(OrderRel.ShipDate)) else 0

Now your occurrences are easy to calculate (just sum them) and now you can
also easily calculate average days early/late etc.

Food for thought.

Mark W.