Mising Text with expressions

Hi,

can anyone tell me if it is possible to mix text and Expressions in a report cell? I am grouping a simple report by a Username column and I wanted to put some text at the beginning of each group that said something like:

The following gorup is for <username here>

But the only way I can get this to work is place the Text in one cell and the Expression in an adjacent cell. The expression I'm using is '=Fields!Username.Value'.

Thanks

Graham

[493 byte] By [Gravy] at [2008-2-11]
# 1

Yes, you can certainly concatenate constants and expressions. E.g.
="The following group is for " & Fields!Username.Value

--Robert

RobertBrucknerMSFT at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2
Ah, thanks Robert. I see what I was doing wrong now. I was putting the following in my text field which needless to say didn't work:

The following group is for =Fields!Username.Value

From your example I can see the right way to do it now. Thanks

Gravy at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified