Hi all,

Im quite new to Crystal Reports and these days im working on a project with VB 6.0 and Crystal Report 9.

My question is, i need to display an address column, there i need to display a new line for every occurrence of comma (,) ..
for example, in the database the address will be saved as "No 23, Temple road, Galle, Sri Lanka" and think that is saved in one column as a single String. When i display in the report that should be displayed as follows

No 23,
Temple road,
Galle,
Sri Lanka

that is , for each occurrence of the comma, it will start to print the others from a new line..

Can anybody tell me how to achive that ? in which behavoir i have to set in the reports field ??

Thanks a lot in advance
Sajith
                  

Edited by sajhak - 06 Oct 2009 at 1:53pm

Thanks for the quick reply lockwelle,

Could i know where do i have to write the code that you have mentioned .. do i need to add as an expression in Crystal Report ? if so how can i achieve that ?

Or, do we need to add that "Replace" code into our VB code ? even if that s, how can i achieve that also ??

Thanks a lot .
Sajith

Thanks lockwell,

 i will try that .. i asked such a simple question cos im new to those Crystal report area ..

I got that ... thanks .. and it worked as i wanted .. thanks again ..