SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
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?
How would you do it if L1, L2, L3, etc... were not from one field but are all different fields?
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
