Change of record

[MrJC]

Hi all,

Quick question - I've looked through the group and I can't see anything similar, this is probably simple to do but it's getting late on a Friday and well that's my excuse

I've got a running total field - now I'd like it to reset on each change of record instead of group. I don't have any unique fields for the record, so I can't issue a 'change of field' reset.

Has anybody got any ideas on how to do this ?

Many thanks for any help !

Jon

 

[Naith]

One way forward is to concatenate the fields you're reporting in per row in a formula, and group on this at your lowest level. Suppress the header and footer, and reset the running total on change of the group.

i.e.
//Grouping Formula
ToText({ID})+{Name}+{Sex}+{Whatever}

I'm sure there are alternative ways, but I'm Friday Clock Watching too.

Naith

 

[IdoMillet]

Resetting on Each Change of record means you are not creating a total field at all. If you are simply looking to apply some condition, just create a formula.

hth,
- Ido CUT & Visual CUT: e-mailing, exporting, bursting, distribution, and scheduling of Crystal Reports:

http://www.MilletSoftware.com

 

[dgillz]

Ido is right on. You most likely mean change of group. you could have 1,000,000 records for John Doe, and if you reset on change of record they would all have the same value.

I believe you want to accumulate the running total for John Doe and reset it when the name changes, not on the next record. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[MrJC]

Thanks for the replies - you know, strange how something seems so ... err .. unclear at work, yet a few hours later you actually wonder why you were stuck on something?

I need the weekend

Anyways Ido, dgillz and Naith - cheers for the help, I'm following up on your suggestions, refining the group a little more. On Monday that is

Jon