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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
the number of characters displayed in a field
- Thread starter mondi
- Start date
For Crystal 8.5, open the Field Explorer. Right-Click on any database field and select [Show Field Type]. This will show the length of character strings for all database fields.
Numerics and dates don't have a length in the normal sense, they are based on SQL fields that you can't chose or adjust, I think they are binary fields. You have to set your own values based on the data that can be there.
Madawc Williams
East Anglia, Great Britain
Numerics and dates don't have a length in the normal sense, they are based on SQL fields that you can't chose or adjust, I think they are binary fields. You have to set your own values based on the data that can be there.
Madawc Williams
East Anglia, Great Britain
- Thread starter
- #3
I think you missunderstood me. I know how to find the length of a field but I don't know if there's any way for me to choose how many characters of a field to display in a report.
The idea is this: In my report I have a field which length is more than 200 characters and I don't want to display all the characters but to make a tooltip that would diplay all the characters of the field.
The idea is this: In my report I have a field which length is more than 200 characters and I don't want to display all the characters but to make a tooltip that would diplay all the characters of the field.
If you use certain fonts (e.g., courier, I think), you can control the exact number of characters displayed. You also have the option of controlling character spacing, but I think all you really need to do is drag the margin of the field until it is the desired length, and then add the string field to the tooltip formula area to achieve your goal.
-LB
-LB
- Thread starter
- #6
Use a formula field to control the characters displayed:
Left({MyField,# of desired Characters)
Onn the tooltip issue, I have no idea. I would love to know if you get an answer for that part of it.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Left({MyField,# of desired Characters)
Onn the tooltip issue, I have no idea. I would love to know if you get an answer for that part of it.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question