Hi!

I have to make a formula in Crystal Reports.Net, where I need to cut a field till a particular word and put the rest of the words left in a new line. e.g.

If my field contains "There was a boy who requsted a toy"

I have to show this as the following in my report.

There was a boy who
requested a toy

I am using the follwing formula

numberVar iCountLeft;
numberVar iCountRight;


iCountLeft=InStr ({RemedyDaily.customer_notes},"Requested")
iCountRight=InStrRev ({RemedyDaily.customer_notes},"Requested" ,0 )

Left ({RemedyDaily.customer_notes},iCountLeft ) & Chr (13) & Right ({RemedyDaily.customer_notes},iCountRight )

But, it gives me error "the remaining text does not apear to bepart of the formula".

Pls help how to achieve this. I am relatively new to Crustal Reports.