Crystal Report - Memo Field

building reports crystal reports
1

While developing reports using crystal reports 2008 I am facing the below mentioned issue.

A memo field is used in the report which contains a combination of numbers and text separated by separator (square box here represented by &#)

I want to replace this number from this field with date time, replace the separator with a white space then the text.

I am illustrating this with an example on present output and what I desire

Present Output

1342156580Vijay_devTestingPhase
1342156584Vijay_devPlease check1342156621Vijay_devPlease look into this

What Is Desired

07-13-2012 10:46:20 Vijay_dev
TestingPhase

07-13-2012 10:46:24 Vijay_dev
Please check

07-13-2012 10:47:01 Vijay_dev
Please look into this

absolutesid (BOB member since 2012-08-17)

2

You’re probably not going to be able to manipulate this in Crystal itself as Crystal is not good at manipulating memo fields. Is there any chance that you can create a stored function in your database that will parse the memo and do the replacements? Then you could call the function from a SQL Expression (if you’re connecting to Tables) or in your Command (if you’re using a command to get the report data.)

-Dell

hilfy :us: (BOB member since 2007-04-16)