How to achive Qtr-1,Qtr-2,Qtr-3 and Qtr-4 on selected date?

[#1]

Hi,

I have a reporting date.On the basis of this reporting date we have month selections(list box) like Jan,Feb,Mar,Apr,May,June ..2009 etc.

If one person selects the June it should the data for the March and Jan 2009 he should see the data for Dec 2008. We have implemented this in the chart and working fine with the follwoing defination.

left(monthname(Quarterend(Reporting Date),-3),3) and =left(monthname(Quarterend(Reporting Date),-6),3) (Example for Qtr-1 and Qtr-2)

Now what i need is i need to show the Quater ePlnd months like Mar 2009,June 2009,Sep 2009 and Dec 2009 in one Object (LIST BOX ONLY PLEASE so that i can show this on the chart as check boxes)like Qtr-1,Qtr-2,Qtr-3 and Qtr-4.

Please assist me and if nay body implemented this send me the code.'

Thanks in Advance.

Ram.

[#2]

Similar to this requirement: Please any one can try to help out in achiving this.

-----------------------------------------------------------------------------------------------------------

Requirement: I have a Trends chart where i have to show "Last four Quarter End" + Current Month data.This should be dynamically achived.

Example: if i select July 2009 month then i should see the graph like

Please advice how to achive this.

Thanks in advance.