SSRS Expressions(RowNumber,IIFcondition,Arithmetic Operations,sum of grouping value)

1.RowNumber Auto Generate

= RowNumber("Datasetname")

2.RowNumber  Auto Generate when we do particular filed grouping

= Runningvalue(FieldName.value,countdistint,"Datasetname")

3.using iif Condition Show the fields Report

=iif(isnothing(First(Fields!JournalDescription.Value, "InventJournalTransDS")),journal tax invoice,Journaltaxinvoice+ " - " + First(Fields!NEC_JournalDescription.Value, "InventJournalTransDS"))

4.Take textboxfields and do addition Operation.
=ReportItems!textbox1.value+ReportItem!textbox2.value

5.Take textboxfields and do Multiple and subtraction  and  Division Operation.

=ReportItems!textbox1.value * ReportItem!textbox2.value
=ReportItems!textbox1.value - ReportItem!textbox2.value
=ReportItems!textbox1.value / ReportItem!textbox2.value

6.In Report field level addition and multiple and subtraction and division Operation

=Fields!amount.Value + Fields!Curamount.Value
=Fields!amount.Value * Fields!Curamount.Value
=Fields!amount.Value - Fields!Curamount.Value
=Fields!amount.Value / Fields!Curamount.Value

7.In Report  sum of fields

=Sum(Fields!netAmount.Value)

8.In Report  Abs function(Retrieves the absolute value of a real number. For example: abs(-100.0) returns the value 100.0) 

=Abs((Sum(Fields!Amount.Value)))

9.In Report using expression  sum of  Group by value  division by entire sum of field value multiple with 100.
=(Sum(Fields!netAmount.Value, "Details")/Sum(Fields!netAmount.Value, "NEC_SalesContribution"))*100.

10.If we want to get the row number out of group scope, we can using the expression:
=RowNumber(nothing)

11.If we need get a row number in group scope, we can using the expression:
=RowNumber("Group1")
(Note: Suppose we have a group named Group1.)

12.Remove time from Date in Expression

=FormatDateTime(Fields!StartDate.Value,DateFormat.ShortDate)
  startdate = date and time