Kill Extra Spaces In Crys 
Author Message
 Kill Extra Spaces In Crys

Hi Richard,

RL>        I am creating mailing labels using Crystal Reports, the one
RL>problem which I have encounterd is that i made some address fields
RL>seperate to make Key word searches easier. BUT i have notices that
RL>since i made the city field 10 char. long it pads with blank
RL>spaces...and on a mailing list

RL>Houston                                 ,TX 77032

RL>does not look attractive...other than making the state and zip code
RL>another lin e
RL>is there away to kill the spaces??

You can create a formula field to trim the database field, and then
print that formula in your report and not the database field :
   You can use TrimRight(databasename.databasefield).

For all the string and other functions available for Crystal reports,
check out the help files provided with CRW and the Formula Editor as
well.


---
* CMPQwk #1.42-R1* UNREGISTERED EVALUATION COPY



Sat, 18 Oct 1997 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Kill Extra Spaces In Crystal Reports

2. DTS Export to file extra space padding

3. ODBC with Extra spaces in String fields

4. Query analyzer adds extra space/newlines

5. xp_sendmail - csv - extra spaces

6. how to remove extra spaces ?

7. Remove extra spaces using T-SQL

8. dts adds extra space in fixed width export?

9. Extra Space In Fields

10. How to Overcome extra space in Dynamic SQL ?

11. extra spaces

12. extra spaces


 
Powered by phpBB® Forum Software