How to create “dependant” parameter “make, model, year”
Answer / 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 |
What are drillthrough reports?
what are the core components of SSRS?
What are sub reports?
Can I disable or restrict ssrs export formats (rendering formats)?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is encryption key?
Name and describe few console utilities for ssrs?
what are the different types of SSRS reports?
What is the rdl file?
Can we deploy SSRS reports on our personal website?
Name few endpoints exposed by ssrs 2012?
What is rs.exe utility?