If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Pls help me in getting the logic

Started by Deepika, 31 Mar 2009 01:10:28 PM

Previous topic - Next topic

Deepika

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.