|CrossTabs - problem/feature with aggregations (multiple totals) [message #915645]
||Mon, 17 September 2012 17:22
| michael wirzbicki
Registered: January 2012
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!
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.
Powered by FUDForum
. Page generated in 0.02697 seconds