Default Avatar

bdmiller

bdmiller

About

Username
bdmiller
Joined
Visits
0
Last Active
Roles
Members

Comments

  • 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.
  • 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.
  • Thanks guys for the help Both heading the same way. Mick.pl, many thanks for the explanation, this allows the end user to build their own header text file, just what I wanted to do. Can now move on. Great Forum Many thanks
  • I may be trying to explain this wrong. I have a report that has 2 Datasets connected. Dataset1 is a client table. Dataset2 is an Employee table. I have 1 data band connected to the report but not to the Datasets. client table gives t…
  • Thanks for the prompt reply from you guys, worked a treat. I had been trying to use Trim, but in the wrong place. Thanks, best service ever.
  • Thanks for the prompt reply Sorry tried that but still not working I have combined the two fields as expression [+] The whitespace allways appears. Can i set field widths dynamically from code as in sql, see code below SELECT RTRIM(…