Elczar Adame's Shared Points on SharePoint

Archive for February, 2011

Share The Point – Manila


A half-day event on March 12, 2011 – Share The Point – Manila.

The goal is to promote SharePoint while educating and galvanizing members of the local communities in the participating cities around the benefits of SharePoint, Microsoft’s leading product today. This FREE event is limited to 200 seats.

For more details: http://www.sharingthepoint.org/new/SitePages/About.aspx

So make sure you register now: http://www.sharingthepoint.org/new/SitePages/Registration.aspx

SharePoint 2010 and Reporting Services Integration


We can easily integrate SharePoint 2010 and SQL Server 2010 R2 Reporting Services. We simply need to do some configuration tasks on the report and SharePoint servers and we could already enjoy publishing and managing reports in SharePoint.

This paper will show us the basic configuration, report creation, and publication steps.

1. We will start by installing Microsoft SQL Server 2008 R2 Reporting Services in our report server.

2. Using the Reporting Services Configuration Manager, we will configure our the Reporting Services in SharePoint Integrated Mode.

1

3. Now let us open the General Application Settings in our Central Administration.

3

4. If the Reporting Services component is not available, it means that it was not installed as an optional software during our SharePoint installation process. Not a problem! Simply download and install the add-in from the Download Center.

2

5. Now, let us go back to the General Application Settings in our Central Administration and open the Reporting Services Integration under the Reporting Services section. Let us make sure that the Report Server Web Service URL, Authentication Mode, and Credentials are properly configured.

4

If necessary, we could also make use of the Add a Report Server to the Integration and Set Server Defaults facilities.

5

6

6. Next, we will open our SharePoint site, create a Document Library, and add the Report Builder Report and Report Data Source content types (notwithstanding that we will not be using the Report Data Source in this piece). This is where we are going to publish our report.

9

7. At this point, we will create a report.

10

8. In the Report Builder, we will choose the Table or Matrix Wizard.

11

9. Then, we will complete the Data Source Properties selecting Microsoft SharePoint List as the connection type, <SharePoint Site URL> for the connection string, and Windows User for the credential.

12

14

10. In the Design a Query part of the wizard, for our purpose, we will choose the Title and Created columns of the Announcements list.

15

16

11. And finally, we will save our report in the document library we have created in the early step.

18

12. And the we go, from the same document library, we could now open our report.

19

13. Additionally, we could edit our report using the same Report Builder tool.

17

Or we could create the same report using the SQL Server Business Intelligence Development Studio and publish it our SharePoint site.

8

Thank you very much!

Digg This

SharePoint 2010 Event Receiver


SharePoint 2010 has synchronous and asynchronous events that could programmatically be overridden. We can build custom event receivers that execute actions before (synchronous) or after (asynchronous) events on SharePoint site.

A SharePoint event handler may be a list, list item, list email, list workflow, or web event. This piece will show us how to add an event to the updating of list items.

1. We will start by creating a custom list in our SharePoint site.

1

2. Next, we will open our Microsoft Visual Studio 2010 and create a project using SharePoint 2010 Event Receiver template.

2

Let us make sure that the Visual Web Developer components are installed. Else, we will be prompted by the error below:

3

3. Along the process of project creation, we will choose the Deploy as a farm solution option as the trust/security level of the solution we are creating.

4

4. For our purpose, we will be choosing the List Item Events as the event receiver type and An item is being updated as the event to be handled.

5

5. Let us open our event receiver class and write the lines below. Note that the <SharePoint List Name> is the name of the list we have created in the first step.

public override void ItemUpdating(SPItemEventProperties
properties)
{
     if (properties.List.Title == "<SharePoint List Name>")
     {
          properties.Cancel = true;
          properties.ErrorMessage = "Update is not allowed in;
this list."
     }
}

6. And finally, let us deploy our solution.

6

Let us take note, that we might encounter this error during the deployment. It is normally caused by a misdefined element in our Elements.xml file.

7

Or we might encounter this error during the deployment if our SharePoint 2010 User Code Host service is not running.

8

7. However, if we have successfully deployed our solution and attempt to update an item in the list that we have created in this walkthrough, we will be prompted by the message below, as we have written in our custom event handler.

9

Thank you very much.

Digg This

SharePoint 2010 Excel Services


Excel Services is one the Service Applications in Microsoft SharePoint Server 2010 designed to publish Microsoft Excel 2010 workbooks for business data analysis. This piece attempts to provide us basic guidance to make the most of this feature.

1. We will start by preparing our data source by installing the AdventureWorks 2008 R2 Data Warehouse sample database.

2. Secondly, using SQL Server Business Intelligence Development Studio,  we will create an Analysis Services Project.

1

3. Next, we will configure our Data Source using the Connection Manager provided by the studio.

2

4.  Next, we will create a Data Source View including the dimension and fact tables. For our purpose, I have included the following table: DimDate, DimProduct, DimProductCategory, DimProductSubcategory, and FactInternetSales.

3

5. Now, we will create our cube by specifying the a Measure Group Table, Measures, and Dimensions.

5

6

6. And finally, let us build and process our data source.

7. At this point, we will insert data from Analysis Services into our Microsoft Excel 2010 spreadsheet specifying our preferred fields.

7

16

8. Then, we will publish our Excel file to a Document Library in our SharePoint site.

8

9. At this point, we will configure and start our Excel Services Application.

10

10. Now, in the Document Library where we have published or uploaded our Excel spreadsheet, let us view the file in browser.

15

11. And there we go, we have it now in our Web browser.

13

Take note that we need to properly configure and start our Excel Services, else we might encounter the error below:

9

12. Another option to have to have our Excel file in a Web browser is to use the Excel Web Access Web part provided by SharePoint 2010 by specifying the corresponding Excel workbook.

11

14

Thank you very much and hoping it helps!

Digg This

SharePoint 2010 Business Data Connectivity–External Content Type


Business Data Connectivity (BDC) service is one of the service applications of SharePoint 2010 as the innovated version of the Business Data Catalog in Microsoft Office SharePoint Server 2007. It is designed to associate business application data from various sources to SharePoint sites and lists.

This piece will show us on how to setup Business Data Connectivity with External Content Type through Microsoft SharePoint Designer 2010.

Yes, you have heard me right! Through SharePoint Designer. Below are the steps:

1. Let us start by preparing our database. For our purpose, let use the AdventureWorks 2008R2 SR1 sample database.

2. The next step is to assure that our Business Data Connectivity is properly configured and started.

2

3.  We will now open our SharePoint Designer and create an External Content Type.

3

We might encounter the error below if we have not properly configured our Business Data Connectivity Service.

1

4. Under the External Content Type Information section, click on the External System link to discover data sources.

4

5. On the next window, let us click the Add Connection button to define our Data Source.

5

6. Then, let us define our External Data Source Type and our SQL Server Connection. Since we have used the AdvantureWorks sample database in this piece, we will select SQL Server as our external data source type and AdventureWorksLT2008R2 for our database name.

6

7

7. Now in our Data Source Explorer, we will select the Customer table and click Create All Operations. This will provide us read item, read list, create, update, and delete operations.

8

8. At this point, in our Central Administration > Service Application > Business Data Connectivity Service, we will set the permission of our external content type.

12

9. Finally, let us open our SharePoint site, add an External Content Type list, and point it to the external content type we have just created. And we will have now a SharePoint list connected to our external data source.

15

Hope this would help!

 

 

 

 

Digg This

SharePoint 2010 and TFS 2010 Integration


Microsoft Team Foundation Server 2010 can automatically install and configure Windows SharePoint Services 3.0. However, it is absolutely possible to use SharePoint 2010. Below are the steps I have followed to make it working:

1. Primarily, I have installed SharePoint 2010, activated Excel Services Application and Secure Store Service, and created a Web application and a site collection. If necessary, you can also activate other service applications.

2. Secondly, I have installed Microsoft Team Foundation Server 2010 selecting the Team Foundation Server and Extensions for SharePoint features. If necessary, you can also select the other available features.

21

3. During the configuration, I have chosen the Advanced option to utilize the SharePoint instance I have previously installed.

22

4. In the SharePoint Products part of the configuration, I have selected the Use an Existing Server Farm for SharePoint option specifying the site and administration URLs.

24

5. After completing the configuration, I have connected to my Team Project and created a new Team Project using Microsoft Visual Studio 2010.

27

6. And there we go, I now have a project site and dashboard in SharePoint 2010.

28

I hope this would help!

SharePoint State Service


Have you encountered this error message upon opening your InfoPath form in SharePoint 2010, including out of the box and custom workflow forms? Nothing to worry, you simply need to configure the State Service of your SharePoint Server.

Error Message

The State Service Application is used by SharePoint Server 2010 for InfoPath Forms Services and other components to store temporary user session data. It is configurable through SharePoint 2010 Management Shell or Farm Configuration Wizards.

To configure the State Service using SharePoint 2010 Management Shell tool, as illustrated below, execute the following commands:

$serviceApp = New-SPStateServiceApplication -Name “<StateServiceName>”

New-SPStateServiceDatabase -Name “<StateServiceDatabase>” -ServiceApplication $serviceApp

New-SPStateServiceApplicationProxy -Name “<ApplicationProxyName>” -ServiceApplication $serviceApp –DefaultProxyGroup

Management Shell 

To configure the State Service using the Farm Configuration Wizards, as illustrated below, simply launch the Farm Configuration Wizards and select State Service.

Wizard

Hope this helps. Thanks.

Tag Cloud