| Complex group by per page [message #261959] |
Thu, 22 November 2007 10:47  |
Eclipse User |
|
|
|
Hi,
I've tried to create a sub group per page, at footer's page, grouping
data per field and adding it, but without success. Because it is a little
hard to explain it, I've drawn the idea:
page1
campo1 | campo2 | campo3
-------------------------
1 3 a
2 4 b
8 7 a
4 5 c
9 6 c
-----------------------
page 1
subtotals
campo3 campo1 | campo2 (summary (add) field X group by
campo3)
------------------
a 9 10
b 2 4
c 13 11
------------------------------------------------------------ -------------------
page2
campo1 | campo2 | campo3
-------------------------
3 4 c
5 2 b
7 6 a
9 8 c
1 1 c
-----------------------
page 2
subtotals
campo3 campo1 | campo2 (summary (add) field X group by
campo3)
------------------
a 7 6
b 5 2
c 13 13
------------------------------------------------------------ -------------------
final page
totals
campo3 campo1 | campo2 (summary (add) field X group by
campo3)
------------------
a 16 16
b 7 6
c 26 24
--------------------
The main problem is how dynamically to group the page's data by a specific
field and show some aggregations.
Could you show to me how to make this in BIRT, please?
Greetings,
Hans.
|
|
|
| Re: Complex group by per page [message #262309 is a reply to message #261959] |
Thu, 29 November 2007 02:44  |
| Eclipse User |
|
|
|
Hans,
I design a report and attach it.
You can have a look, I put subtotals in group footer and final page totals
in table footer
Thanks.
"Hans" <st.hanxxx@gmail.com> wrote in message
news:936592122c3d2501c0905ddb4ba3fa53$1@www.eclipse.org...
> Hi,
>
> I've tried to create a sub group per page, at footer's page, grouping
> data per field and adding it, but without success. Because it is a little
> hard to explain it, I've drawn the idea:
>
>
> page1
> campo1 | campo2 | campo3
> -------------------------
> 1 3 a
> 2 4 b
> 8 7 a
> 4 5 c
> 9 6 c
> -----------------------
> page 1
> subtotals
>
> campo3 campo1 | campo2 (summary (add) field X group by
> campo3)
> ------------------
> a 9 10
> b 2 4
> c 13 11
>
> ------------------------------------------------------------ -------------------
>
>
> page2
> campo1 | campo2 | campo3
> -------------------------
> 3 4 c
> 5 2 b
> 7 6 a
> 9 8 c
> 1 1 c
> -----------------------
> page 2
> subtotals
>
> campo3 campo1 | campo2 (summary (add) field X group by
> campo3)
> ------------------
> a 7 6
> b 5 2
> c 13 13
>
> ------------------------------------------------------------ -------------------
>
> final page
> totals
>
> campo3 campo1 | campo2 (summary (add) field X group by
> campo3)
> ------------------
> a 16 16
> b 7 6
> c 26 24
>
> --------------------
> The main problem is how dynamically to group the page's data by a specific
> field and show some aggregations.
>
> Could you show to me how to make this in BIRT, please?
>
> Greetings,
> Hans.
>
|
|
|
| Re: Complex group by per page [message #262345 is a reply to message #262309] |
Thu, 29 November 2007 08:47 |
| Eclipse User |
|
|
|
I do not have sufficient words to express my gratefulness.. Liwen, thank
you too much for your time and willingness
lchen escribió:
> Hans,
>
> I design a report and attach it.
>
> You can have a look, I put subtotals in group footer and final page totals
> in table footer
>
> Thanks.
>
> "Hans" <st.hanxxx@gmail.com> wrote in message
> news:936592122c3d2501c0905ddb4ba3fa53$1@www.eclipse.org...
>> Hi,
>>
>> I've tried to create a sub group per page, at footer's page, grouping
>> data per field and adding it, but without success. Because it is a little
>> hard to explain it, I've drawn the idea:
>>
>>
>> page1
>> campo1 | campo2 | campo3
>> -------------------------
>> 1 3 a
>> 2 4 b
>> 8 7 a
>> 4 5 c
>> 9 6 c
>> -----------------------
>> page 1
>> subtotals
>>
>> campo3 campo1 | campo2 (summary (add) field X group by
>> campo3)
>> ------------------
>> a 9 10
>> b 2 4
>> c 13 11
>>
>> ------------------------------------------------------------ -------------------
>>
>>
>> page2
>> campo1 | campo2 | campo3
>> -------------------------
>> 3 4 c
>> 5 2 b
>> 7 6 a
>> 9 8 c
>> 1 1 c
>> -----------------------
>> page 2
>> subtotals
>>
>> campo3 campo1 | campo2 (summary (add) field X group by
>> campo3)
>> ------------------
>> a 7 6
>> b 5 2
>> c 13 13
>>
>> ------------------------------------------------------------ -------------------
>>
>> final page
>> totals
>>
>> campo3 campo1 | campo2 (summary (add) field X group by
>> campo3)
>> ------------------
>> a 16 16
>> b 7 6
>> c 26 24
>>
>> --------------------
>> The main problem is how dynamically to group the page's data by a specific
>> field and show some aggregations.
>>
>> Could you show to me how to make this in BIRT, please?
>>
>> Greetings,
>> Hans.
>>
>
>
|
|
|
Powered by
FUDForum. Page generated in 1.20669 seconds
Home