I have a report for which i have a column called patients. which i have to replace with Allpatients. i have a column called doctors, each doctor has many patients. initially it was giving only one patient i want all the patients with that doctor. i made the changes in my query using a function. in my report i need a expression by which i can replace patients to AllPatients and change line if any doctor as more than one patient. please helpHoneyBunch

Hi, I guess your function returns a string of all patients, ex.: "Patient1, ..., Patientn". If that is the case, you can REPLACE ", " by a carriage return (vbCrlf). If you get every patient on a separate line (all with the same info pertaining to the doctor), you can group your data and leave the patient on the detail level. Or you can use a subreport. Frantz

Hi There You just need to put this expression inside your textbox if you have a string =Replace(Fields!ID.Value,"Patient", "AllPatient" & Chr(10)) =Replace(Fields!ID.Value,"Patient", "AllPatient" & Chr(10)) but if it is not a string as then please give some more details how your data structure look like Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.