Need to display the first 10 values of a Multi value parameter in SSRS report

Yassir 201 Reputation points
2020-10-17T11:58:11.697+00:00

Hello,

I have a Parameter called Product that contains more 50 products and i want to select only the Top 10 of my product ,i need that TOP 10 will dynamic it depends on date value .

What i did , i create 2 dataSet the first one have all Product and the second get me only the top 10 product it depends on date parameter.

After that i create a Parameter Product the Available Values source from the first "Dataset1" that have all Product and the Default values source from "Dataset2" that dataset selected only the top 10 of my produtct.

When i run the report for the first time , i have the Available Values and the Default Values Checked here no problem but when i change the value of my Date parameter , i didn't have a new Top 10 product checked in my Product parameter

Any idea and suggestions?

Thanks for help !!

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,806 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,126 Reputation points
    2020-10-19T07:25:33.19+00:00

    Hi @Yassir ，

    You may need to use the cascade parameter.

    Please also remember to choose the property of @tutor , advanced-always refresh.

    for reference:https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-cascading-parameters-to-a-report-report-builder-and-ssrs?view=sql-server-ver15

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.