Hi,
I am working on a Crosstab Report.I have a 3 prompts
1.Crop year (Values:2005,2006,2007...)
2.Start Pool week (Values:Jan 1 2009,March 1 2009...Dates..)----based on the query item:Pool week
3.End Pool week(Values:Jan 1 2009,.March 1 2009..Dates..)---based on the query item:Pool week
if the crop year ---2007 is selected and start pool week and end pool weeks ----Jan 1 2009 and march 1 2009 respectively.then I need to display:
Crop year Start Pool Week End Pool Week
2007 Jan 1 2009 March 1 2009 } ---Prompt value Selection
2006 Jan 1 2008 March 1 2008 }
2005 Jan 1 2007 March 1 2007 } ---- need to generate automatically based on the
prompt value selection.
In this way,i need to get previous years data for particular Crop year automatically. I need to get the data for crop year >= 2003.Please help asap.
Thanks in advance...
Deepika.