Dear all, I have to create a fixed width label by using reporting service. However, the content is mixing with Chinese words and English words, as you know Chinese words do not include any space between them. The width of the label can not be controlled. e.g. original width as below XXXXXXXXXXXXXXXXXXXXXXXX but chinese words will make the width expanded The last three words make the width expanded. How to set the report, so that the last three words can jump to second lines Thanks, Joe

Is that possible to count the words if there is space? DECLARE @s VARCHAR(100) SET @s = 'aardddvaaaarrkkkk' SELECT TOP 3 Number,SUBSTRING(@s, 1 + Number, 1) [char] FROM master..spt_values WHERE Number < DATALENGTH(@s) AND type = 'P' ORDER BY Number DESC That means you can start with position 16 till the end and cut off the words into the new line. Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and Optimization MS SQL Blog: Large scale of database and data cleansing MS SQL Consultants: Improves MS SQL Database Performance

Hi Joe, From your description, you want to enable the Word wrap functionality for the label of the chart axis. To achieve your goal, you can just disable the auto-fit property of the lable. Please follow the steps below: 1. Right click the target Axis, and open "Axis Properties" dialog box. 2. Click the "Labels" tab, change the axis label auto-fit options to "Disable auto-fit". In this way, each label has the same width and the word wraps if the length of the text beyond the width. Hope this helps. Regards, Mike YinMike Yin TechNet Community Support