Skip to Content
0

Crystal Report Reset Formula

Oct 20, 2017 at 01:34 PM

14

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers