I am new to Reporting Services. I have created a report (.rdl file) in Visual Studio 2005 to publish to SharePoint 2007. When I create the report, the report is ok. It fits the width of a normal page. However, when I publish the report to SharePoint, the width of the report is longer. The width is about the size of two pages. I looked at the settings in visual studio and it shows the property of "Interactive Size" as being "8.5in, 11in" which seems correct. I am attaching two images, one of the report in Visual Studio and one of the published report in SharePoint. My question is how to set the width so that it will correctly display the report to fit the width of the page? Visual Studio 2005 view with the correct width: SharePoint View with the incorrect width: Thanks Before Hand, Adiel

Hi Adiel, In SQL Server Reporting Services(SSRS), there are two properties for a textbox. They are CanGrow and CanShrink. When CanGrow is set to be True, and if the text is textbox is longer than the width of the textbox, the textbox automatically increases in size to accommodate a long value. When CanShrink is set to be True, and if the text is textbox is shorter than the width(or height) of the textbox, the textbox automatically decreases in size to fit a short value. In this case, it seems the City, Zip Code or other field are longer(may be, they are defined as datatype with long value) than the textbox, and the CanGrow is set to be True, this causes the width to be increased. In order to solve the issue, please remove the leading or trailing spaces from the fields, and set the CanGrow to be False. Please use the TRIM function to remove the additional spaces: =TRIM(Fields!City.Value) If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT