We are on BOXIR2 Sp3 , SQL server 2000. to explain the problem in short this is what i am trying to achive.
Create a prompt in universe which will display static list of SL1,SL2,SL3 depends on user selection next list should display column from respective table after doing little search on cascading prompt i found the closest following solution which parse OK in the universe, only problem is whatever value i select from first LOV which is SL1,SL2,SL3 it always pop us the next list with value from the last @prompt statement (colored in red). any thoughts why it is ignoring the first selection.
((‘SL3’ = @prompt(‘1a Select Criteria’,‘A’,{‘SL1’,‘SL2’,‘SL3’},mono,constrained)
and
@Select(Current Assignment Tier\Assignment Service Line Group Level 3) = @PROMPT (‘1b Select Location’,‘A’,‘Current Assignment Tier\Assignment Service Line Group Level 3’,MONO,CONSTARTINED))
OR
(‘SL2’ = @prompt(‘1a Select Criteria’,‘A’,{‘SL1’,‘SL2’,‘SL3’},mono,constrained)
and
@Select(Current Assignment Tier\Assignment Service Line Group Level 2) = @PROMPT (‘1b Select Location’,‘A’,‘Current Assignment Tier\Assignment Service Line Group Level 2’,MONO,CONSTARTINED))
OR
(‘SL1’ = @prompt(‘1a Select Criteria’,‘A’,{‘SL1’,‘SL2’,‘SL3’},mono,constrained)
and
@Select(Current Assignment Tier\Assignment Service Line Group Level 1) = @PROMPT (‘1b Select Location’,‘A’,‘Current Assignment Tier\Assignment Service Line Group Level 1’,MONO,CONSTARTINED))
)
Thank you!!
Baapu (BOB member since 2008-05-16)