Skip to Content
avatar image
Former Member

Crystal Report Reset Formula

I am trying to pull a specific contact from a list.

My report is layout

Group by Customer

Group by Job

then select contact where the description is like "*client*"

The problem I am having is that is the customer has more than one job listed I get the same results as the first job.

i.e.

Customer - ABCD

Job

1234 - Contact Unassigned (which is correct)

5678 - Contact Unassigned (which is incorrect)

If there is only one job then the formula works. Multiple jobs does not work.

My formula is

if {description} like "*client*" or {description like "*marketing*" then {firstname} + ' ' + {lastname} else "Unassigned"

I have this placed in the Job header. I believe I need to reset the formula after each iteration of job.

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers