karthik parcha

karthik parcha

  • NA
  • 153
  • 93.1k

SSRS:Datetime functions in SSRS

Sep 27 2011 3:21 AM
hi
I have to show last 3years account balances in SSRS
here i have given static text like account balance in 2008,2009,2010
="Account Value in 2008: "& FormatCurrency(Fields!ACCOUNT_BALANCE_1.Value)
="Account Value in 2009: "& FormatCurrency(Fields!ACCOUNT_BALANCE_2.Value)
="Account Value in 20010: "& FormatCurrency(Fields!ACCOUNT_BALANCE_3.Value)

i have to show dynamically when the year is increased  based on that i have to show last three years  from this year
plz help me how to write functions in SSRS
Thanks
karthik

Answers (2)