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

to find the minimum year and drag a setof records

Started by jrajvidya, 07 Dec 2007 08:55:21 AM

Previous topic - Next topic

jrajvidya

Hi All;

I'm using report net 1.1

I have the reqt like 2 prompts needed;
Year and first year
  One wo has multiple records of year see below table ( table 1)
  if i select year 2001
and first year is yes
   then---------------- it has to check WO whether it has 2001 and we need to drag that WO and its all years( table2 )


  if i select year 2001    and first is no   
       then----------- it needs to check which WO has the 2001 and need to drag that WO and its all years( table 3 )


if i select the  year 2000
         
table         
wo   year       
100   2001       
100   2002       
100   2003       
200   2000       
200   2001       
200   2002       
300   2002       
300   2003       
300   2004       
300   2005       
400   2001       
400   2002       
         
         
  year prompt   first year
prompt       
if 2001 and  yes then     
         
100   2001 it shud  check which wo has the minimum year of 2001
100   2002 and to drag all years of it   
100   2003       
400   2001  here 100 and 400 have     
400   2002       
         
         
  year prompt   first year
prompt       
if 2001 and  no then     
         
100   2001       
100   2002       
100   2003 it shud  check which wo has the year of 2001 
200   2000 and to drag all years of it   
200   2001       
200   2002       
400   2001 here 100 200 400 have     
400   2002       
         
         



how to implement this prompts....if any has idea pls help me