Output error in Query for Weekly report
I want to create a report in which the user want the output of data as foloow
week1 week2 week3............. and so on.
Now there are 52 weeks in a year, and in system the data is stored since 2003 till date.
So user will want to enter the range of weeks that they want to see for e.g.
010/2005 -- -12/2007
Time characteristics available are
calendar day, calendar year/month, calendar year/week, calendar year,fiscal year, fiscal year/period,posting period
What i did is in columns for NET AMOUNT , i restricted kf with Fiscal Week and, restricted Fiscal week with Interval variable.
Now user wants that they want to see the
Start date of a week for monday.
So they dont want to see
week1 week2 week3 week4...........
But they wanted to see
01/01/2006 01/08/2006 01/15/2006 and so on.......
So Please advise what needs to be done!
<a href="http://www.box.net/shared/d05j3ngzru">Sample Code ...</a>
<a href="http://www.box.net/shared/i1tmtc6stf">User Exit</a>
Hope it Helps