Hi Admin and Friends,
I need your help, I am supposed create a report with a prompt. The Data in table "Year" is like this ...
Table ---- Year
---------------
Year Qtr
1999 4
2000 2
.. .
.. .
... .
.. .
2003 1
2003 1
2004 3
2004 4
2005 1
2006 2
2007 4
2007 1
2008 1
2008 3
2009 4
-----------------
and the prompt should pull the data for
1.current 4 years data or
2.current 12 years data
I need to create a prompt in such away that the prompt to should pull the data for current 4 years data or the current 12 years data
suggest me how proceed
I need to your help.
Thanks in Adv
claoker
I would create a value prompt with two static choices: "Current 4 Years" and "Current 12 Years".
In the report, I would create a couple of query items, one with the current year and the other with the current year less 3 or 11 depending on the result of the prompt and then create a range filter on the reporting year using these query items (reportyear between startyear and currentyear)
For example, if the current year is 2009, and the prompt choice is for "Current 4 Years", then the "start year" = 2009 - 3 or 2006. So the report would select 2006, 2007, 2008, and 2009.