Expressions in db text file

bdmiller

I have a table containing a text(memo) field for each user. They create a message(No problems here). When creating the message they have an option to put a var ie [ClientName] and [EmployeeName] into the text field.

i.e Dear [ClientName] thank you for your custom many regards [EmployeeName].

Each employee has the ability to create there own message.

My problem

I have created the Var in fast reports as instructed(I use variables all the time).
How do i get fast reports to auto fill the Var in the text(memo field).

Instead it displays as
Dear [ClientName] thank you for your custom many regards [EmployeeName].

Instead of
Dear Mrs Smith thank you for your custom many regards Brian.

Petter S.

Hi.

Possible reasons:

* Property 'Allow expression' set to false
* Property 'ExpressionDelimiter' set to other than '[,]'

Petter

bdmiller

Thanks Petter

That was the first thing I checked.
I use variables all the time in normal text(memo) field, and have no problems with that.

I can't figure out how nto make the same var work in a stored text field, i.e a db memo field.

bdmiller

Found it myself;

Just in case anyone else is looking.

Expressions don't work in db text(memo) fields.

Load db memo field into fast reports as a text file. Remove the data band, replace with a text box(memo). This works as expected.