PDA

View Full Version : Reports, Show only first 10 lines of field.


itognet
March 27th, 2012, 01:42 AM
Hi.

I have made a custom report.
It it possible to show only the first 10 lines (or 1000 letters) of the description field ?'

Tx.

Support Team
March 27th, 2012, 06:31 AM
Thanks for asking. Here's what you can do:

The Description field is a memo data field (an unlimited text field).

When selecting it to be printed its entire content is available.
Usually the DbMemo field in the Report has the Stretch property set to True. This means that the field automatically stretches to any size based on the content of the data field. However, if you disable this property its size will be fixed, exactly as you set it (for all records).

To un-set this property select the DbMemo field while in the Report Designer, right click it and un-select the option 'Stretch' that is displayed in the menu that pops. Now, change the field height to the height you want it to be. This height will always be used and the field will not stretch automatically.

I hope this helps.
Dina

itognet
March 27th, 2012, 07:31 AM
This did solve my problem.
Thanks you.