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.
__________________
Thanks.

Thanks

if the formula u pasted is the exact one u wrote then all i can see a missing';' at the end of iCountLeft line and iCountRight line.
try this

Stringvar x ;

numberVar iCountLeft;
numberVar iCountRight;


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

x := Left ({RemedyDaily.customer_notes},iCountLeft ) & Chr (13) & Right ({RemedyDaily.customer_notes},iCountRight );
x;