Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » How to add report parameter to result set conditionally?
icon5.gif  How to add report parameter to result set conditionally? [message #1573310] Mon, 19 January 2015 17:17 Go to next message
Justin Higley is currently offline Justin HigleyFriend
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
Re: How to add report parameter to result set conditionally? [message #1577290 is a reply to message #1573310] Wed, 21 January 2015 20:35 Go to previous message
Jesse Freeman is currently offline Jesse FreemanFriend
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/
Previous Topic:BIRT Intalling a Plugin Fails
Next Topic:getting exception while opening a BIRT design file in BIRT "java.lang.NullPointerException"
Goto Forum:
  


Current Time: Thu Jul 18 03:33:51 GMT 2024

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

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

Back to the top