Not Quite WYSIWYG.

[Guest_imported]

Many years to coding, but new to SCR, using Ver. 7.0. The problem stems from displaying fields that contain strings with a length of one. These are "Y" for yes and "N" for no. Crystal is spelling out the actual words, but only assigning a length of two, which gives me a "No" and "Ye" on the screen and/or to the printer. To avoid using old English, I squeezed the fields (in design mode) down to a width of one, which looks great on the screen, but when I print it (from the screen or restart the report and run it directly to the printer) it fails to print anything in each of those columns. I've come up with a work around in the design screen showing the full first letter and half of the second letter. It gives me the single letter I want, but some folks will probably have a problem with the appearance on the screen. (I plan to push it out to them and move on to another project). Any takers?

 

[MalcolmW]

Several solutions, depending on the nature of the problem.
If the fields that contain strings Yes or No are actually boolean fields, then you can choose how to format the boolean field (yes/no, true/false, Y/N, etc).
If the fields are indeed strings, then you could just put the field in a formula which just extracts the first character of the string, such as
{yerfieldhere}[1]
Then you could insert this formula, have it as wide as you want, and it will always show no more than 1 character. Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?