Concatenating fields together in Reporting Services

I have several fields in the report that are concatenations of two or more
datafields in the dataset. What we have found is that RS is padding out the
fields to the full size from the database, so if we put together, it doesn't
look right.
For example, if I go to put firstname and lastname together instead of
getting "John Doe" I end up with "John Doe". Does anyone know of
a way to tallow for the default to be not to pad out the field. The only
alternative that I have found is to trim() the fields as needed, but it
really slows down the development process.
Thanks
JeffWhat is the type of Lastname and firstname in the database. Is it nvarchar
or is it a specified number of caracters ?
I don't have this issue with varchar.
Cédric
"Jeffery J. Morgan" <jmorgan@._tranquilitysolutions.com> wrote in message
news:ORsk4POhEHA.1184@.TK2MSFTNGP12.phx.gbl...
>I have several fields in the report that are concatenations of two or more
> datafields in the dataset. What we have found is that RS is padding out
> the
> fields to the full size from the database, so if we put together, it
> doesn't
> look right.
> For example, if I go to put firstname and lastname together instead of
> getting "John Doe" I end up with "John Doe". Does anyone know
> of
> a way to tallow for the default to be not to pad out the field. The only
> alternative that I have found is to trim() the fields as needed, but it
> really slows down the development process.
> Thanks
> Jeff
>