Eclipse Community Forums: BIRT » Report Parameter for multiple values

Home » Eclipse Projects » BIRT » Report Parameter for multiple values(Add a parameter which would include Active and New)

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

Report Parameter for multiple values [message #1774089]

Tue, 10 October 2017 12:23

David Whitby

Messages: 5
Registered: October 2017

Junior Member

Trying to find a way to filter orders that are still outstanding.
The field can be either NEW, ACTIVE, CANCELLED or COMPLETE
I want to be able to report on JUST ACTIVE AND NEW.

WHats the best way of doing this?

Thanks

Report message to a moderator

Re: Report Parameter for multiple values [message #1774108 is a reply to message #1774089]

Tue, 10 October 2017 16:17

Jerry Sheets

Messages: 68
Registered: July 2009
Location: Salt Lake City, UT

Member

I'm not sure if it's the best way, but the way I handle it is by using a script in the beforeOpen method of the data set to modify the SQL
// Append Where Clause for Project Status
if (params["rprmStatus"].value == "ACTIVE"){
this.queryText = this.queryText + " AND ROOT.AE_CP_PRJ_E.STATUS IN('NEW','ACTIVE'"
}else {
this.queryText = this.queryText + " AND ROOT.AE_CP_PRJ_E.STATUS = '" + params["rprmStatus"]+"'"

Report message to a moderator

Previous Topic:	Group Total of a Expression Column
Next Topic:	BIRT 4.6.3 Blank Excel sheets when group header page break is set

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 21 06:23:52 GMT 2018

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter