Hi
I have a masterdetail grid with two group by expressions to group the data at 2 levels. All works well. However in the footer text of the row, I would like the value of the group by expression to be shown.
So at present it is something like this
| This is my top header |
|
|
|
|
|
|
|
This is my second header |
|
|
|
|
|
|
|
RowData1 |
20 |
30 |
15 |
22 |
|
|
RowData2 |
12 |
11 |
9 |
15 |
|
|
RowData3 |
11 |
52 |
11 |
23 |
|
|
|
43 |
93 |
35 |
60 |
|
|
RowData4 |
156 |
11 |
22 |
347 |
|
|
|
156 |
11 |
22 |
347 |
|
|
|
199 |
104 |
57 |
407 |
What I want is this
| This is my top header |
|
|
|
|
|
|
|
This is my second header |
|
|
|
|
|
|
|
RowData1 |
20 |
30 |
15 |
22 |
|
|
RowData2 |
12 |
11 |
9 |
15 |
|
|
RowData3 |
11 |
52 |
11 |
23 |
|
This is my second header |
|
43 |
93 |
35 |
60 |
|
|
RowData4 |
156 |
11 |
22 |
347 |
|
This is my second header |
|
156 |
11 |
22 |
347 |
| This is my top header |
|
|
199 |
104 |
57 |
407 |
And then when it collapses I would ideally like
| This is my top header |
|
|
|
|
|
|
|
This is my second header |
|
43 |
93 |
35 |
60 |
|
This is my second header2 |
|
156 |
11 |
22 |
347 |
| This is my top header |
|
|
199 |
104 |
57 |
407 |
Help very much appreciated
Thanks