when report exported as CSV file seperated by '|'. each record must end with data and not '|'.if last column field is empty or null for certain records, the record ends with '|'.Is there any option in export or repot to avoid this situation.

Not that I am aware of. A post Crystal Reports application would have be used (VB, VBA, etc.) to strip the '|' off.