Pivot Tables

Pivot Tables

While we dont’ have any special handlers for pivot tables, you should be able to 
accomplish the same thing doing a query like this in the report builder: 

SELECT 
SUM(CASE WHEN MONTH(OrderDate) = 1 THEN 1 END) AS ’January’ 
,SUM(CASE WHEN MONTH(OrderDate) = 2 THEN 1 END) AS ’February’ 
,SUM(CASE WHEN MONTH(OrderDate) = 3 THEN 1 END) AS ’March’ 
,SUM(CASE WHEN MONTH(OrderDate) = 4 THEN 1 END) AS ’April’ 
,SUM(CASE WHEN MONTH(OrderDate) = 5 THEN 1 END) AS ’May’ 
,SUM(CASE WHEN MONTH(OrderDate) = 6 THEN 1 END) AS ’June’ 
,SUM(CASE WHEN MONTH(OrderDate) = 7 THEN 1 END) AS ’July’ 
,SUM(CASE WHEN MONTH(OrderDate) = 8 THEN 1 END) AS ’August’ 
,SUM(CASE WHEN MONTH(OrderDate) = 9 THEN 1 END) AS ’September’ 
,SUM(CASE WHEN MONTH(OrderDate) = 10 THEN 1 END) AS ’October’ 
,SUM(CASE WHEN MONTH(OrderDate) = 11 THEN 1 END) AS ’November’ 
,SUM(CASE WHEN MONTH(OrderDate) = 12 THEN 1 END) AS ’December’ 
FROM Sales.SalesOrderHeader 
WHERE YEAR(OrderDate) = 2002 


A stub a function into Report Builder to prompt 
for a field and then slap the sum/case stuff around it. Likewise, you could 
also do this just with a Manual Function. The manual function is great for one 
time use, but if it will be used more than one time, then adding it to the 
StonewareReportFunctions.xml is a nice thing, as it becomes a part of the 
point/click wizard.

    Can't find the KB

    Unable to find the KB to address your issue ?  

      • Recent Articles

      • Lenovo Unified Workspace End-of-Life Questions and Answers

        Will the shutdown of LUW servers and access to downloads affect my server licensing? No, the shutdown of the customer servers and access to the product and licensing downloads will not affect your server licensing. This license is downloaded and ...
      • How do I determine my Unified Workspace license expiration date?

        The best method for determining the licensing information including the expiration date of your Unified Workspace license: Login to your 8090 management console on each server This may take remoting into each LUW server and relay, opening a browser, ...
      • Lenovo Unified Workspace 7.0.2.13 Released

        Highlights of Unified Workspace 7.0.2.13 Before you install: Please view the installation notes here. 7.0.2.13 requires a 7.0 license file. Below is a list of enhancements and fixes released in Unified Workspace 7.0.2.13 Fixed external storage ...
      • LanSchool Documentation Guides

        LanSchool Classic Teacher Console The LanSchool Teacher Console is the interface teachers will use to manage their classroom and students. It contains all the tools necessary for a teacher to effectively interact with students and create a ...
      • Lenovo Unified Workspace 7.0.1.41 Released

        Highlights of Unified Workspace 7.0.1.41 Before you install: Please view the installation notes here. 7.0.1.41 requires a 7.0 license file. Below is a list of enhancements and fixes for Unified Workspace 7.0.1.41 Updated Log4j Updated Java Updated ...
      • Related Articles

      • Running Analytics Migration Wizard

        After applying a Service Pack, not all of the Analytics reports work.  Some show an error: Unable to Run Report The database that contains the information for this report is not currently available. Please try again later.  If you continue to have an ...
      • Move webNetwork to different server

        *** If you are moving to a different OS, please see : https://helpdesk.lenovosoftware.com/portal/kb/articles/migrate-webnetwork-to-windows-linux-22-8-2017 *** Keeping the same OS / version / IP As long as you are keeping the same OS/ version/IP then ...
      • Example of creating a virtual webApplication

        What are the steps to create a webapplication for a web site that is in our data center ?   Common information on creating a webapplication. Example application is called FootPrints and this application lives in customers data center.  x.x.x.x = the ...