concatenation

How can I concatenate text with parameter?
Until now, I was making two texboxes...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
"Jo?ko ?ugar" <josko_bla@.netgen_rem0ve_this_and_bla.hr> wrote in message
news:d7uu7o$8er$1@.sunce.iskon.hr...
> How can I concatenate text with parameter?
> Until now, I was making two texboxes...|||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
"Bruce L-C [MVP]" wrote:
> 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
> "Joško Šugar" <josko_bla@.netgen_rem0ve_this_and_bla.hr> wrote in message
> news:d7uu7o$8er$1@.sunce.iskon.hr...
> > How can I concatenate text with parameter?
> > Until now, I was making two texboxes...
>
>|||You should be able to use string.trim() class. Try this
=trim(firstname) & " " & trim(lastname)|||You should be able to use string.trim() class. Try this
=trim(firstname) & " " & trim(lastname)|||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
"tosonali" wrote:
> You should be able to use string.trim() class. Try this
> =trim(firstname) & " " & trim(lastname)
>