hi,

 is it possible o show dropdown list for each and every column of tablix on it

my requirement is:

name  age branch  phone

sk        12    it          xxy

pl         14    it          xxz

gh        15    xx        xxa

sk         12   it           xxx

fd          09   it          xzg

if we click on name column ,then dropdown shouldcome with all values so that i need to select preferred data like gh or fd and see only those details

can we dhow dropdown on tablix like that.is it possible

pls help..its urgent

thanx in advance

Hi LuckyLucky12,

Based on my understanding, when you click on a column name, you want to make the drop-down list of the column values will display, then you can select the expected values from the list. The scenario should like the on-sheet filter within a Excel, right?

In Reporting Services, there is no on-sheet filter feature for us to filter the data. However, we are able to filter data based on the parameter values. In your scenario, I would suggest you create a multi-value parameter, and specify the available values for the parameter as [name] field. Then you can select the expected values from the drop-down list of the parameter to filter data. For more information, please refer to this article: Add a multi-value parameter to a Report.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu