Does Izenda Reports support pivot tables?
Yes, we support pivot tables in SQL 2000/SQL 2005 (please call support for Oracle pivot support) 2 different ways.
Method 1
If you are using Izenda Reports 5.6, please see this article: http://izenda.com/Site/KB/Training/Pivot-Function
Method 2
CREATE VIEW [YearPivotExample] AS
SELECT
(CASE DATEPART(yyyy,[OrderDate])
WHEN '2005' THEN Freight ELSE 0 END) AS [2005], (CASE DATEPART(yyyy,[OrderDate])
WHEN '2006' THEN Freight ELSE 0 END) AS [2006], (CASE DATEPART(yyyy,[OrderDate])
WHEN '2007' THEN Freight ELSE 0 END) AS [2007], (CASE DATEPART(yyyy,[OrderDate])
WHEN '2008' THEN Freight ELSE 0 END) AS [2008],
*
FROM [Orders]
If you are using an earlier version of Izenda Reports, then you will need to create views which have this structure:
By doing this, one can create views which are already "pivoted" and then display them in Izenda Reports. Please see this article and views and pivot views - http://izenda.com/Site/KB/Integration/18