Not on first record

[aelsn]

I ran across a post the other day that I believe answered this question but I cannot find that thread now. I have a report grouped by salesperson and sorted by order number. Certain records have the same order number. I have a running total which looks at the previous order number and excludes that record if the order num = the previous and certain other criteria are met. Basically, I want to keep some of the "dupes" and exclude others. This is working the way I want and I am getting the expected results but the first record always gets excluded. How do I ask Crystal to run this formula for each record but the first?

 

[lbass]

Your evaluation formula should start like this:

(
onfirstrecord or
{table.orderno} <> previous({table.orderno})
) and //your other criteria

-LB

 

[aelsn]

Works perfectly. Thanks for the quick reply.