Field01

=First(Fields!Field01.Value, "Dataset01")

String

= Left(Parameters!YYYYMM.Value,4) & "/" & Right(Parameters!YYYYMM.Value,2)

="(" & Fields!field1.Value & ") " & Fields!field2.Value

= Parameters!field01.Value + vbCRLF + Parameters!field02.Value

= First(Fields!Name.Value, "account")+ vbCRLF + First(Fields!Address1.Value, "account")+ vbCRLF +First(Fields!Address2.Value, "account")

Sum of Field01.

=Sum(Fields!Field01.Value)

=Sum(Fields!Field01.Value, "Dataset01")

If statement.

=Sum( IIF(Fields!Status01.Value="n/a", CDec(0.00), CDec(Fields!Status01.Value)))

=iif(Parameters!BusinessName.Value IS NOTHING, "", Parameters!BusinessName.Value + vbCRLF) + iif(Parameters!CustomerName.Value is nothing, "", parameters!CustomerName.Value + vbCRLF) + iif(parameters!CustomerAddress1.Value is nothing , "", parameters!CustomerAddress1.Value  + vbCRLF) + iif(parameters!CustomerAddress2.Value is nothing , "", parameters!CustomerAddress2.Value)

=IIF(Fields!field01.Value = 1, CInt(Fields!Total.Value), IIF(Fields!field01.Value = 2 OR Fields!field01.Value = 3 OR Fields!field01.Value = 4, "", FormatCurrency(Fields!Total.Value)))

Global

= Globals!PageNumber

= Globals!TotalPages

= User!Language

Date

= CDate(Now).ToString("F", System.Globalization.CultureInfo.CreateSpecificCulture(User!Language))

= CDate(Now).ToShortDateString()

= CDate(Parameters!field01.Value).ToShortDateString()

= CDate(Now).ToString("MMMM dd, yyyy", System.Globalization.CultureInfo.CreateSpecificCulture(User!Language))

= CDate(Now).ToString("MMMM dd, yyyy")

=format(Fields!sdtPostDate.Value, "MM/dd")

=IIF(IsNothing(Fields!field01.Value),Format(Fields!field02.Value, "MM/dd/yy HH:mm"),Format(Fields!field01.Value, "MM/dd/yy HH:mm"))

Currency

=FormatCurrency(Fields!field01.Value)

= formatcurrency(iif(isnothing(First(Fields!field01.Value, "account")), "0.00", First(Fields!field02.Value, "account")))

=Replace(FormatCurrency(Fields!currentAmount.Value), "$", "")

Switch

=switch(Parameters!field01.Value = 1, First(Fields!field03.Value, "report01"), Parameters!field01.Value = 2, First(Fields!field04.Value, "report01"), Parameters!field01.Value = 3, First(Fields!field05.Value, "report01"), Parameters!field01.Value = 4, First(Fields!field06.Value, "report01") )

Running Value

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-runningvalue-function?view=sql-server-2017

=RunningValue(Fields!Cost.Value, Sum, Nothing)  

=RunningValue(Fields!Score.Value,sum,"DataSet1") 

Bit

=IIF(Fields!bActive.Value = true, "ACTIVE", "NOT ACTIVE")

Number

=FormatNumber(Sum(Fields!field01.Value,"data01"),0)
Last modified: August 16, 2019

Author

Comments

Write a Reply or Comment