"Jerone Croos" <jeronecroos@gmail.com> wrote in message
news:%23j494EwCGHA.1312@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I have couple of reports which retrieves records with leading spaces. the
> leading spaces vary and forms the proper indentation for the fields to
> produce a visually pleasing presentation. unfortuanetly, after installing
> the SP1(even tried the SP2) the leading spaces are implicitly truncated by
> the reporting services. Anyone have come across this issue? any
> workarounds? or settings needed to correct this?

Christoph Wienands wrote:
> Hi Jerone,
>
> "Jerone Croos" <jeronecroos@gmail.com> wrote in message
> news:%23j494EwCGHA.1312@TK2MSFTNGP09.phx.gbl...
>
>>Hi,
>>
>>I have couple of reports which retrieves records with leading spaces. the
>>leading spaces vary and forms the proper indentation for the fields to
>>produce a visually pleasing presentation. unfortuanetly, after installing
>>the SP1(even tried the SP2) the leading spaces are implicitly truncated by
>>the reporting services. Anyone have come across this issue? any
>>workarounds? or settings needed to correct this?
>
>
> One workaround might be in the query to prefix the affected strings with one
> character, e.g. "|". Then in the report you strip of the character. Maybe
> that will work.
>
> Christoph
>
>

Potter wrote:
> Jerone,
>
> Is the data losing the leading spaces numeric data or varchar data? If
> it is numeric data, you might want to cast it as a string in your SQL
> and RS should preserve it.
>
> Another option is to use an expression on the Left Padding property of
> a report control. It does a nice job of identation.
>