Skip to Content
author's profile photo
Former Member

SQL Expression Question

To the forum members

In the Crystal Formula Editor, under Print State, there is a function called Previous. This compares the contents of the current field to the previous one. Is there a similar function in the SQL Expression Editor. I'm trying to use a Case When statement to compare the current value in two fields to their previous value. If these values do not match I need the SQL Expression to add 20 fields together and display the total.

Thanks in advance.

B.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 04, 2011 at 06:45 PM
    Add comment
    10|10000 characters needed characters exceeded