ASP.NET RDLC report concatenating two fields in one table field

Question

I return a model from the database containing userFName and userSName and wish to concatenate them in to a single name field in a report table. I've tried the following expressions and each time get #Error when the report is rendered.

=Fields!UserFName.Value & " " & Fields!UserSName.Value

=Fields!UserFName.Value + " " + Fields!UserSName.Value

I stepped through the code and my model is populated properly. I even trimmed the whitespace left over from char types thinking that may have something to do with it.

Lee · Accepted Answer · 2014-01-10 12:20:35Z

1

The problem was that my dataset had the field names in lowercase and I'd not refresh and reapplied them to the table.

Lesson learned: case sensitivity is important.

answered Jan 10, 2014 at 12:20

Lee

3,96912 gold badges49 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ASP.NET RDLC report concatenating two fields in one table field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related