Friday, May 29, 2009

Report Viewer Web parts for SharePoint
Two types of Report Viewer Web parts are available :
1. Web Parts which come with SQL Server Reporting Services
2. Web Parts which come with the Reporting Services Add-in for Sharepoint
Though both web parts have same name the difference between them is that the web parts which come with the add-in will work only with Reporting Services in SharePoint Integrated Mode.
The web parts which come with SQL Server Reporting Services work with Reporting Services in native mode.

The SSRS web parts can be found on the server where Reporting Services is installed. The default location is “C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint\RSWebParts.cab”. To install these web parts, copy the RSWebParts.cab file on the SharePoint Server and run the following command at the command prompt.
“STSADM.EXE -o addwppack -filename "RSWebParts.cab" -globalinstall

Wednesday, May 27, 2009

System requirements for SharePoint Server 2010:

  • SharePoint Server 2010 will be 64-bit only
  • SharePoint Server 2010 will require 64-bit Windows Server 2008 or 64-bit Windows Server 2008 R2
  • SharePoint Server 2010 will require 64-bit SQL Server 2008 or 64-bit SQL Server 2005.

So, what can you do today to get into the best shape for SharePoint Server 2010?

  1. Deploying 64-bit is our current best practice recommendation for SharePoint 2007.
  2. Deploy Service Pack 2 and check SharePoint 2010 Upgrade Checker that’s shipped as part of the update. The Upgrade Checker will scan your SharePoint Server 2007 deployment for many issues that could affect a future upgrade to SharePoint 2010.


Locking down SharePoint Application pages

SharePoint 2007 application pages (_layouts) can be locked down to prevent users from accessing them. This is helpful not only in preventing users from accessing application pages they don’t need to be accessing on a public facing web site, but also in preventing search engines from crawling application pages.

To lock down your SharePoint 2007 application pages, use the STSADM command:

stsadm -o activatefeature -url -filename ViewFormPagesLockDown\feature.xml

This can be unlocked using :

stsadm -o deactivatefeature -url -filename ViewFormPagesLockDown\feature.xml

Note: By default, this SharePoint 2007 feature is deactivated, unless the site was created using the “Publishing Site” template

How to become a MVP

To become an MVP you should do following regularly

  • Active Participation in Communities
  • Writing Technical Articles
  • Participation in Technical Groups
  • White Papers
  • Speaker in Conferences
  • Speaker in Webinars

Free SharePoint webparts

Check the list available at Mark Kruger Blog :
http://www.sharepointblogs.com/mkruger/archive/2007/06/26/free-sharepoint-web-parts-3rd-party.aspx

Saturday, May 23, 2009

Important announcement on SharePoint Service pack 2
There is a bug in SP2, which Microsoft is currently working on and will soon release a hot fix. During the installation of SP2, a product expiration date is improperly activated. This means SharePoint will expire as though it was a trial installation 180 days after SP2 is deployed. Also, while installing the SP2 on WSS 3.0, you may get the following error : "The detection failed, this can be due to a corrupted installation database". Please read through the Microsoft SharePoint blog for more details.

Tuesday, May 19, 2009

SharePoint - Browser support

FeatureFirefox 1.5Mozilla 1.7Netscape Navigator 7.2Netscape Navigator 8.1Safari 2.0
Connect to Outlook/ClientY (1)Y (1)Y (1)Y 1)Y (1)
Context menuYYYYY
Drag and Drop (of Web Parts)Y (2)Y (2)Y (2)Y (2)Y (2)
Edit in Datasheet viewNNNNN
Edit In (Microsoft Office application)NNNNN
Explorer viewNNNNN
List attachmentsYYYYN (3)
Multiple file uploadNNNNN
New DocumentY (4)Y (4)Y (4)Y (4)Y (4)
Part to Part ConnectionsNNNNN
People PickerY (5)Y (5)Y (5)Y (5)Y (5)
Rich text ToolbarN (6)N (6)N (6)N (6)N (6)
Send ToY (7)Y (7)Y (7)Y (7)Y (7)
Web DiscussionsNNNNN
Web Part menuY (8)Y (8)Y (8)Y (8)Y (8)
Export to SpreadsheetY (9)Y (9)Y (9)Y (9)Y (9)
Date Picker ControlN(10)N(10)N(10)N(10)N(10)
Summary Links Web PartYYYYY (11)
Excel Calculation ServicesYYYYN
Slide LibraryNNNNN
Excel Web AccessY(12)NY(12)Y(13)N
Open in ExcelNNNNN
Open SnapshotNNNNN
Sorting and Filtering (Excel Services)NNNNN
Signing forms (Forms Server)Y (14)Y (14)Y (14)Y (14)Y (14)
Rich Text (InfoPath)N (15)N (15)N (15)N (15)N (15)
Rich text editing in Forms Server ormsNNNNN

Table Key:


Y - Compatible. All or most aspects of the user experience are equivalent. See Numbered Notes for any differences in user experience.


N - Not compatible. Item either is not available from the menu or will not function. Unless otherwise noted, this feature requires ActiveX controls, which run only in Internet Explorer.


Numbered Notes:


(1) These browsers will use the Connect to Client menu item on the Actions menu. This will open a client application that is registered to handle the stssync:// protocol, such as Microsoft Outlook.


(2) Web Parts cannot be placed by using drag and drop. You must click edit on the Web Part, select Modify Web Part, and select the zone from the Layout section of the Web Part properties page.


(3) This functionality is not supported because of an issue with the browser.


(4) Although the New button will not work, you can use the Upload Document button.


(5) Does not convert DOMAIN\Username to display name. If the name is not recognized, an error will be displayed.


(6) The toolbar will not be displayed; however, you can use HTML tags to display styled text. A link to a Help topic that describes the HTML tags supported will be provided under the rich-text field.


(7) With these browsers, and with Internet Explorer without the Microsoft Office client application installed, files cannot be sent from one farm to another farm. For files sent from a server to another server in the same farm, ASPX pages will be used instead of Windows dialog boxes.


(8) The drop-down list menu (triangle on the side of the control) has a different user experience, but the functionality is similar.


(9) This feature might work properly in these browsers. It downloads a file that has the .iqy extension to the browser. If Microsoft Office Excel is not installed, and no other application is configured to open this file, this feature will not work.


(10) Users can still enter dates into the date fields.


(11) When you click for a new link, the pop-up dialog box is the wrong size and the OK and Cancel buttons are partially obscured.


(12) You cannot sort or filter Pivot Tables. There is no work around for this.


(13) The Navigator 8.1 browser must be configured to render in Internet Explorer mode. For more information about switching modes, see the browser documentation.


(14) You cannot sign documents, but you can view signatures.


(15) The rich text is read-only by default. If you try to edit the text, all rich-text formatting is lost