Tuesday, March 20, 2012

Crystal Reports - Replacing blank strings

Hi
Part of my report displays an Assignee's name, however if a job as been assigned to a team but not yet assigned to a team member, it displays nothing.
Any suggestions where/how to write a formula that replaces blanks with a custom string such as "Not yet assigned" ?

Much appreciated
ThanksHi
Part of my report displays an Assignee's name, however if a job as been assigned to a team but not yet assigned to a team member, it displays nothing.
Any suggestions where/how to write a formula that replaces blanks with a custom string such as "Not yet assigned" ?

Much appreciated
Thanks

I've done this a couple ways.

Method 1: insert the text object "Not yet assigned" in the same place as the Assignee's name. Format the Assignee field with a white background.

Method 2: prepare a formula @.assignee. if isnull({assigneefield}) then "Not assigned yet" else {assigneefield}

No comments:

Post a Comment