I have two task in hand to achieve in a single report.
Application URL filtering - One ListID will be passed in the URL to filter the report. I achieved this by having @id as parameter for my datasets. In this scenario I only had one parameter in place.
Reporting Server filtering - For users who don't have access to application/db, they can go to the Reporting server and Select a 'ListName' from a dropdown parameter(@ListName) that fills the List ID parameter. I achieved this scenario by cascading parameters and having two datasets one for independent dropdown parameter(ListName) another for dependent parameter(ListID).
But since I cannot filter the report based on ListName from the application, I need a way to achieve both in the same report. When I try to filter the report using '?id=123' from application URL it does not filter the report.