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 is the difference between Tabular and Matrix report?
Is ssrs support other database except ms sql server?
How to create median function?
What is command parameter in ssrs?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is the rdl file?
List out what other servers you can use with ssrs?
What are the different kinds of ssrs reports?
How to backup SQL Server Reporting Services ?
what are the new features in SSRS?
Can We Use Data-grids For Our Report In Ssrs?
what are the three command line utilities and what are their primary functions?