Compare a left function with the next function 1

[munchen]

I am using crystal 8.5 and I am connecting using SQL server to a micrososft access database.

I need to do a running total on a field and reset the total when the first 10 characters from the left are <> to the next 10 characters.

When I edit the running total field, I need something like the following in the reset use a formula options:

Left ({Text},10)<> Next(Left ({Text},10))

Any ideas?

 

[GJParker]

The formula you have should work fine, have you tried it ?



Gary Parker
MIS Data Analyst
Manchester, England

 

[munchen]

Gary,

Yes I've tried it but it says "A field is required here" and the cursor flashes after the Next( .

Left ({Text},10)<> Next(*CURSOR FLASHES HERE* Left ({Text},10))

Any ideas?

 

[dgillz]

Just create a formula:

Left({YourField},10)

Then create a running total to reset on change of this fomula field.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[GJParker]

Create a formula

//@Text10
Left({Text},10)

Then use this in the running total

{@Text10} <> Next({@Text10})

HTH



Gary Parker
MIS Data Analyst
Manchester, England

 

[GJParker]

Even simpler dgillz, well spotted.



Gary Parker
MIS Data Analyst
Manchester, England

 

[munchen]

many thanks to both gjparker and dgillz. I used dgillz formula option and it worked perfectly.