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

Help

Home

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

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

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

Mon, 19 January 2015 17:17

Justin Higley

Messages: 1
Registered: January 2015

Junior Member

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

Report message to a moderator

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

Wed, 21 January 2015 20:35

Jesse Freeman

Messages: 184
Registered: January 2015

Senior Member

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/

Report message to a moderator

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

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 10:18:32 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter