When i pull text based value from a database field with bullets the space alignment on second line of sentence required . Formula which will help would be great . I am using crystal report 2013
Use a formula to add the required HTML meta data to text and then view the formula as HTML, Format text to use HTML iterpretor
Or
Remove bullet points from text. Formula Mid (yourtextfield, 3, 1000) replace 1000 with max length of field.
Then just place text in a text box which is indented. Then using Wingdings add another text box which replicates the bullet style you want
Thanks for response. I may try your 1st point such as converting HTML meta data to text and view the formula as HTML.
The user copy a text of paragraph some with bullets from pdf or word then paste in a field which is a character type before paste user will change the phrases. This text i am trying to display again through PDF using crystal report. So when the displaying the sentence breaks to second line and third line based on length so now the starting word of second , third lines starts from margin without the space.
If bullets are not always there. Then I think the easiest solution is to standardise on NO Bullets. That is strip them out when present and solve the problem that way. Crystal is not really a document editor, its a report generator. Clue in the name (Crystal Reports).
I have produced some good customer documents for insurance companies but I have to work within the limitations of Crystal functionality.
Your formula output looks pretty good. I see that when the text wraps it is not indenting as far as you want. I think that is the issue you are having.
I wrestled with this and ended up coding my formula to break up the text into individual words in an array and then I determine how many words I can put on a line [based on a fixed line width I came up with]. Then, when I had to insert a break, I also inserted the tab character.
Here are some key pieces of my formula:
WrapLength := 100;
NumLFsBetweenBullets := 2;
// split text into array of words
word_array := split(text_field, " ");
WordCount := count(word_array);
For x := 1 To WordCount Do
(
new_text := new_text + word_array[x] + " ";
NewBulletLen := Length(new_bullet_text);
If x < WordCount then
(
If (NewBulletLen + Length(word_array[x+1]) - WrapLen) >= WrapLength then
(
WrapLen := NewBulletLen - Length(word_array[x+1]);
new_text := new_text + ChrW(13) + ChrW(9) + " ";
)
)
);
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.