General information
Category:
Reports & Report designer
John,
This worked! I have just never had this problem before.
Thanks for your help
>Jeff ----
>
>Try this: In the Properties dialog for the description, change:
>
>Expression to SUBSTR(description,15)
>Check off "Stretch with overflow"
>Clear anything out of Format.
>
>You should get all 15 characters. I'm thinking that the problem lies with the amount of space you have.
>
>
>
>>Hi Roxanne and John,
>>
>>I tried both the substr and left commands and get the same results as before.
>>
>>I am using the fields name from the table.
>>
>>
>>>>Hi all,
>>>>
>>>>I have report with a description field the client wants a ton of fileds on the report so I have the description field to show only 15 char of the 30 char field. The problem is it does not show the first 15 char all the time. For some reason if a space is in the description then it will break there if the next word goes over 15 char.
>>>>
>>>>I have never seen this happen before but I did verify this by changeing the data.
>>>>
>>>>Does anyone know of a workaround for this?
>>>
>>>What about putting a SUBSTR() function in the field expression to pull out the 1st 15 characters?
Previous
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