April 7, 2007 at 9:37 am
Hello,
in a report in Reporting Services 2005 I want to create a top count 100 for groups.
I have a report sheet with a table containing some groups.
Under the groupings there are other groupings and so on.
Now I want that only the top 100, ordered by a value on group level of the 1st group are contained in the report.
Any ideas?
Best regards,
Stefan
SK
April 12, 2007 at 3:45 am
Hi SK!
U can use Filters of Group. you have to write an expression to filter Result except Top 100.
Alternatively u can apply Hide condition for that. To achieve this u need another column having Ranking 1 to 100 for 100 rows. Now use following expression in Visiblity Hidden:
=IIF(Fields!Rank.Value<=100,False,True)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply