Eclipse Community Forums: BIRT » How to add report parameter to result set conditionally?

Home

Home » Archived » BIRT » How to add report parameter to result set conditionally?

How to add report parameter to result set conditionally? [message #1573310]

Mon, 19 January 2015 12:17

Eclipse User

Hello there,

I'm trying to create a report that will use conditional formulas to insert a report parameter into one of three columns in my result set. The solution is for a reminder email we send out the first week of each month. One of the parameters of the report will be the "EmailDate" or the date that the emails get sent (not necessarily the same day as the report is run). The result set should include data from the SQL data set along with 3 columns: "Reminder," "60Day," and "90Day." The report should conditionally enter the parameter value in the appropriate column based on DueDate from the database.

Example: If running the report for January, ActionDate would be 1/5/2015 and if the due date falls during January, then 1/5/2015 should be entered in the Reminder column. If the due date falls in February, then it should be in the 60Day column. March due dates would have the ActionDate in the 90Day column.

These columns are currently set up manually, then the data is loaded into Access as the source for a mail merge to send the appropriate emails.

Thanks for your help!
Justin

Re: How to add report parameter to result set conditionally? [message #1577290 is a reply to message #1573310]

Wed, 21 January 2015 15:35

Eclipse User

Looks like you asked the same question our developer.actuate.com as well.

Posting your answer from developer.actuate.com:

Quote:

Thanks! I ended up bringing the parameter into the report and created a new data binding referencing the param value and using the BirtDateTime.diffMonth() function to determine whether the due date falls during the current, next, or subsequent month.

if(BirtDateTime.diffMonth(params["ActionDate"], dataSetRow["DueDate"]) == 0) {
//for current month, or ...== 1 for next month, or ...== 2 for the month after that
params["ActionDate"]
}
else {
null
}

Link to post on developer.actuate.com: http://developer.actuate.com/community/forum/index.php?/topic/35888-how-to-add-report-parameter-to-result-set-conditionally/

Previous Topic:	BIRT Intalling a Plugin Fails
Next Topic:	getting exception while opening a BIRT design file in BIRT "java.lang.NullPointerException"

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Mar 24 00:51:06 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter