Reports, Show only first 10 lines of field.

[itognet]

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]

Re: Reports, Show only first 10 lines of field.

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]

Re: Reports, Show only first 10 lines of field.

This did solve my problem.
Thanks you.