Eclipse Community Forums: BIRT » Set Value in Dynamic Text depending on other field values

Home » Archived » BIRT » Set Value in Dynamic Text depending on other field values(Dynamic Text value = difference between two aggregate fields)

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

Set Value in Dynamic Text depending on other field values [message #754723]

Fri, 04 November 2011 02:47

karvesh ghunsam

Messages: 95
Registered: July 2011

Member

Dear All,

I have a table bound to a dataset. I have two numeric columns in the table that I sum up using aggregate fields at the end of the table. The ids of the aggregate fields are for example: fldAgg1 and fldAgg2.

I have a dynamic text below the table. I want to display the difference in values between the two aggregate fields in the dynamic text.

Could anyone please please advise me the most suitable way to carry this out?

Thanking you in advance.. Razz

Karvesh

Report message to a moderator

Re: Set Value in Dynamic Text depending on other field values [message #754872 is a reply to message #754723]

Fri, 04 November 2011 17:17

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

If I'm understanding correctly, you could store both values into persistent global variables and then recall them in your dynamic text box to do your computation. Or, since both are bindings in your table, you could do the computation in your table script, then store the value in a PGV and recall this value in your text box. Hope this helps.

Regards,

Michael
http://www.birt-exchange.org

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Set Value in Dynamic Text depending on other field values [message #754922 is a reply to message #754872]

Sat, 05 November 2011 03:39

karvesh ghunsam

Messages: 95
Registered: July 2011

Member

Dear Michael,

thanks for the tip. I will try the option of computation in the table script. Yet, how can i access the values of fields using their id?
Is there a way to get it by handlers?

Report message to a moderator

Re: Set Value in Dynamic Text depending on other field values [message #755260 is a reply to message #754922]

Mon, 07 November 2011 20:14

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

You do not access them using their id. If you do this in the table
bindings, just create a new binding and put in an expression like:

var diff = row["aggr1"] - row["aggr2"]
reportContext.setGlobalVariable("mydiff", diff);
diff;

then in the dynamic text put in the expression like:

reportContext.getGlobalVariable("mydiff");

Jason

On 11/4/2011 11:39 PM, karvesh wrote:
> Dear Michael,
>
> thanks for the tip. I will try the option of computation in the table
> script. Yet, how can i access the values of fields using their id?
> Is there a way to get it by handlers?

Report message to a moderator

Previous Topic:	Rebranding the RCP Version of the BIRT Report Designer?
Next Topic:	(no subject)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 20:57:28 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter