How to create “dependant” parameter “make, model, year”
Answer Posted / Magan Porwal
To create a dependent parameter for Make, Model, and Year in SSRS, follow these steps:nn1. Add three parameters: Make, Model, and Year.n2. Set the default values for each parameter as needed.n3. Create a shared dataset that fetches data based on the current values of Make and Model parameters.n4. For the Year parameter, set its Available Values to an expression that filters the year column from the shared dataset.nnHere's an example expression:n=Fields!Year.Value From (SharedDataSetName, "Make = @Make AND Model = @Model", "", "")
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category