Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community Forumssubtotals for multipage tables
https://www.eclipse.org/forums/index.php/mv/msg/173184/551133/#msg_551133
due to the amount of rows a given table has to be printed on several pages. to improve the lucidity on each page a subtotal of those values that are written on it should be displayed. furthermore the sum of all values of a specific column on previous pages and the current one has to be shown.
Example - Phone Bill listing all outbounding calls
Page 1: Call Number | Duration | Costs
0123456789 | 00:02:31 | 0.57
0246810121 | 00:09:48 | 1.90
.
.
.
7773334441 | 00:00:58 | 0.19
Sum costs on this page 6.13
Sum costs incl. this page 6.13
------------------------------------------------------------ --------
Page 2: Call Number | Duration | Costs
0123456781 | 00:02:31 | 0.57
0246810121 | 00:09:48 | 1.90
.
.
.
7773334441 | 00:00:58 | 0.19
Sum costs on this page 9.32
Sum costs incl. this page 15.45
is there a way to do this?
thanks for your answers]]>xoto2010-08-05T11:25:13-00:00Re: subtotals for multipage tables
https://www.eclipse.org/forums/index.php/mv/msg/173184/551415/#msg_551415
in group footer:
an aggregate that sums up row["costs"] within the group
an aggregate that sums up the aggregate in 1. with RUNNINGSUM
in group header:
a data element that substracts aggregate 1 from aggregate 2
(so additionally the sum of costs on all previous pages is displayed at the top of each page)
the only problem appears if the first page does not only contain the table.
via "use fixed base value for interval" you can arrange it by hand.
is there a more elegant way to do this?
]]>xoto2010-08-06T11:06:37-00:00Re: subtotals for multipage tables
https://www.eclipse.org/forums/index.php/mv/msg/173184/551460/#msg_551460
recalculated per page and put in the head or footer. Take a look at
this example:
http://www.birt-exchange.org/org/devshare/designing-birt-rep orts/1084-page-script-samples/
Its not what you want but should give you an idea of how they work.
Jason
On 8/6/2010 7:06 AM, xoto wrote:
> i made a try by grouping my data on RowNum with interval range 40.
> in group footer:
>
> an aggregate that sums up row["costs"] within the group
> an aggregate that sums up the aggregate in 1. with RUNNINGSUM
>
> in group header:
> a data element that substracts aggregate 1 from aggregate 2
> (so additionally the sum of costs on all previous pages is displayed at
> the top of each page)
>
> the only problem appears if the first page does not only contain the
> table. via "use fixed base value for interval" you can arrange it by hand.
>
> is there a more elegant way to do this?
>
>]]>Jason Weathersby2010-08-06T14:18:33-00:00Re: subtotals for multipage tables
https://www.eclipse.org/forums/index.php/mv/msg/173184/551905/#msg_551905
unfortunately i'm not able to understand what preferences you changed.
neither the birt help nor the internet has given me a clue relating to variables.
you may explain what to do if i want to insert page numbers. surely the concept would be easier for me to understand.
On 8/10/2010 2:31 AM, xoto wrote:
> thanks for your anwser
>
> unfortunately i'm not able to understand what preferences you changed.
> neither the birt help nor the internet has given me a clue relating to
> variables.
>
> you may explain what to do if i want to insert page numbers. surely the
> concept would be easier for me to understand.
>
> thanks for your help]]>Jason Weathersby2010-08-10T15:04:01-00:00Re: subtotals for multipage tables
https://www.eclipse.org/forums/index.php/mv/msg/173184/552228/#msg_552228
Jason Weathersby wrote on Tue, 10 August 2010 11:04
It works well with the BIRT report in web viewer. But strangely if you display it as pdf all variable values are shown one page behind the correct position
Are there possibilities to insert the page total into the table header?
I tried the other way too. It occurs that instead of taking the first row on this page the first one on the next page is added!? This appears here even in your example.
]]>xoto2010-08-11T11:20:54-00:00Re: subtotals for multipage tables
https://www.eclipse.org/forums/index.php/mv/msg/173184/552538/#msg_552538
run BIRT. Ie /frameset in the webviewer and runtask then a rendertask
in the API. Can you open in the viewer then export to pdf?
This may change as there is a bug request to enhance them.
Jason
On 8/11/2010 7:20 AM, xoto wrote:
> Jason Weathersby wrote on Tue, 10 August 2010 11:04
>> Tell me if this example makes more sense:
>> http://www.birt-exchange.org/org/devshare/designing-birt-rep
>> orts/1247-page-totals-using-page-variables/
>>
>> Jason
>
> Yeah this is very helpful.
> Thank you very much!!
>
> It works well with the BIRT report in web viewer. But strangely if you
> display it as pdf all variable values are shown one page behind the
> correct position :?
> Are there possibilities to insert the page total into the table header?
> I tried the other way too. It occurs that instead of taking the first
> row on this page the first one on the next page is added!? This appears
> here even in your example.
>]]>Jason Weathersby2010-08-12T14:37:45-00:00Re: subtotals for multipage tables
https://www.eclipse.org/forums/index.php/mv/msg/173184/552666/#msg_552666
]]>xoto2010-08-13T06:12:51-00:00