In SSRS, I am creating a cascading parameterized report, where i have three fields. City AgencyID AgencyName
AgencyID is dependent on City and AgencyName is dependent on AgencyID .
When i am selecting city, corresponding AgencyID of that city is appearing but when i select Any of the AgencyID, AgencyName is appearing blank
Please run your query manually by providing the agency_id value and see if there are any results. Reason because if the query does not yield any results then we do not see a drop down list in the report.
Make sure the parameter name under parameters and the parameter name being passed to the query are matching. SSRS matches that when using a cascading drop down.
Hope this helps!
www.roughbook.co.in