SharePoint 2010 Licensing for Hosting Providers

One of the hosting providers asked a question on MSDN forums that which licensing type would best suit their business, my reply to that question was marked as an answer, for complete thread kindly follow the link:

http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/e0d17f04-4370-45ad-b1ac-0c69cc0d7085/#f5c2c646-7388-4aca-aaa1-45981cb55a40

So in this case when you would be going towards the licensing model, you will be opting for SharePoint 2010 (Enterprise / Standard) for Internet Users / Sites and hence after this you won’t be worrying about CALs as CALs are only for Internal Users for masses you can’t calculate CALs so a totally separate licensing scheme is given for this case especially applicable to Hosting Providers.

sp-hosters 

http://www.microsoft.com/downloads/details.aspx?FamilyID=895A1DBA-0C3F-47A0-8D6D-163B50364335&displaylang=de&displaylang=en

Licensing Info: http://sharepoint.microsoft.com/en-us/buy/Pages/Licensing-Details.aspx

SQL Server 2008 R2 Reporting Services, SharePoint List Data Source

Increasing numbers of companies use SharePoint lists to store information that needs to be shared with a broader audience or in a standard report format. Although there are some creative ways you could employ to get that data into Reporting Services, custom code was always part of the solution.

SQL Server 2008 R2 Reporting Services has a new data extension provider that allows you to access SharePoint 2007 or SharePoint 2010 lists. After you create the data source using the Microsoft SharePoint List connection type and provide credentials for authentication, you must supply a connection string to the site or sub-site in the form of a URL that references the site or sub-site. That is, use a connection string such as http://MySharePointWeb/MySharePointSite or http://MySharePointWeb/MySharePointSite/Subsite. A query designer is available with this connection provider, allowing you to select fields from the list to include in your report.

Visio 2010 Create workflow & export it to SharePoint 2010

In this exercise you will create a simple process in Visio 2010 and export it to SharePoint Designer 2010.

1. Launch Visio 2010 and select the FlowChart folder.

clip_image002

2. Within the FlowChart folder create a new file using the Microsoft SharePoint Workflow template.

clip_image004

3. Click the Create button in the right pane.

4. Using the toolbox on the left hand side of the window, locate the SharePoint Workflow Terminators section and add a Start and Terminate shape to the diagram.

clip_image006

6. Open the SharePoint Workflow Conditions section and add a Compare Data Source shape to the diagram.

a. Double click and change its name to Check if manager approval is needed.

7. Open the SharePoint Workflow Actions section and add three Log to History List shapes to the diagram.

a. Double click the first and change its name to Log Manager approval required.

b. Double click the next and change its name to Log automatically approved.

c. Double click the last and change its name to Log submission to HR.

8. Add the process flow connections between the shapes. Use the image below as an example.

a. Add connections by hovering over the source shape, clicking and dragging one of the arrows to the target shape.

clip_image008

9. Label the connections flowing from the condition yes or no depending on the process flow.

a. Right click the connection from Check if manager approval is needed to Log Manager approval required and select Yes.

b. Right click the connection from Check if manager approval is needed to Log automatically approved and select No.

clip_image010

10. Save the process diagram to C:\ with a name of TimeSheet Submission Workflow.vsd.

a. Export the process by selecting the Process ribbon in Visio 2010 and clicking the Export button.

clip_image012

b. Save the exported workflow to C:\ with a name of TimeSheet Submission Workflow.vwi