problem concatenating text to a field value -- sql server reporting services

Dan D.
8/11/2006 6:09:01 AM

Using SS2000, VS2003, RS2000.
I want to put some text like "Totals for Enterprise " in front of the
Enterprise number in a group row. I have one that works and one that I get an
error ("#Error") on.

The one that works is this: ="Total " + Fields!Item.Value. The one that
doesn't work is this: ="Totals for Enterprise: " +
Fields!EnterpriseNumber.Value. I tried copying the first one that works into
the cell of the one that doesn't work and it worked. Then I tried changing
the word "Item" to "EnterpriseNumber" and I got the error.

Any ideas on what is wrong?

Thanks,
--

Dan D.
8/11/2006 6:31:01 AM

I got it. I tried using an "&" instead of "+" in the second one and it
worked. I don't know why one would work in one and not the other but at least
it worked.
--
Dan D.

[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 about sql server reporting services

sql server reporting services : problem concatenating text to a field value