Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 12:23 Go to next message
David Whitby is currently offline David WhitbyFriend
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?

Re: Report Parameter for multiple values [message #1774108 is a reply to message #1774089] Tue, 10 October 2017 16:17 Go to previous message
Jerry Sheets is currently offline Jerry SheetsFriend
Messages: 72
Registered: July 2009
Location: Salt Lake City, UT
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:

Current Time: Mon Jul 06 06:23:03 GMT 2020

Powered by FUDForum. Page generated in 0.01998 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top