Showing posts with label strings. Show all posts
Showing posts with label strings. Show all posts

Tuesday, March 20, 2012

Crystal Reports 8.0 & long strings

Hello,
I need to know how can I display a fields data which has more than 255 chars.
Is there a solution of this problem?[ Moved thread ]|||where was this thread moved to? I am having this same issue.

Thanks.sql

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}