Released the 1.1 Version of ActionDataBase WebParts. Solve some problems when the webparts are used with Navision DataBase.

Listening to our customers SPSRollUp could aggregate data in a calendar view. We are working on it.

First images of ActionView and ActionViewChart webparts.

With the ActionView web part you can get data from your SQL Server Data Base and render the data using XSLT.

Preliminary XML documentation in ActionView XML Configuration
XSLT and other properties are the same that in SPSRollUp and SPSRollUpChart

ActionViewChart web part permits show the data using graphs.

Both web parts are in a new package called ActionPack, that would be released at the end of June.

An ActionGrid connected to an ActionViewChart to show in graph form all products and your quantity ordered by a customer

ActionViewChart XML Configuration

<?xml version="1.0" encoding="utf-16"?>
<SPSActionViewConfig>
  <DataBase ConnectionString=" ... " />
  <Query SelectCommand="SELECT SUM([Order Details].Quantity) AS Quantity, 
                               Products.ProductName
                        FROM   [Order Details] 
                        INNER JOIN Orders 
                              ON [Order Details].OrderID = Orders.OrderID 
                        INNER JOIN Products 
                              ON [Order Details].ProductID = Products.ProductID
                        WHERE Orders.CustomerID=@CustomerID  
                        GROUP BY Products.ProductName" />
  <Filter>
    <Param Name="CustomerID" Type="NChar" Default="" />
  </Filter>
</SPSActionViewConfig>

ActionViewChart XSLT

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" 
                xmlns:xsl=http://www.w3.org/1999/XSL/Transform 
                xmlns:msxsl="urn:schemas-microsoft-com:xslt" 
                xmlns:sps=http://schemas.spsprofessional.com/WebParts/SPSXSLT 
                exclude-result-prefixes="msxsl sps">
  <xsl:output method="xml" indent="yes" />
  <xsl:template match="@* | node()">
    <!-- Graph -->
    <graph caption="Title" 

           xAxisName="Products" 

           yAxisName="Quantity" 

           decimalPrecision="0" 

           formatNumberScale="0">
      <xsl:apply-templates />
    </graph>
  </xsl:template>
  <!-- Each row -->
  <xsl:template match="Row">
    <!-- Put here your fields -->
    <set name="{ProductName}" value="{Quantity}" color="{sps:GetFcColor()}" />
  </xsl:template>
</xsl:stylesheet>