sql server reporting services: concatenation -- sql server reporting services

Re: concatenation

Bruce L-C [MVP]
6/5/2005 10:43:03 AM

sql server reporting services: Make the value of the textbox an expression. Right mouse click on the
textbox, pick expression. Brings you to the expression builder. In the
expression build put in the text and ampersand and then your parameter. You
should end up with something like this:

="Some text goes here " & Parameters!MyParameterWhichIsCaseSensitive.Value

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: concatenation

Bob Hansen
6/7/2005 10:20:01 AM

HI Bruce,

Do you know id there is a way to remove trailing spaces in a First_Name field.
When I concatenation First and Last, I end up with "Bob Hansen".
I guess it must be in the databse with trailing spaces... but I don't know
why.
I'll try to check it and see if that is tha case.

I was looking for a truncation function to strip off the spaces.
Any ideas????

THANKS!!! Bob Hansen
--
Robert Hansen

[quoted text, click to view]

Re: concatenation

tosonali
6/7/2005 10:55:29 AM

You should be able to use string.trim() class. Try this
=trim(firstname) & " " & trim(lastname)

Re: concatenation

tosonali
6/7/2005 10:55:35 AM

You should be able to use string.trim() class. Try this
=trim(firstname) & " " & trim(lastname)

Re: concatenation

Bob Hansen
6/8/2005 8:36:01 AM

THANKS Tosonali!!
after I the posted question I found where the vb functions are applicable to
the Report Designer...... I didn't know

Thanks again!
--
Robert Hansen

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.