Reset a field Blank Title 68238

Yahoo Archive
1
I'm no Crystal expert, but I think you need to create a calculated
field to reset the global variable(name the field 'reset_LastDate').
The formula will contain the neccessary declarations, and one line to
set the date an 'early' date (like 1/1/1980).

Place the field in the Customer Group header section. Everytime the
customer changes the LastDate value should be reset.

You'll need to hide/supress the field and/or group header. I don't
recall the exact details, so some experimenting would be in order.

Calvin

--- In vantage@yahoogroups.com, "jstockard990" <jeff.stockard@...>
wrote:
>
> I am trying to make a Crystal report that shows me the last date
that a
> Customer had a Sale. I have the report and I can return all of the
> Sales orders. When I use this formula, I get the date of the last
Sale.
>
> Global dateTimeVar LastDate;
> local dateTimeVar Display_LastDate;
>
> if DateValue ({BAQReportResult.InvcHead.InvoiceDate}) > DateValue
> (LastDate)
> then
> LastDate := {BAQReportResult.InvcHead.InvoiceDate}
> else
> LastDate
> However, I don't know how to reset the field on group change (I
have
> the records grouped by CustID). I want to only show the last Sale
and
> without resetting the field, it give me the date of the last sale
to
> any prevoius customer who has a Sale date greater than theirs.
> Does anyone know the formula in Crystal to reset my field on group
> change?
>
2
I am trying to make a Crystal report that shows me the last date that a
Customer had a Sale. I have the report and I can return all of the
Sales orders. When I use this formula, I get the date of the last Sale.

Global dateTimeVar LastDate;
local dateTimeVar Display_LastDate;

if DateValue ({BAQReportResult.InvcHead.InvoiceDate}) > DateValue
(LastDate)
then
LastDate := {BAQReportResult.InvcHead.InvoiceDate}
else
LastDate
However, I don't know how to reset the field on group change (I have
the records grouped by CustID). I want to only show the last Sale and
without resetting the field, it give me the date of the last sale to
any prevoius customer who has a Sale date greater than theirs.
Does anyone know the formula in Crystal to reset my field on group
change?
3
Hi Jeff,



Have you tried sorting by date, then hiding the details? Then you can
place the invoice fields in the group footer and you should only see the
last invoice.



Regards,

Linda





Reset a field
<http://groups.yahoo.com/group/vantage/message/68238;_ylc=X3oDMTJwZWR2bm
xkBF9TAzk3MzU5NzE1BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAM2OD
IzOARzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMjE5NzU2Mjcx>

Posted by: "jstockard990" jeff.stockard@...
<mailto:jeff.stockard@...?Subject=%20Re%3AReset%20a%20field>
jstockard990 <http://profiles.yahoo.com/jstockard990>

Tue Aug 26, 2008 6:11 am (PDT)

I am trying to make a Crystal report that shows me the last date that a
Customer had a Sale. I have the report and I can return all of the
Sales orders. When I use this formula, I get the date of the last Sale.

Global dateTimeVar LastDate;
local dateTimeVar Display_LastDate;

if DateValue ({BAQReportResult.InvcHead.InvoiceDate}) > DateValue
(LastDate)
then
LastDate := {BAQReportResult.InvcHead.InvoiceDate}
else
LastDate
However, I don't know how to reset the field on group change (I have
the records grouped by CustID). I want to only show the last Sale and
without resetting the field, it give me the date of the last sale to
any prevoius customer who has a Sale date greater than theirs.
Does anyone know the formula in Crystal to reset my field on group
change?





[Non-text portions of this message have been removed]
4
That did the trick. I had over complicated a simply report. Thank you

Jeff



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Linda Lowney
Sent: Tuesday, August 26, 2008 9:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re:Reset a field



Hi Jeff,

Have you tried sorting by date, then hiding the details? Then you can
place the invoice fields in the group footer and you should only see the
last invoice.

Regards,

Linda

Reset a field
<http://groups.yahoo.com/group/vantage/message/68238;_ylc=X3oDMTJwZWR2bm
xkBF9TAzk3MzU5NzE1BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAM2OD
IzOARzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMjE5NzU2Mjcx>

Posted by: "jstockard990" jeff.stockard@...
<mailto:jeff.stockard%40rikerprod.com>
<mailto:jeff.stockard@... <mailto:jeff.stockard%40rikerprod.com>
?Subject=%20Re%3AReset%20a%20field>
jstockard990 <http://profiles.yahoo.com/jstockard990>

Tue Aug 26, 2008 6:11 am (PDT)

I am trying to make a Crystal report that shows me the last date that a
Customer had a Sale. I have the report and I can return all of the
Sales orders. When I use this formula, I get the date of the last Sale.

Global dateTimeVar LastDate;
local dateTimeVar Display_LastDate;

if DateValue ({BAQReportResult.InvcHead.InvoiceDate}) > DateValue
(LastDate)
then
LastDate := {BAQReportResult.InvcHead.InvoiceDate}
else
LastDate
However, I don't know how to reset the field on group change (I have
the records grouped by CustID). I want to only show the last Sale and
without resetting the field, it give me the date of the last sale to
any prevoius customer who has a Sale date greater than theirs.
Does anyone know the formula in Crystal to reset my field on group
change?

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





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