Hi,
Crystal Reports 2011 SP7. I have an report input parameter where the user can enter text. The desired presentation is to show the text as indented bullet items. Since the Crystal Input Parameters do not support multiple line input parameters, I devised a scheme to have the user precede each bullet line with a plus sign character. I have a formula that uses the replace function to replace the plus sign with Carriage Return, Carriage Return, Tab, Bullet, Tab.
This works great, however, if the bullet text wraps to the next line, the next line's text does not indent to where the bulleted text begins.
For example:
Input text:
+ Try a thing you haven’t done three times. Once, to get over the fear of doing it. Twice, to learn how to do it. And a third time, to figure out whether you like it or not. + Courage is not the absence of fear, but rather the judgement that something else is more important than fear.
Desired output:
[ul]
[li]Try a thing you haven’t done three times. Once, to get over the fear of doing it. Twice, to learn how to do it. And a third time, to figure out whether you like it or not.[/li]
[li]Courage is not the absence of fear, but rather the judgement that something else is more important than fear.[/li]
[/ul]
Actual Report Output:
____+_Try a thing you haven’t done three times. Once, to get over the fear of doing it. Twice, to learn how to do it. And a third time, to figure out whether you like it or not.
____+_Courage is not the absence of fear, but rather the judgement that something else is more important than fear.
NOTES:
1. See how the wrapped bulleted text does not align below the text above it, it left justifies.
2. I used underscores to represent spaces and plus signs to represent bullets since the HTML in this forum will not display these characters.
I think I need to Split the text for each bullet on a space character based on the maximum number of characters that can fit on a bulleted line. In my case the bullet line wraps at 95 characters, so I think I need to find the last space in the text at less than 95 and insert a CR and a couple TABS.
I appreciate any suggestions on how to implement this.
P.S. I can't believe that Crystal Reports does not support multiple line text input.
Thanks,
Crystal Reports 2011 SP7. I have an report input parameter where the user can enter text. The desired presentation is to show the text as indented bullet items. Since the Crystal Input Parameters do not support multiple line input parameters, I devised a scheme to have the user precede each bullet line with a plus sign character. I have a formula that uses the replace function to replace the plus sign with Carriage Return, Carriage Return, Tab, Bullet, Tab.
Code:
Replace({?bullet_input}, "+", ChrW(13) + ChrW(13) + ChrW(9) + ChrW(9679) + ChrW(9))
This works great, however, if the bullet text wraps to the next line, the next line's text does not indent to where the bulleted text begins.
For example:
Input text:
+ Try a thing you haven’t done three times. Once, to get over the fear of doing it. Twice, to learn how to do it. And a third time, to figure out whether you like it or not. + Courage is not the absence of fear, but rather the judgement that something else is more important than fear.
Desired output:
[ul]
[li]Try a thing you haven’t done three times. Once, to get over the fear of doing it. Twice, to learn how to do it. And a third time, to figure out whether you like it or not.[/li]
[li]Courage is not the absence of fear, but rather the judgement that something else is more important than fear.[/li]
[/ul]
Actual Report Output:
____+_Try a thing you haven’t done three times. Once, to get over the fear of doing it. Twice, to learn how to do it. And a third time, to figure out whether you like it or not.
____+_Courage is not the absence of fear, but rather the judgement that something else is more important than fear.
NOTES:
1. See how the wrapped bulleted text does not align below the text above it, it left justifies.
2. I used underscores to represent spaces and plus signs to represent bullets since the HTML in this forum will not display these characters.
I think I need to Split the text for each bullet on a space character based on the maximum number of characters that can fit on a bulleted line. In my case the bullet line wraps at 95 characters, so I think I need to find the last space in the text at less than 95 and insert a CR and a couple TABS.
I appreciate any suggestions on how to implement this.
P.S. I can't believe that Crystal Reports does not support multiple line text input.
Thanks,