I have prompt where my date looks like this
In case if i clcik 3rd month (3/31/2012)...i should get result of jan+feb +mar(no of days of month)
so here my result should be 31+29+31=91
Can anyone say how to do this
Make date is prompted in your report and create a new column in criteria with column formula as DAYOFYEAR("DATE"."CALENDAR_DATE").
This will give you sum of calendar days for year of selected date.
If you select 3/31/2012 then the result will be 91
if you select 3/31/2013 then the result will be 91
Hope this helps.