Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

How do I get the plain text field to show all the data contained when it is generated in a report?

I have a report that shows different fields and the data contained therein.  The "Comments" field is a plain text field.  But it limits what is shown on the report.  Some of the notes in the comments field of the report are cut off.  How do I fix that?
0
tlahpalli
Asked:
tlahpalli
1 Solution
 
kelle1Commented:
Go to the properties of the Comments field on the report.  On the format tab, set the Can Grow property to Yes.
0
 
Rey Obrero (Capricorn1)Commented:

are this comments coming from a Memo field?
what is the record source of the report?

see if this apply to your case..

Truncation of Memo fields
http://allenbrowne.com/ser-63.html
0
 
pdi656Commented:
In the design view of the report, on the Comments field properties set the Can Grow property to Yes.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
tlahpalliAuthor Commented:
It is a memo field and generated from a query into the report.  I don't have the problem at all when generating a report through report wizard, but I also can't filter different things without a report through a query. This report I am working on right now showed Can Grow as Yes.  Is that simply just a freak error in how its supposed to run?
0
 
Rey Obrero (Capricorn1)Commented:
tlahpalli,
did you look at the link i posted above?
0
 
Jeffrey CoachmanMIS LiasonCommented:
First check the link capricorn1 posted and report back.



Please be specific:
<I don't have the problem at all when generating a report through report wizard, but I also can't filter different things without a report through a query.>
Then perhaps your filter is not correct...
Can you post what you are using to filter?

<This report I am working on right now showed Can Grow as Yes.>
Can Grow yes,. ..but  *Where*?, on what object?
There are many objects in the report that have a Can Grow property
(Sections and controls)
So when you say: "This report I am working on right now showed Can Grow as Yes."
...you need to be very specific.  Tell us the "Object" that this property is set on.

JeffCoachman
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now