Solved

# Crystal Report 2011 - String Concatenation

Posted on 2014-03-26
618 Views
Hello Experts
I am trying to write the below in the formula field but looks like its not accepting all the below as one string may be due to the IF statement? Please can someone advice how can I go about fix this?

Thanks

``````NumberVar d := CDbl({Lde.Day});
StringVar s := "This deed of entitlement is  made the ";
s := s & " " ;
If d >= 4 And d <= 20 Then
s := s & " " &   ToText(d, 0, "") & "th" ;
Else If d = 1 Then
s := s & " " &  "1st";
Else If d = 2 then
s := s & " " &   "2nd";
Else If d = 3 then
s := s & " " &  "3rd";
Else If d >= 24 and d <= 30 Then
s := s & " " & ToText(d, 0, "") & "th";
Else If d = 21 Then
s := s & " " & "21st";
Else If d = 22 Then
s := s & " " & "22nd";
Else If d = 23 Then
s := s & " " & "23rd";
Else If d = 31 Then
s := s & " " & "31st";

s := s & " day of " & MonthName(CDbl({Laird.Month}));

s := s  & " in the year " & {Lde.Year};

s;
``````

This to appear in one line as below

``````This deed of entitlement is  made the                        day of                           in the year
``````
0
Question by:meinIT
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2
• 2

LVL 101

Accepted Solution

mlmcc earned 250 total points
ID: 39957068
Try adding WhilePrintingRecords; as the first line of the formula.

mlmcc
0

Author Comment

ID: 39958442
Hi mlmcc
Thanks for your picking this up for me. I have added the statement in the first line but its still giving me this error. Please see attached.
untitled.PNG
0

LVL 35

Assisted Solution

James0628 earned 250 total points
ID: 39958477
You need to remove the ";" before each Else.  A ";" is put at the end of a statement, and your if-else-if-else is one statement.  You need a ";" before the first If, and at the end of the last If (after "31st").

FWIW, I would use Select-Case instead of the if-else-if-else.  I just find that easier to follow when you have multiple tests like this.  But that's just a personal preference.

James
0

LVL 101

Expert Comment

ID: 39958872
Good catch James.  I didn't notice them and since he seemed to indicate the formula was working (not reporting an error), I didn't look too closely at the code since it seemed to be correct for what he wanted.

As written it should produce an error when saved.

mlmcc
0

Author Closing Comment

ID: 39974568
Thank you both for your help! Apologies for the delay in getting back to you on this.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
###### Suggested Courses
Course of the Month4 days, 4 hours left to enroll