CrossTabs - problem/feature with aggregations (multiple totals) [message #915645] |
Mon, 17 September 2012 13:22  |
Eclipse User |
|
|
|
Greetings all,
I hope to explain this as clearly as possible. I will try to work up a design file using the default db. But has anyone seen this behavor before?
Thanks in advance!
Mike W
Platform: Win7, Oracle DB, Eclipse 3.7.2, Birt(version that comes with Eclipse)
Problem: A report with a crosstab that has row aggregation sub-total, final totals as well as column totals (columns only). For xcell output if there are not equal number of columns per page(say preview) the xcell report will begin to drop right most columns.
I will try to work up a design file using the default db. But has anyone seen this behavor beofore?
Results seen:1.) I have a sql query which returns part, Yr-Month, qty and doing a cross tab which Looks like this below but in preview. Exporting to xcell with results in Option BB begin to drop Total columns and I will see different column merging results between Option AA and BB.
Option: AA
Part......1201__1202___1203__1204__1205__1206__1207__1208__1209__1210___2012___Total
Part-AA......1_____1______1_____1_____1_____1_____1_____1_____1_____1_____11______11
Part-AA......1_____1______1_____1_____1____________________________________5_______5
Total........2_____2______2_____2_____2_____1_____1_____1_____1_____1_____16______16
Option: BB
Part......1201__1202___1203__1204__1205____2012___Total
Part-BA......1_____1______1_____1_____1_______5_______5
Part-BB......1_____1______1_____1_____1____ __5_______5
Total........2_____2______2_____2_____2______10______10
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04255 seconds