Help with running totals

[ukleaf]

Morning people,

I have a quick question, I have several running totals in a report that reset at the change of a group. This is fine as it is but in the evaluate section I would like it to evaluate on the change of a field and when it finds a particular string.

I realise I will have to do this in a formula but is there any code to force it to evaluate at the change of a field in a formula?

Sorry if that doesn't make sense, if you need any more information please let me know.

Many thanks.

 

[Madawc]

{your.field} <> Previous({your.field}) should do it, if Crystal allows Next and Previous in Running Totals.

Alternatively, you could add an extra group, just for that field. No need to show anything for it, but then the value would be automatic.

There is also the 'Distinct Count' function.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. My workplace has recently upgraded from Crystal 8.5 to Crystal 10, both using databases created by SQL 8.

Madawc Williams (East Anglia, UK)

 

[ukleaf]

Sorry, yes I use Crystal 10 also.

I'll give that a try now and let you know how it goes.

Thanks very much.

 

[jraheja]

You have coniditional checking in running totals too...