Eclipse Community Forums: BIRT » Passing sub report totals to expressions

Home » Archived » BIRT » Passing sub report totals to expressions

Passing sub report totals to expressions [message #931311]

Wed, 03 October 2012 00:58

Eclipse User

TIA,

BIRT 3.7.2

(fairly new to BIRT - as you will see below)

I have a settlement report I am trying to generate. In it, I have several queries that pull out single field values, which then need to be added/subtracted from other values, or from a sum of values from a subreport table. I know I am missing the obvious, but how do I:

--> Assign the sum of a related (child) table's rows to a variable that can then be accessed in an expression which subtracts/adds it to values from the master table?

For example, I have a created a query which pulls out two preliminary payments (first and third) and then I add them together. This value then needs to have the sum of expenses (I have a child table with an aggregate of the expenses nested in the master table) subtracted from it. I cannot figure out how to access the sum of the nested tables expenses in the expression.

Any and all help greatly appreciated - please point out what I've been missing/don't understand so far.

Re: Passing sub report totals to expressions [message #931829 is a reply to message #931311]

Wed, 03 October 2012 11:09

Eclipse User

There are several ways this can be done. One way is to implement an oncreate script for each of the data items and store the value using reportContext.setGlobalVariable. You can then use this value later. Look at the attached example. I created two datasets. Both are just queries on the orderdetails sample table. In the outer table I added three table footer rows. In the middle footer row I inserted an inner table. Look at the oncreate script for the three data items with red background.

BTW another option is to use both datasets in a cube and then display the results in a crosstab.

Jason

Attachment: nestedtableaggregate.zip
(Size: 3.40KB, Downloaded 401 times)

Re: Passing sub report totals to expressions [message #932072 is a reply to message #931829]

Wed, 03 October 2012 16:14

Eclipse User

Jason,

I unpacked and ran the report. The first total quantity ordered was 142. The second quantity ordered total was 80. The difference between quantitys was 1. When I looked at the expression for the [diff] field, it contained only '1'.

Could you repost or explain why the answer is not '62'?

Also, the finished format for the report is supposed to be in a pdf. Will that limit how I set this up? I've not used an oncreate script...

Thanks,

Jeff

Re: Passing sub report totals to expressions [message #932969 is a reply to message #932072]

Thu, 04 October 2012 12:13

Eclipse User

Sorry Jeff, I should have used a persisted global. Take a look at the revised example. Note that the 1 is a dummy value. I am changing it in an onrender script.

Jason

Attachment: twotableaggregate.zip
(Size: 3.43KB, Downloaded 745 times)

Re: Passing sub report totals to expressions [message #937520 is a reply to message #932969]

Mon, 08 October 2012 23:08

Eclipse User

Jason,

I am on 3.6.2. When I try to open your reportdesign I get the following:

Warning: The report file of version 3.2.23 is not supported (click OK)

Then the report design appears to load, but then, when I click on the Preview tab, I get:

ERROR: The report file of version 3.2.23 is invalid for it is greater than the latest supported one. (Click OK)

Re: Passing sub report totals to expressions [message #938289 is a reply to message #937520]

Tue, 09 October 2012 14:43

Eclipse User

Try this one.

Jason

Attachment: nestedtableaggregate.zip
(Size: 3.44KB, Downloaded 510 times)

Re: Passing sub report totals to expressions [message #1823125 is a reply to message #932969]

Thu, 19 March 2020 15:04

Eclipse User

Thanks Jason
You have saved my life. I have only just started using BIRT.
John Woolliscroft

Previous Topic:	Page Break Issue
Next Topic:	where to find coreapi.jar, modelapi,jar, engineapi.jar

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 10:02:25 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter