Help with on change of group formula

[jvolden]

I am using Crystal Reports 11 and trying to write a formula that will assign a value to a field and then delete it on change of another field.

Deatils:
I'm grouping a report on Incident numbers
GH: Incident Number
D: Info
GF

I want a field to hold a certain value until the incident number changes. Here is the code in the field as of now:
datetimevar tt;
if "changed to Pending cust" in {activitym1.description}
then
tt:={activitym1.datestamp};

I would like the datestamp value to be held onto until changed or until the Incident number changes. Any ideas?

Thank you!

 

[synapsevampire]

Generally it's best to post sample data and expected output.

Your formula doesn't address Incident numbers, so I'm not sure what you really want.

try something like this:

whileprintingrecords;
if {activitym1.datestamp} <> previous({activitym1.datestamp})
or
{activitym1.IncNum} <> previous({activitym1.IncNum})
then
<some action>
else
<other action>

-k

 

[lbass]

Create a second formula:

whileprintingrecords;
datetimevar tt := datetime(0,0,0,0,0,0);

Place this in the group header.

-LB