SharePoint 2010 creating SSRS report of a SharePoint List.

Posted on 2012-08-13
Last Modified: 2012-08-13
So I have SharePoint 2010 Foundation and SQL Server 2008 with reporting services setup.  I have created a report using the built in connector to SharePoint Lists.  However its only reporting based on my "Default View", which also limits the amount of items returned.  Is there a way to force the query to pull all items?  Or is there something im missing on this?  The list has all the data i need to report off of, i just need SSRS to pull it all in.
Question by:Mark Roberts
    LVL 44

    Accepted Solution

    a view in SharePoint has always an Item Limit (called row limit).
    You may add a parameter element in your report query:
    <RowLimit Paged="False">5000</RowLimit>

    Open in new window

    Or you can also set the limit in your view definition.

    LVL 2

    Author Closing Comment

    by:Mark Roberts

    Thanks for the response, that got me right down the road I needed.  This is the final query i ended up with, a just had to add:

        <Parameter Name="rowLimit">

    Into the top of the query to make it work.

    <RSSharePointList xmlns:xsi="" xmlns:xsd="">
        <Parameter Name="rowLimit">
        <FieldRef Name="Title" />
        <FieldRef Name="Rep" />
        <FieldRef Name="Status" />

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Introduction Earlier I wrote an article about the new lookup functions ( that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video discusses moving either the default database or any database to a new volume.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now