.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Help pulling data from Sharepoint List in SSRS

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server
Hi there, hoping somebody can help me out here.

I'm using SSRS and trying to connect to a sharepoint list.

I followed the steps here:

But I'm still getting an error. I'll give as much info as I can.

For the shared datasource, I'm using a link that when I plug it into a browser it brings back "Lists Web Service," so I think that part is fine.

When I try to enter the "SOAP CALL" into the Query string of my data set I get an error.
Soap Call:
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
<Parameter Name="listName">
<ElementPath IgnoreNamespaces="True">*</ElementPath>

Error Message:


Could not generate a list of fields for the query.

View Complete Post

More Related Resource Links

Pulling data from an Excel Speadsheet to a Sharepoint List

I have an Excel Spreadsheet filled with company phone numbers which I would like to pull into a Sharepoint List. I am unsure of how to go about this, as my only experience so far is using SQL statements for an Access Database to pull information from one location to another. I would also like this list to be searchable and sortable if possible. As another option, I have looked at Datasheet views in Sharepoint and it is possible that the data could be re-entered in here (will take a very long time though) but I unfortunetly also don't know how to export the data into a printable document from here. Any help with either option would be very much appreciated as I am quite new to Sharepoint! Thank you very much

how to add report parameters to filter list data in a ssrs report for a SharePoint List



i am using SQl Server 2005 reporting services to generate reports from MOSS 2007 Lists.

I need to define a parameter in the report to filter the data repective to that parameter dynamically.

like: in moss list there are three fileds A, B and C and i want to define field A as the report parameter, whenever i select the value of field A then on "View report" value of field B and C pertaining to field A should be display in report.

I am able to add report parameters but not able to attach to the report so that filtering can work.

Please guide me with solution

Pulling data from MyProfile page to People & group's list

Hi, Is it possible to pull the data from Profile page, like the email, contact number etc to be displayed in the People & Groups page. Please refer the screenshot for better understanding..

Link to the image: http://img694.imageshack.us/i/pplgrps.png/

Sharepoint list group by column data ,display in webcontrol like panel or label


I  have a sharepoint list[Managers] with groupby sector column. like below




Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?



Regards, Mansoor

Video: Accessing SharePoint 2010 List Data

In this video you will learn how to create strongly typed classes using a tool called SPMetal to do LINQ programming against a SharePoint 2010 list. (Length: 15:22)

Video: SharePoint 2010 Lists, List Data, and CAML

This demonstration illustrates how to work with list data and the Collaborative Application Markup Language (CAML). (Length: 5:05)

Importing SharePoint List Data into Project Server 2007 Custom Fields

Learn how to use the programmability features of Project Server 2007 and Windows SharePoint Services 3.0 to import SharePoint list data into an enterprise custom field.

C# newbie stuck - trying to access column data in a SharePoint list in an SSIS script task

Hello, I'm sure this is the simplest question but I can't figure it out, even with Google's help. I am trying to stumble through some C# code in an SSIS script task and I am frustrated that I can't figure out how to do the easiest things.  I eventually want to find data in a column,and then use another list as a lookup to replace that value with another where the existing value matches a value in the lookup list.  So, the data in my (multiple choice) column might be "apples; bananas" and in another list I have a row that contains two columns, the first holding the value "Apples" and the second containing "Red Delicious" and my original column should read: "Red Delicious; bananas." But, alas, I can't even figure out how to see the data that is in a column. Here is my code: /*<br/> Microsoft SQL Server Integration Services Script Task<br/> Write scripts using Microsoft Visual C# 2008.<br/> The ScriptMain is the entry point class of the script.<br/> */<br/> <br/> using System;<br/> using System.Data;<br/> using Microsoft.SharePoint;<br/> using Microsoft.SqlServer.Dts.Runtime;<br/> using System.Windows.Forms;<br/> using Microsoft.SharePoint.Utilities;<br/> <br/> namespace ST_08becda4c05c49cd9f30ea76110076cd.csproj<br/> {<br/> [

Read data from BLOB field and write to sharepoint list

Hi, I want to read the data from BLOB field and write it into sharepoint list item. Please provide some pointer to archive above objective.   Thanks in Advance.

How to export data from a sharepoint list to a SQL database

hi, is it posible if i add some data in a sharepoint list that i can export these data to my sql server tables. or if i create a dataview for exapmle from databse A in SPD to use in my wss3 site and then export it to database B in sql server? thnx

SSRS 2008 R2 - Sharepoint list item hyperlink bug?

