February 8, 2009
Surround SCM Charts
This example uses Microsoft .NET charts to create a stacked column chart that reports on check-in activity per branch per month. Figure 1 below illustrates how the chart may look like:
Works with Surround SCM 2009
About the web partThis web part was developed in Visual Studio 2005, with the code written in C#. The chart was tested against a Microsoft SQL 2008 database.
DownloadYou can download the web part from here.
DeploymentYou can find some high level instructions on how to deploy a web part here, but you should consult your Sharepoint documentation and/or Sharepoint administrator before deploying the web part.
ConfigurationThe web part queries the SQL Server that houses the Surround SCM database. The connection parameters must be configured for the Web Part to work. Once the web part has been added to a page, select Modify Shared Web Part from the dropdown options menu. The CIMonth window opens, as shown on figure 2 below.
The following parameters are required: Data Source – Enter the host name of the SQL Server User – Enter the username to use to connect to the SQL Server. The user only needs to be able to query the server. The safest approach is to use a user that does not have permissions to modify the database. Password – Enter the password for the user above. The password will be visible in clear text. Another reason why you should use a user that can only query the database. Database – Enter the name of the database where you store the Surround SCM mainlines. Chart Title - The default chart title is Check-ins by Branch and Month. You have the option of changing the title to something else. Chart Width - The default width of the chart is set to 800 pixels. You have the option of changing the width to a different value. Chart Height - The default height of the chart is set to 350 pixels. You have the option of changing the width to a different value.
Figure 2 - SCMWebPart Connection Settings