• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 767
  • Last Modified:

Crystal Reports - formula to wrap text after 10 characters.

I need create a formula the will allow me to control when to wrap text. I'm looking for a formula that I can put in the 'Can Grow' section to determine this. I cannot use the the text sixe to limit the characters.
0
jessieBoo
Asked:
jessieBoo
  • 3
  • 2
  • 2
1 Solution
 
peter57rCommented:
I think you will have to explain in more detail what you are trying to do.

You can use a code loop to add a Chr(10)  -new line-  every 10 characters .
Is that what you want?
0
 
jessieBooAuthor Commented:
No I want to be able to set the number of characters when a wrap of text will occur. Like after every 10 characters wrap text.
0
 
peter57rCommented:
I don't see the difference between 'wrap every 10 characters' and 'newline every 10 characters'?
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
jessieBooAuthor Commented:
What I'm trying to do is where you set 'Can Grow' there is a formula button.

I need to know how to set the number maximum number of lines in a formula based on the size of the string in the text box.
0
 
mlmccCommented:
You can't as best I can tell control the numer of lines from that formula.  It requires the result to be a boolean to indicate whether the field can grow or not.

Why do you want to control it?
If set to 0 it will grow as needed.

mlmcc
0
 
jessieBooAuthor Commented:
complicated to explain here why. Just need to do it.
0
 
mlmccCommented:
I don't think it is possible.  I don't know of any way to access that value from a formula.

Are you overwriting something below?

Is the growth causing an unwanted page break?

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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