Concatenating fields with text SQL 2000

[goofaholix]

Other reporting tools I've used allow me to concatenate fields with text, either with an expression or by dragging and dropping.

Dragging and dropping doesn't work.

An expression as follows just shows the calculation as text:

='Open Work Requests for ' + Parameters!Customer_Name.Value

whereas what I'm expecting is the value of Parameters!Customer_Name.Value to be appended to the text.

I've tried "&" also.

Is it possible to do this?

Thanks.

 

[Sheco]

Did you try double quotes and an ampersand?

="Open Work Requests for " & Parameters!Customer_Name.Value

 

[goofaholix]

Yes, I was using singles but doubles solved it, doh!

Thanks.