I am having a requirement for the generating a report for the selection field 0calmonth.if execute the report,the field name should get change for the previous years and i should get the data for the same.
Input : 200906
YTD' 200906(Dynamic) YTD 08 (Dynamic)
ARCHWAY SALES - CINCINNATI 1234 1234
ARCHWAY SALES - CINCINNATI 13,725 13,725.
Eg.. If i give the input as 200906 and execute the report then at YTD 08 place i have to get previous year ( 200906 has to be converted as 200806) so it has to generate dynamically .
Let me know if you have any queries