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