SharePoint 2010 creating SSRS report of a SharePoint List.

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.
LVL 2
Mark RobertsIncident ManagerAsked:
Who is Participating?
 
Rainer JeschorConnect With a Mentor Commented:
Hi,
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.

HTH
Rainer
0
 
Mark RobertsIncident ManagerAuthor Commented:
Rainer,

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:

<Query>
<Parameters>
    <Parameter Name="rowLimit">
        <DefaultValue>9999</DefaultValue>
    </Parameter>  
</Parameters>
</Query>      

Into the top of the query to make it work.



<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ListName>Quotes</ListName>
<Query>
<Parameters>
    <Parameter Name="rowLimit">
        <DefaultValue>9999</DefaultValue>
    </Parameter>  
</Parameters>
</Query>                                        
  <ViewFields>
    <FieldRef Name="Title" />
    <FieldRef Name="Rep" />
    <FieldRef Name="Status" />
  </ViewFields>
</RSSharePointList>
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.