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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

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

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
 
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


View Complete Post


More Related Resource Links

Visual Studio 2008 Professional v.s. Standard - support SharePoint 2007 sequential workflow?

  

I would like to ask if VS2008 Standard edition support the project type of SharePoint2007 sequential workflow?

I have a VS2008 Professional edition and it is Ok to create SharePoint2007 sequential workflow project and deply to MOSS2007 successfully.

Is it possible in a VS2008 Standard edition?

Thanks in advance.


sharepoint 2007 and visual studio 2008

  

Hello everybody,

I am kind of starting with sharepoint 2007 application development. I've windows 2008 server with share point 2007 server. The machine i will be developing the app is windows xp with VS2008.

1 -  How can I open/connect to a website in sharepoint from vs2008
2- Once connected, how can i debug my app it under vs2008
3- How can I upload my app to sharepoint site.

All I am trying to do is, write own custom web app for share point 
Thank for taking time to answer this questions.  


How to: include more project in a SharePoint 2007 Workflow solution in Visual Studio 2008

  
Hello!
I just develop  a little bit complex workflow and I want some objects put into an library (simple c# class project) project  in the solution. It is signed, referenced, but when I debug  it send a "System.IO.FileNotFoundException: Could not load file or assembly ..." How to resolve?
Thanks in advance, bts
bts

Cannot consume WCF Data Service from Visual Studio 2008

  

Hi all

I created  two similar oData services:

1. ADO.NET Data Service with Visual Studio 2008 and the .NET 3.5 SP

2. WCF Data Service using Visual Studio 2010

and they both work in IE.

I can make a Service Reference to the first one with VS2008.

The problem is when I try to use Visual Studio 2008 as a client and I try to add a Service Reference for the WCF Data Service made with Visual Studio 2010:
an Error (Details) occurred while attempting to find services at 'http://.............Myservice.svc'

and the Detail is:

DS_InvalidMetadataFile
Parameter name: edmxDocument

the xml of the 2 services is perfectly the same (with the exception of the url in the "base" attribute in the service node)

Any tip?

 

thx

 


how to use visual studio to debug sql server reporting service 2008 by attaching process

  

I did custom security extension and want to debug it. I used to debug it using visual studio by attaching its iexplore.exe process using visual studio 2005 and sql server reporting services 2005. After then, I can debug UILogon.aspx.cs and AuthenticationExtension.cs in Microsoft.Samples.ReportingServices.CustomSecurity.dll. When I set break point, it can reach.

Now I used 2008 version for all application. After I attaching process, it can't reach break point I set. I realize sql server reporting services didn't use IIS and it use another component to hold web app. I may affect it and unable to debug it ? Do I need to do any configuration or any thing before I can use visual studio 2008 to do debug by attaching process ?

thanks

Gary

 


SOAP Error 500 when query in Sql Server 2008 using for reporting a Sharepoint list 2007

  

I'm doing the reporting services for a SharePoint list, the datasource is configured as a connection with http://<Servername>/_vti_bin/lists.asmx and I add the parameters listName , rowLimit and viewName with the

How to get information about Sharepoint Running Workflow in Visual Studio 2008

  
Can any one tell me about. How i can get information about sharepoint running workflow in visual studio 2008.

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.

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

User Profiles Service Application and Import of SharePoint 2007 SSP data

  
I have setup a test SharePoint 2010 Farm. I will be using this as a test upgrade of a current live SharePoint 2007 Farm. The database attach method will be used. I have replicated the web application and AAM settings of the SharePoint 2007 Farm to the SharePoint 2010 Farm and have made the 2010 Farm a DC in a new Forest. I don't want to join this to the current domain at the moment. It also has SQL server 2005 with SP3 and cumulative update 3 installed. I have just setup the User Profiles Serice Application and when I go to Manage it, I get this. Error An unexpected error has occurred.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: a1760e87-372f-4711-afac-3ceba34bc599 Date and Time: 8/31/2010 4:22:56 PM I have verified and configured the following. Created the Managed Metadata Service. The status is started via Service Applications and Services on Server. Created the User Profiles Service Application and ensured status is started via Service Applications. I started the User Profile Service and User Profile Synchronisation Service via Manage Services on Server.      

Parallel Groupings are not showing the data in Reporting Service 2008.

  
Hi All, My main goal is to show rows under two adjecent groups (say A another one is B) which have one parent group lat call it as AB (all are row sections) and i have one column group for "months".The details inside the group A under the "months" group is not showing any values or expressions it returing me blank. Adjacent groups in SSRS 2008 still shows blank lines for invisible rows (why?). Any ideas.Please let me know. Veeren.

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?

Using Web Service in SharePoint 2010 Standard Web part using Visual Studio 2010

  
Hi All,               Have an issue with  Web service in calling  by SharePoint 2010 Standard Web part using Visual Studio 2010. If you can tell where I went wrong or tips to solve this would be great for me. What I have done is like this.. 1) Created new 'Empty SharePoint' project : as Farm solution 2) Added Web parts 3) Trying to add Web Service : There was no option for adding Web Service , so added as 'Add new Service' , this created entries in app.config file 4) ServiceName : shown as name space  (what  I'm  expecting is as Global  object with all methods ) 5) Created Object of namespace.ServiceName.ServiceSoapClient and tried to call one of it's method 6) Build and deployed 7) While viewing that web part it is showing an error as [InvalidOperationException: Could not find default endpoint element that references contract 'SerialKeyService.ServiceSoap' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element.]         Error in detail : [TargetInvocationException: Exception has been thrown by the target of an invocation.]   at System.RuntimeTypeHandle.CreateInstance(RuntimeType t

How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual

  
I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, if I create a shared data source and specify "Credentials stored securely in the report server", I can check the "Use as Windows credentials when connecting to the data source" checkbox. This tells SSRS that the user ID and password I specify are from a Windows user, not a SQL Server user. I want to create the shared data source using Visual Studio though. In Visual Studio I have an option to use stored credentials but there is no equivalent of the "Use as Windows credentials when connecting to the data source" checkbox. SSRS always assumes that user and password are for a SQL Server user, not a Windows user, and thus the connection fails. Does anyone know how to tell Visual Studio that the stored credentials are for a Windows user?

Getting error while retrieving data from sql server 2008 to infopath 2007 in sharepoint 2007

  
Hi, I have created an InfoPath form in InfoPath 2007. In this form I am getting data from SQL Server. To do this I have created data source for SQL Server 2008’s Tables. I have created 4 connections for 4 tables. When I am previewing this form from InfoPath Designer 2007, it is working. But when I am publishing this, it is giving me an error ‘Can not update content type’. If I skip this error then my form published but when I open this form from Share Point 2007. It gives me an error:   There has been an error while processing the form. Click Continue to resume filling out the form. You may want to check your form data for errors. Click Start Over to load a new copy of the form.   An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID: 6932 G. Goyal

SharePoint 2007 - Survey list - Getting user's Windows account ID from a web service using display

  
Surveys...grrrr.   I am developing a .NET console application that accesses survey data from a single survey list using the MOSS web service "Lists".   I am able to enumerate the survey list and get to the items except for the author of the survey response.  When I get to the column ows_Author, it appears to be a lookup value formatted like this:  "1066;#JOHN DOE".   How can I, using web services alone, lookup the corresponding Windows login ID of that user?  If I go to the survey in SharePoint and click on the name in the view, it takes me to a site-based user profile page that does show the account ID I want.  The page that displays appears to be a virtualized page like this "_layouts/userdisp.aspx?ID=1066".   What I really need is JOHN DOE's account ID like "domain\id". Can I get to this with the data I have available? Thanks
Categories: 
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