Reporting Services and KPI list with WSS - Not MOSS

Hi

I had a customer question few weeks ago how to display a KPI list with WSS solution?

Well, as you know KPI List is an object of MOSS and WSS doesn't have this functionality.

The customer doesn't use Performance Point Server of analysis services so we need a simple solution. How?

The solution is:

• 1. Create a standard List in WSS to host KPI values such as goal , actual value etc.
• 2. Create Reporting Services report which connects to WSS with XML data-source.
• 3. The query asks for List Items values from WSS web services. (Dont Forget to send parameters values to DataSet).
• 4. Manipulate the data and show present it with icons within the Report.

Download the List Template here.

Download the Reporting Services Project here.

ScreenShots of steps:

• 1. Change the XML connection in the project.
• 2. Make sure you have access permissions for the web site.

Enjoy and good luck.