Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2009-12-10 : 04:34:17
|
| HiIs there a way in SSRS layout design to show the top 5 / 10 listed groups instead of showing the whole lot?Ive ordered it by highest value descending, just want to show the top 5 or 10. Is there a way to do it in SSRS without having to do it through query.Thanks |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-12-17 : 14:06:24
|
| did you try the filter feature, you might be able to filter it down to top 5 or 10 or whatever<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
Tahumars
Starting Member
15 Posts |
Posted - 2009-12-21 : 10:22:21
|
| Put a ROW_NUMBER() OVER (ORDER BY value DESC) AS Indx in your select statement, and then use the filtering feature to add the filter Fields!Indx.Value <= =CINT("5"). That should do the trick. |
|
|
|
|
|
|
Top 5