SSRS:Datetime functions in SSRS

Question

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

karthik parcha · Answer

Hi Prashant iam using SSRS2008 when i enter year 2011 in text box then past three years i have to displayed like 201020092008 again when i enter year 2010 in text box then past three years i have to displayed like 200920082007 plz help me how to write expression for that i wrote like this when the year is 2011 DatePart(yyyyNow)-1=2010 DatePart(yyyyNow)-2=2009 DatePart(yyyyNow)-3=2008 plz help me how to write based on the year entered by the user Thanks karthik

Prasant Jinaga · Answer

Hi Karthik In the Layout tab of SSRS 2005Go to Report Propertiesthen Code Tab write a function which takes year as a parameter and then in the expressions use that function. Thanks Prasant