Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Seperating fields in a text box with a comma Post Reply Post New Topic
Author Message
dajsile
Newbie
Newbie


Joined: 17 Feb 2011
Online Status: Offline
Posts: 4
Quote dajsile Replybullet Topic: Seperating fields in a text box with a comma
     Posted: 21 Apr 2011 at 10:36am
I have a text box with embedded formula fields.
 

This is a sample of the contents:

Based on these results, We have determined that you can benefit greatly from using our {2@111} {3@222} {4@333} {5@444} {6@555} {7@777} Services.
 
Each of the formula fields are based on an if then statement.  If true it includes the "Text" otherwise it doesn't display anything.  I want to add a comma after each field if it is present in the text box and there is another formula field included.
 
Here are some examples of what I am hoping for:
Based on these results, We have determined that you can benefit greatly from using our 111, 444, 777 Services.

Based on these results, We have determined that you can benefit greatly from using our 222 Services.

Based on these results, We have determined that you can benefit greatly from using our 111, 222, 333, 444, 555, 777 Services.

Thank you for any assistance you can provide.
 
IP IP Logged
CircleD
Senior Member
Senior Member
Avatar

Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Quote CircleD Replybullet Posted: 21 Apr 2011 at 12:24pm
I may be wrong but you should be able to add   + ", " +  between each field of your formula.
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum