9 Replies Latest reply: May 22, 2014 8:23 PM by Jennifer Fisher RSS

Crystal report: How to concatenate the string whilereadingrecords?

rajeeshun Arudchelvam
Currently Being Moderated

I have description field in the database and I need to concatenate the value of the filed into one line. How to do that? I tried as below


Stringvar strtitle="";



if Mid({OrderDtl.PartNum},1,2)="T3" Then

strtitle & "T3- Background Music,"

Else if Mid({OrderDtl.PartNum},1,2)="T6" then

strtitle & "T6- Dance"


This is not working and showing only last value instead of concatenated string. I am very new to Crystal report and i am using Crystal report 2008