Hi Experts,
I have a report requirement where the user should be able to enter Day & month, Year, QTD/MTD/YTD and Balance Type(Day or Month). If user enters Dec 07 , 2011 with QTD data for Day Balance, then the data displayed should be for the months of Oct, Nov and Dec for Day Balances for the 3 months. If user enters MTD for the same selections, then data from Dec 1 to till date should be shown and if user enters YTD, then data from Jan 1 to till date should be shown.
Please let me know if this is acheivable, if so how?
Thanks in advance.