Eclipse Community Forums: BIRT » subtotals for multipage tables

Help

Home

Home » Archived » BIRT » subtotals for multipage tables

Show: Today's Messages :: Show Polls :: Message Navigator

subtotals for multipage tables [message #551133]

Thu, 05 August 2010 11:25

xoto

Messages: 7
Registered: August 2010

Junior Member

hi there,

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

Report message to a moderator

Re: subtotals for multipage tables [message #551415 is a reply to message #551133]

Fri, 06 August 2010 11:06

xoto

Messages: 7
Registered: August 2010

Junior Member

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?

Report message to a moderator

Re: subtotals for multipage tables [message #551460 is a reply to message #551415]

Fri, 06 August 2010 14:18

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

You may be able to use page variables for this. Page variables can be
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?
>
>

Report message to a moderator

Re: subtotals for multipage tables [message #551905 is a reply to message #551460]

Tue, 10 August 2010 06:31

xoto

Messages: 7
Registered: August 2010

Junior Member

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

Report message to a moderator

Re: subtotals for multipage tables [message #552029 is a reply to message #551905]

Tue, 10 August 2010 15:04

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

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

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

Report message to a moderator

Re: subtotals for multipage tables [message #552228 is a reply to message #552029]

Wed, 11 August 2010 11:20

xoto

Messages: 7
Registered: August 2010

Junior Member

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 Confused

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.

Report message to a moderator

Re: subtotals for multipage tables [message #552538 is a reply to message #552228]

Thu, 12 August 2010 14:37

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Page variables are only supported currently when using two processes to
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.
>

Report message to a moderator