Expressions in db text file
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.
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.
Comments
Possible reasons:
* Property 'Allow expression' set to false
* Property 'ExpressionDelimiter' set to other than '[,]'
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.
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.