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="";

whilereadingrecords;

 

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

 

Thanks,

Raj

Actions