I have created a SSRS table that i have created with SharePoint data source. I have more than 30 column with yes and no value in that SharePoint list. I am trying to count the yes values, and then display top 10 columns on this SSRS report. I am able to pull the true count but however not able to only show top ten. Should i create a new table to pull information from this table on the same report?
I had the same scenario. My Approach: Created custom function , which give the index of group of rows. And using the row visibility function, i have hidden all the rows greater then 10 index.
1) Custom Function:
Dim Counter as integer=0 public function getGroupCounter() as Integer Counter=Counter+1 return Counter end function
2) Set Row visibility In the row visibility section, have added the following expression:
=IIf(Code.getGroupCounter() <= 10 ,False, True)
3) Group sort behaviour Change the sorting behaviour of the group