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
Loading
karthik parchaPosted Sep 28, 2011, 6:10 AM
iam using SSRS2008
when i enter year 2011 in text box
then past three years i have to displayed like 2010,2009,2008
again when i enter year 2010 in text box
then past three years i have to displayed like 2009,2008,2007
plz help me how to write expression for that
i wrote like this
when the year is 2011
DatePart("yyyy",Now)-1=2010
DatePart("yyyy",Now)-2=2009
DatePart("yyyy",Now)-3=2008
plz help me how to write based on the year entered by the user
Thanks,
karthik
Prasant JinagaPosted Sep 28, 2011, 5:42 AM
In the Layout tab of SSRS 2005,Go to Report Properties,then Code Tab write a function which takes year as a parameter and then in the expressions use that function.
Thanks,
Prasant