SharePoint Content Reporting

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SharePoint Content Reporting

SharePoint Content Reporting

Rate Topic

Display Mode

Topic Options

Author

Message

SSSolice

Posted Tuesday, February 16, 2010 12:39 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, September 09, 2011 8:51 AM
Points: 291, Visits: 389

Please Suggest Any SharePoint List Content Reporting Tools.

I've looked at Enesys Data Extension for SSRS and I've looked at i/PMO DataMiner.

Any info is greatly appreciated.

Post #866325

branovuk

Posted Wednesday, February 17, 2010 2:13 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, June 06, 2013 10:18 AM
Points: 58, Visits: 266

Are you familiar with Report Builder 2.0?
It is a little extra work to find list ID (from URL, without extra letters, mine looks like: {3E170346-36F8-43DC-BBC7-A000EB8CA204}), but nothing you cannot achieve pretty fast.
For example, it looks something like this:
Select connection type: XML
Connection string:
http://server_name/_vti_bin/lists.asmx
Query:

Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
<Parameters>
<Parameter Name="listName">
<DefaultValue>{3E170346-36F8-43DC-BBC7-A000EB8CA204}</DefaultValue>
</Parameter>

<Parameter Name="viewName">

<DefaultValue>{3EEEF7B7-A7D3-41D5-BE77-05F79B39DB2D}</DefaultValue>

</Parameter>

<Parameter Name="rowLimit">

<DefaultValue>9999</DefaultValue>

</Parameter>

</Parameters>
<ElementPath IgnoreNamespaces="True">*</ElementPath>
</Method>

</Query>

You can find some articles on the net.
Brano

Post #867516

« Prev Topic | Next Topic »

Permissions