8 Replies Latest reply: Oct 19, 2011 7:51 PM by Abhilash Kumar 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