| Any suggestions on how to implement this groupby? [message #106427] |
Mon, 09 January 2006 18:11 |
Eclipse User |
|
|
|
I'm trying to render the following report (simplified).
For each month of the year i need to report the budgeted dollars and actual
dollars for a set of departments (eg. A,B,C,...).
The groupby for each month is ok, but is the illustrated "total groupby"
possible?
ie. Total budgeted dollars and actual dollars for each department (eg.
A,B,C) - across the entire year?
Note that the list of departments is a column in the resultset (ie. not a
static list).
Also, i must render the report as is, i can not change the format.
Thank you for your help.
Marko.
..
<pre>
Jan 2006
dep budget actual
A
B
C
total
Feb 2006
dep budget actual
A
B
C
total
.....
Total
dep budget actual
A
B
C
total
</pre>
|
|
|
Powered by
FUDForum. Page generated in 0.06614 seconds
Home