SSRS Expressions


Expression for Page Numbers in Reports : 


="Page " + Globals!PageNumber.ToString() + " of " + Globals!TotalPages.ToString()

Expression for Formatting DateTime:


=FormatDateTime(Fields!EffortDate.Value, DateFormat.ShortDate)


Expression for Report Execution Time:


="Report Execution as on: " + Globals!ExecutionTime

Use of JOIN in Expressions:


="Selected Customer(s): "+ Join(Parameters!CustomerNumber.Value,",")

Conditional Expression:


= iif(FIRST(Fields!RunPeriod.Value, "SalesCSDCustomer") > 0,CDec(FIRST(Fields!RunPeriod.Value, "SalesCSDCustomer"))-1,"")

No comments:

Post a Comment