I am trying to report/sort/etc. on a 16 character Text field. Crystal Reports 6 interprets the field as memo type and so no sorting/grouping/etc. The field is defined in the database as allowing NULLS. Does anyone have any suggestions on to how to get this field as a text field (and not a memo field)?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Server 16 char Text field as Memo field?
- Thread starter Burble
- Start date
Have you check the database definition of the field? Even if the contents never exceed 16 characters, if it is defined as char(256) or varchar(256) or greater, SCR interprets it as a memo field. You can cast or convert it to varchar(255) or less and then SCR will treat it as a text field <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question