Hi all,
Please tell me how to acheive the below calcualtion in report studio.
i am having FY value prompt , it display only years.
FY 2003,2004,2005,2006,2007,2008,2009
if i selecting 2009 , date range shud be 01-07-2008 to 30-06-2009(in calculation) and it is working .
but if i am selecting mutilple year how can i achieve that
...are you not using a date dimension?
what is populating your FY value prompt? ...it shouldn't be necessary at all to have to make this type of calculation in a report.
I am not using Date dimension.
It is much easier to have a date dimension to handle fiscal year - then you don't have to make calculations in the reports.