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.
***Updated by moderator: Lochan to add Categories***
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?
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.
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.
Property for valueRequired
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 Definition Name
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.