| Pivot Table / Dynamic Columns with Birt 2.2 [message #256728] |
Tue, 02 October 2007 13:43 |
 Anette Engel
Messages: 24
Registered: July 2009 |
Junior Member |
|
|
I am using BIRT 2.2. I want to create a report which gives me some trend
information over the last x number of month (typically the last 12
months). I have a stored procedures which returns me the data from my
database, a row per report month:
ReportMonth OpenedCalls ClosedCalls ActiveCalls
------------------------------------------------------------ ----------
7/2007 311 301 21
8/2007 399 388 11
9/2007 401 396 17
.. .. .. ..
My report will have graph to display the trend information as a line chart
as well as a table where the headers are the report month e.g.
7/2007 8/2007 9/2007 ..
----------------------------------------------------
Opened Calls 311 399 401 ..
Closed Calls 301 388 396 ..
Active Calls 21 11 17 ..
(basically a Pivot table)
BIRT doesnt seem to support a Pivot table. Whats the best way to create
a Pivot table in BIRT?
One way may be to use cross tab. But then I had to transform my originally
data set to something like this:
reportMonth columnName columnValue
-----------------------------------------
7/2007 opendCalls 311
7/2007 closedCalls 301
7/2007 activeCalls 21
.. .. ..
I am not sure how to best achieve this. I do not want to create two stored
procedures: one for retrieving the original data set for the graph and one
for the transformed data set for the Pivot table. Is there a way to do
this transformation on the fly?
Thanks,
Anette
|
|
|
Powered by
FUDForum. Page generated in 0.05301 seconds
] 
Search
Help
Register
Login
Home
