Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to concatenate values in RDLC expression?

Tags:

I have an RDLC file in which I want to make an expression. Here is the image of properties of expression. I need to concatenate First Name, Last name and Middle Init.

See the circled fields that I want to concatenate

like image 479
asma Avatar asked Apr 05 '11 13:04

asma


People also ask

How do I add a field to a dataset in Rdlc?

In the Report Data pane, right-click the dataset, and then click Add Query Field.

What is Rdlc full form?

What is an RDLC file? The RDLC stands for Report Definition Language Client side. Actually It is an extension of report file created by using Microsoft reporting technology. The SQL Server 2005 version of Report Designer is used to create these files.


1 Answers

The following examples works for me:

=Fields!FirstName.Value & " " & Fields!LastName.Value 

or

="$ " & Sum(Round((Fields!QTD_ORDER.Value - Fields!QTD_RETURN.Value) * Fields!PRICE.Value,2), "Entity_orderItens") 

Have a look at MSDN

like image 165
Eduardo Xavier Avatar answered Oct 16 '22 16:10

Eduardo Xavier