dbo.ZLDT020_CRRCLM.CRRCLM_CD_DS in @Prompt(‘Select Curiiculum’,‘A’,‘Crrclm\CRRCLM_CD_DS’,Multi,Constrained)
crrclm_track_CD_dS
dbo.ZLDT894_TRACK_CD.CRRCLM_TRACK_CD_DS in @Prompt(‘What Crrclm Track?’,‘A’,‘CrrclmTrack\CRRCLM_TRACK_CD_DS’,Multi,Constrained)
But how do I show values in CRRCLM_TRACK_cD_dS based on CRRCLM_cD_dS picked by the user
I need 2 prompts ONE FOR crrclm and the other for TRACK.Is there a way we can control the 2nd prompt so that based on the 1st prompt values we get corresponding values in the 2nd prompt?
That is an enhancement request that I’d love to see implemented – it is not currently a built-in feature. Alternatively, you can take a look at Cascading Prompts.
I do not get any error messages but cannot get the 2nd prompt values based on the 1st prompt instead I get all the values in the 2nd prompt no matter what I select in the first prompt…
Can any one send me the detailed steps for creating cascading prompt’s from the database…
I have CRRCLM_CD_dS and CRRCLM_TRACK_CD_dS objects created
dbo.ZLDT894_TRACK_CD.CRRCLM_TRACK_CD_DS in @Prompt(‘What Crrclm Track?’,‘A’,‘CrrclmTrack\CRRCLM_TRACK_CD_DS’,Multi,Constrained)
dbo.ZLDT020_CRRCLM.CRRCLM_CD_DS in @Prompt(‘Select Curriculum’,‘A’,‘Crrclm\CRRCLM_CD_DS’,Multi,Constrained)
and now I want the user to select CRRCLM_cD_dS AS IST PROMPT and depending on the value selected in 1st prompt values in CRRCLM_CD_TRACK_cD values are to be displayed.
you can NOT create two prompts and have values for second prompt change according to first prompt, unless you use sdk. you have to create one object A and for LOV’s of A you should create a prompt asking for object B. So when the report is refreshed, you will be asked for entering values of B. And then the values shown for A will be based on values you provide for B. In this case you will see only one text box at a time.