General information
Category:
Reports & Report designer
Title:
Calculated VariablesTruncating Data
Greetings!
I have a report where I'm using calculated variables to construct the contents of fields, to be used in a report. An example would be:
Variable: "SUGGESTION"
iif(!empty(evaluator_suggestion),"Suggestion: "+evaluator_suggestion,"")
Other variables are likewise defined, with the field in the report being defined as "suggestion + requirement + notes + ...". The report field is set to "Stretch with Overflow".
The trouble I am having is that the field data--in this case, "evaluator_suggestion"--is being truncated to 256 characters, even though it is a MEMO field. Everything works fine, even with all fields being combined, unless any one field happens to be over 256 characters, in which case its part of the report field is truncated.
Any suggestions??
Thanks in advance!
Michael Reynolds
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only