How to add a comma to separate Organisation Name and Job Position

Tom Yates

Hi, I wonder if someone can help me? I am creating a crystal report which looks at constituents who have been invited to an event. I have included the Primary Business Org Name and Position. Is there a way I can insert a comma after the Primary Business Position so it reads like so e.g. 'Database Manager, Tate Britain'. At the moment I have the information on top of each other but would like the information on the same line. Thank you in advance Ryan

Marie Stark

Ryan Abbott:
Hi, I wonder if someone can help me? I am creating a crystal report which looks at constituents who have been invited to an event. I have included the Primary Business Org Name and Position. Is there a way I can insert a comma after the Primary Business Position so it reads like so e.g. 'Database Manager, Tate Britain'. At the moment I have the information on top of each other but would like the information on the same line. Thank you in advance Ryan

Hi Ryan, You could create a formula like this, using the names of your fields:

{Position} + ", " + {Primary Business Org Name} and than add that formula to your report.

 

Christine Adams

Ryan Abbott:
Hi, I wonder if someone can help me? I am creating a crystal report which looks at constituents who have been invited to an event. I have included the Primary Business Org Name and Position. Is there a way I can insert a comma after the Primary Business Position so it reads like so e.g. 'Database Manager, Tate Britain'. At the moment I have the information on top of each other but would like the information on the same line. Thank you in advance Ryan

 Ryan,

 

You can also create a text box, place the position, add a comma and place the organization name

Tom Yates

Christine Adams:

 Ryan,

 

You can also create a text box, place the position, add a comma and place the organization name

Thank you Marie and Christine, I really appreciate both of your help with this. Thanks, Ryan