I have created a report based on a sharepoint list and I am using a subscription in WSS 3.0 to email the report to the users once a week. I want one column in the report to act as a hyperlink to the sharepoint list item but in the email version of the report, the URL has the list item ID repeated twice, which renders the link invalid. Initially, I tried using the 'Encoded Absolute URL' from the sharepoint list query to populate the hyperlink but this just gives a 404 NOT FOUND error and I have found documented in several places on the web that this link only works with document libraries. So instead, I decided to create the URL for the action using an expression, like this: ="http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=" & ListItemID.Value This works perfectly in the development environment and when people run the report for themselves in the sharepoint document library where it is deployed but, for some reason, if I send the report on a schedule then I get the ID parameter repeated at the end twice. Like this: http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=999&ID=999 I have tried rendering the report in several different formats (Word, PDF, MHTML, HTML) and they all seem to work fine in the development and when run within SharePoint but not when they are rendered and emailed using the scheduler. Is this a bug or am I missing so

Submitting InfoPath data to a SharePoint 2007 List

Clayton, i sure hope you get this.  I would like to let the form get published to the form library and then workflow can create the new list item with all the required metadata mapped.  if data is updated i would like for the list item data to update as well.  currently i have an infopath form that is web-enabled.  i several views based on a status field as which view to open to.  this form have drop-down fields linked to list already on the sharepoint site.  i have tried using the "Submitting Data from Infopath 2007 to Sharepoint List" and it works as designed but unfortunately i cant customize the fields.  i need a dynamic user friendly form with drop downs etc.  any suggestions?

Connecting a Sharepoint Custom list with an external Data-source

Hi I am planning to connect a Sharepoint Custom list with an external Data-source. External DB will be in Access 2007 format. More Information: I need a solution that we can connect our sharepoint list (one-way) to online db in a way that new  information is directly updated in the sharepoint list, whilst other info changed in sharepoint list  is not synced back to original value. Is there a way to solve this? -saumil

Best way to display data of a single column from a Sharepoint Custom List

I'm trying to create pages that will automatically populate with data pulled from a sharepoint list (like title, department, contact info, etc.).   I'm using publishing pages. What would be the easiest way to do this, and how would I specify which data to pull from the list? For example, the page would be set up like this: [Title:biology] [Department:biology] [Contact Info:biology]   and when the page loads, it would look like this: Biology Lab Biology Department 123-456-7890   I want it to just pull the data -- I don't want a list view or anything like that.  I need this page to look pretty, and I need the each column's data to show up in a very specific place. How could I make pages that would do that?

How to use SharePoint 2007 list data in Reporting Service (Visual Studio) 2008?

Jeez - I have been googling left and right, and tried all the suggestions. No luck in getting it to work. I am using Reporting Service 2008 tools in my VS2008, trying to create a simple report using SharePoint 2007 data (from a simple list). Here is what I've been doing: Created a simple SharePoint list in a test site - only one column (Title) with one record of data. Started Visual Studio 2008 and created a new Report Server Project Wizard project. I named the data source "dsTest". Type: "XML". As connection string I used: http://site/subsite/subsite/_vti_bin/lists.asmx. Credentials: "Use Windows Authentication (Integrated Security)". Clicked Next and arrived at the "Design the Query" form. I entered this in the Query string box: <Query> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" /> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> </Query> Clicking Next I get this error: An error occurred while the query design method was being saved. Failed to execute web request for the specified URL. Soap Fault: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Now if I view the Details when trying it inside the Query Builder I get this: <errorstring xmlns="http://schemas.mi

Infopath Form Data submitting to Sharepoint 2010 List

Making a Client intake form that once submitted will send data to  a sharepoint 2010 List called contacts. Short Summary the form will have repeating fields and alot of information to submit. I have looked and read all over but I cannot find an easy step by step guild on how to submit the form data like that. Long Summary on the sharepoint site a button will open a form for adding a new client.  once the form has been filled out and the user hits submit sharepoint will then create a User File, in clients file, and take the data and put it into contacts list. I am trying to make use of Sharepoint as I would with access, meaning the more information I have on a client the easier it will be to mail merge letters, motions, basicly any file prepaired stuff. So once I have css designed forsharepoint to make it look the way I want then the forms should intergrate perfect

Excel External Table Data can only create new SharePoint List when Exporting from Excel?

I have a SQL Query that I refresh everyday in Excel. I want to be able to export this list over to a SharePoint list right after my refresh in Excel but I can only Export to a SharePoint list only once. If I try to export again to the same list then it will give me the error "The specified list name is already in use on this server. You must rename the list before publishing it to the server." I have web parts that have connections to this list and I do not want to export my Query to a new SharePoint list everyday. Does anyone know a way around this issue?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend