Eclipse Community Forums: BIRT » How can I execute a SELECT statement in an expression?

Help

Home

Home » Archived » BIRT » How can I execute a SELECT statement in an expression?

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

How can I execute a SELECT statement in an expression? [message #1721822]

Sun, 31 January 2016 14:41

Michael Reiter

Messages: 6
Registered: June 2015

Junior Member

Greetings,

I have followed request:
I have a DB table with three columns:
company_unit, topic, amount

In BIRT, I need a "computed column" with this idea:

if (BirtStr.search("*reserved*",row["topic"],1) > -1)
{
row["amount"] - (SELECT sum([amount])
FROM db.pmo
WHERE company_unit=row["company_unit"]
}
else
{
row["amount"];
}

or in other words:
How can I execute a SELECT statement in an expression?

Thank you!
Michael

Report message to a moderator

Re: How can I execute a SELECT statement in an expression? [message #1722582 is a reply to message #1721822]

Sat, 06 February 2016 05:41

Stefan Seitz

Messages: 14
Registered: February 2015

Junior Member

Are you trying to calculate the following:
SUM amount
Where topic <> "*reserved*"

If so, maybe you could use the aggregation function to do this:
* In the table (or graph, ...) where you use the data, open "Binding" window of the Property Editor.
* Add Aggregation
* Set Function: SUM
* Expression:

if (row["topic"] == "*reversed*")
   0;
else
   row["amount"];

Report message to a moderator

Previous Topic:	Designing more flexible Layout
Next Topic:	Can not load the report query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 10:20:14 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter