I was working on a SSRS report having two dropdown controls State & District which behaves as a parent -child dropdown.
My table looks like
And when I select State from the first Drop Down, I need the District drop down to be populated with values
This way user will come to know which state the district’s belong to.To do this I used the following query.
(select [State],District from dbo.T_TownSnapshot where state in (@State)
select [state], ‘~~’ + state + ‘~~’ as District from dbo.T_TownSnapshot where state in (@State))