Hi,
1. I have a value promt which is having 2 static choices like Emp and Dept and i take conditional block as well to show both.
2. When I select Emp, I am showing Bill Period(drop down-Value Prompt) and EmpNo(Select and Search Promt): This is fine for me
3. When i Select Dept, i am showing Bill Period(Value Prompt-Drop down),BU(Value Prompt-Drop down),Dept(Select and Search Promt),EmpNo(Select and Search Prompt).
4. i have given the string variable
case when (ParamDisplayValue('Param_Report Selection')='Emp') then 'Emp'
when (ParamDisplayValue('Param_Report Selection')='Dept') then 'Dept'
end and values i have given Emp and Dept
5. When i select Emp iam getting Emp related prompts and Dept as well. but if select Dept first its not promting me and its directly running the report. It shouldn't be case, should prompt me whatever i select
Can some one help if iam doing wrong.
Thanks,
Any update from anyone.
Hi
Is your Dept prompt is required in your query ?
Yes Its required.
Hello Experts,
If your not able to understand my query please post your suggestion. I will improve.
Is my question is sensible? nobody is having an issue earlier with this and if anybody done this earlier please provide your inputs. i hope this is basic query and i think everybody done this
Thanks,
Hello All,
I am updating the status if anybody requires. I have used cascading property to all my prompts which i used for static choices parameter. so its prompting now without running directly.
Thanks,