This may be an extremely simple question, but I am trying to combine two text fields (last name, comma, space and first name) into a new field that can be used as a GROUP in my report.
What is the simplest way to accomplish this?
One way would be to modify the SQL statement
[LastName] + ', ' + [FirstName] as FullName
Another would be to use a calculated field.
Fields!LastName.Value + ", " + Fields!FirstName.Value
cheers,
Andrew
No comments:
Post a Comment