Question
Selecting Property values
Hi All,
I have two properties with dropdown and having values A,B,C in both. If i select "A" in property one the values in second property should only display "B,C" to select and if i select "B" in property one then the second property should have "A" and "C" to select and Vice versa.
TIA,
Bharath
***Updated by moderator: Lochan to add Categories***
Hi Sunny_GCS
Thanks for your reply. It was bit complex for me. Do you have any idea using report definition.
Regards,
Bharath
It sounds like you need to start with a cascading dropdown design. Make sure that works first. Then see if you can apply filtering or other logic to intelligently remove the selected value from the other source.
Thanks for your reply Rett_Hean_GCS. Hope it might work. I'll tr and let you know.
Regards,
Bharath
I would appreciate if i get assistance from any of you
Thanks,
Bharath
Accepted Solution
Hi All,
I have a created a datatype with one field in it. I created a source with that and made it as key with three values A,B,C to that field. Now open the first drop down property and use list source as report definition, which was created along with the datatype. As a ReferenceIDType give Second Property as value, as Mentioned Below.
| Report definitionRequired |
|
| PARAMETER | Value | ||
|---|---|---|---|
| ReferenceIDType | .Property Two |
| Property for valueRequired |
.UniqueId
|
| Property for display text | |
In Report Definition: Write a filter, In Column Source (the filed created in data type - .UniqueId), Relation as not equal, Value as param.referenceIDType(Gave ReferenceIDType as parameter and whose data type is text).
For the second Property, follow the same and change the
| Report definitionRequired |
Report Definition Name
|
| PARAMETER | VALUE | ||
|---|---|---|---|
| ReferenceIDType | .PropertyOne |
Hope it helps. You may not understand my words. Pardon me for mistakes. I got the solution in this process. I cant share you every step as i can't take the screen shots.
Hi Bharath, I'm pretty sure your scenario has to be more complex than what you describe here. :)
Just specifically with this example that you mentioned, the easiest thing that came to my mind was using Post Value on the first dropdown and controlling the second dropdown through multiple layouts and having Visible Whens(that monitors the value of the first dropdown) on these layouts. Do you anticipate a problem with this approach?
Thank you