Eclipse Community Forums: BIRT » change date parameter value from script

Home » Archived » BIRT » change date parameter value from script

change date parameter value from script [message #1075293]

Mon, 29 July 2013 03:34

Eclipse User

Hi ,

I using MSSQL and have 2 dateset in the report
the first dataset1 is without only return a record of a field (systemdate) of a table, while the second dataset2 contain a query with 2 parameter (date_start and date_end).

when user enter the parameter 1 and 2 , what i must do is , if parameter 1 less than dataset1( systemdate) then set parameter 1 = dataset1(systemdate).

I try put script on dataset1 ->fetch event , but keep encounter problem with error convert javascript.NativeDate to java.sql.Date type

any help please ?

Re: change date parameter value from script [message #1075666 is a reply to message #1075293]

Mon, 29 July 2013 16:55

Eclipse User

You can modify your query in the beforeOpen script method. So, one thing you could do would be to set the query to "select your_fields from your_tables" then in the beforeOpen, do something like:

this.queryText = this.queryText + " where myDate between '" + formattedStartDateString + "' and '" + formattedEndDateString + "'";

Prior to this script, you could check your parameter values to be sure they are correctly done and format the date string.

Re: change date parameter value from script [message #1075704 is a reply to message #1075666]

Mon, 29 July 2013 18:59

Eclipse User

Hi,

the issue is not the query . I need to change the parameter value cause I displaying the parameter value in the report header (master page)

Re: change date parameter value from script [message #1076010 is a reply to message #1075704]

Tue, 30 July 2013 10:12

Eclipse User

Okay. So, you just need to compare the entered start parameter to the system date returned by the first dataSet? Then based on that, determine which value to show in your masterpage? If so, there are several things you could do, probably. One would be to bind the text box that you're displaying the date in your masterpage with to your systemdate dataSet. You'll have access to the data then and can compare this date and the parameter value to determine which one to show.

Hope this helps.

Previous Topic:	More instance of IImageEventHandler
Next Topic:	birt error while creating XLS report

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Mar 25 03:07:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter