Fiscal Year calcualtion

[EArumugam]

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

[david.stachon]

...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.

[EArumugam]

I am not using Date dimension.

[Sune Jorgensen]

It is much easier to have a date dimension to handle fiscal year - then you don't have to make calculations in the reports.