Hi There, I have made a report which summarises my SharePoint 2010 blog posts. It works nicely, however it returns every blog post (as expected in its current state). Is there a way I can limit this to only show say 10 results? In my case, I want to see the last 10 blog posts (so will be looking at a date) Thanks in advance! RobertRob Hardy

Just to add, I made this report in Report Builder 3.0Rob Hardy

if you are using a sql server data source for your report you can use the top function. The order your dataset by the data field in descending order to get 10 newest rows. example: select top 10 * from blog_table order by blog_date desc

i dont use report builder but I'm sure there is a filter option. There should be a TOP N filter to limit the rows.

Hi There, I am using the 'Microsoft SharePoint List' data source type. So for this, I just enter the URL, rather than a SQL Query. Any ideas??Rob Hardy

Any ideas?Rob Hardy

This feture is not available out of box with SSRS Regards,Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

Hi, Based you description, I recommend that you design your report by using the following steps, please see: 1. Add a group for the date filed named the DateGroup. 2. Set an expression for the row visibility as follows: =IIF(RowNumber("DateGroup ")>10,TRUE,FALSE) Thanks, Ai-Hua Qiu Ai-hua Qiu[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.