Not sure how to do this?

[Former Member]

I'm far from a Crystal expert; I just know the basics.  Hoping you can point me in the right direction on this report.

The report is comparing user account data (names and positions) between tables that live in two separate databases.  This report is basically a "clean-up" tool for spelling errors.  I am printing data for those records that do not have matching first_names, last_names, or job_titles.  I had to use the "replace" function to take care of some differences that we can't do anything about (the Active Directory table won't do slashes, and they use them in the other table, so I have to ignore those differences).  And that works fine. This is the record selection formula I used:

{ActiveDirectory.givenName}<>{EMPLOYEE.FIRST_NAME} or

{ActiveDirectory.sn} <>{EMPLOYEE.LAST_NAME} or

(Replace ({ActiveDirectory.title},'-',' ') <> Replace ({JOBCODE.DESCRIPTION},'/',' ' ) and

Replace ({ActiveDirectory.title},'-',' ') <> Replace ({JOBCODE.DESCRIPTION},'-',' ')  and

{ActiveDirectory.title} <> Replace ({JOBCODE.DESCRIPTION},'/','-'))

I attached a screen shot of what the report looks like. (well, I tried - it won't let me post an attachment for some reason)

What I need to do now, is identify those items that do not match...somehow flag them in the second group of columns.  One suggestion was to place a column after the last 3 (the employee file fields), containing a "X" , if that value is different than the value AD fields.  I don't really have much room, I'll probably have to add a second line, but I don't know what to use to set this flag.  I also looked at the highlight expert, but I can only compare to actual values - not a field.  Any suggestions?

[abhilash_kumar · Accepted solution]

Hi,

A screenshot or a data sample would really help.

P.S: In the reply window you have an option to 'Insert Image'; could try that agian.

-Abhilash

[Former Member · Accepted solution]

Abhilash, I tried attaching a screen shot and it just simply gave me a message that that type of attachement was not allowed.  I tried both a jpg and a png file. I'll try it again...

[abhilash_kumar · Accepted solution]

Hi,

You can create a formula with this code and place it beside the last column:

if {ActiveDirectory.givenName} & {ActiveDirectory.sn} & {ActiveDirectory.title} = {EMPLOYEE.FIRST_NAME} & {EMPLOYEE.LAST_NAME} & {JOBCODE.DESCRIPTION} then

"Match"

else

"X"

-Abhilash

[Former Member]

Why not try some conditional formatting to color the fields which do not match?

Right click the field you want to test, choose Format Text and then choose the Font tab. Click the formula button next to the Color selection list box.

The formula would be something like: if {ActiveDirectory.givenName}<>{EMPLOYEE.FIRST_NAME} then crRed else crBlack

Do this for each field you want to test.

[Former Member]

I figured it out - thanks.  I hadn't noticed the background color option in the Border tab - doh!