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
Showing posts with label strings. Show all posts
Showing posts with label strings. Show all posts
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}
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}
Subscribe to:
Posts (Atom)