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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datatype TEXT 16 (MSSQL) CR XI

Status
Not open for further replies.
APB1981

APB1981

Technical User
Jul 10, 2005
83
NO
Hello,

It looks as though Crystal reports XI running on an mssql 2005 db is automatically trimming my TEXT field (memo). It is only showing the first 600 words or so. Any ideas?
What is the largest text size you can display in CR XI. I know there are some limits of adding these fields in formulas..By the way what is the max number of characters you can add into a formula?
Thanks

APB
 
Sort by date Sort by votes
I have just copied the text in Crystal reports and it looks like the text is being trimmed after 64,500 characters.. I did a quick count in MS Word. Is this a known limitation?

APB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
171
socalvelo
socalvelo
Paulo R
  • Locked
  • Question
CR Running Total distinct count duplicates
Replies
9
Views
219
Paulo R
Paulo R
Cpreston
  • Locked
  • Question
Remaining Text does not appear problem 2
Replies
10
Views
266
Cpreston
Cpreston
john432
  • Locked
  • Question
Crystal Report
Replies
2
Views
203
john432
john432
milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
376
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top