Eclipse Community Forums: BIRT » Report Parameter for multiple values

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

Report Parameter for multiple values [message #1774089]

Tue, 10 October 2017 08:23

Eclipse User

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

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

Tue, 10 October 2017 12:17

Eclipse User

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"]+"'"

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 [=-

Current Time: Wed Jul 16 11:28:54 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter