Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1316
  • Last Modified:

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.
0
Mark Roberts
Asked:
Mark Roberts
1 Solution
 
Rainer JeschorCommented:
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 RobertsAuthor 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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now