How do I stop line feeds in a Hierarchy field from a SharePoint list to prevent wrapp
I'm developing a Reporting Services 2005 report that includes a Hierarchy field from a SharePoint 2007 list. The Data Source for the report is an XML type.
I would like to display the Hierarchy field on 1 line. However, it is displaying in 2 or more lines. The field also wraps when rendering to Acrobat (PDF) file. How can I get rid of the embedded line feed (I believe it's "
"). I've tried using the Replace function in an expression, other functions and changed the properties, e.g., the CanGrow property. Nothing seems to work.
Does anybody have any suggestions? Thanks.