Friday 2 June 2017

change date format in ssrs reports , hide field based on expression

format(Globals!ExecutionTime,"dd/MM/yy hh:mm:ss tt")

=iif((First(Fields!ReportName.Value, "SW_VoucherHeaderDS") = "Bank Receipt Voucher"),true,false) or iif((First(Fields!ReportName.Value, "SW_VoucherHeaderDS") = "Cash Receipt Voucher"),true,false) or iif((First(Fields!ReportName.Value, "SW_VoucherHeaderDS") = "IDE Expense voucher"),true,false)

iif(Parameters!Expense_Check.Value = "0",true,false)
// check parameter property Data type string or boolean // based on data type change the expression
 "0" or "YES"

No comments:

Post a Comment