Print Page | Close Window

Add text after formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22821
Printed Date: 23 Apr 2024 at 9:47pm


Topic: Add text after formula
Posted By: aspfun
Subject: Add text after formula
Date Posted: 10 Sep 2019 at 8:58am
There is a address formula @address for each member.
How to add a fixed phone number after @address?
I added it like below format but did not work.
@address + "800-555-6666"



Replies:
Posted By: DBlank
Date Posted: 11 Sep 2019 at 2:40am
Depending on how @address is being created it should be fine the way you did it. Assuming it is an address perhaps you wanted to add an line break to it?

@address + CHR(10) + "800-555-6666"


Posted By: kevlray
Date Posted: 11 Sep 2019 at 4:53am
And the address formula dis not evaluate to a null!



Print Page | Close Window