nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Default Parameter using Javascript created using expression builder

JagThripp

Hello Everyone,
 
Newbie here trying to create an Eclipse report that prompts for values from user at run time, there are two *required* parameters and one *optional* parameter. For the required parameters I have tried to set a default value at run time, my problem is that I am not able to get the values to show in the parameter field when I try to preview the report.
 
The parameter I have is *BirtDateTime.year(BirtDateTime.Now()) + BirtDateTime.month(BirtDateTime.Now())*
This is creating a value that is a combination of year and month (Financial Period) YYMM so the user can run the report for the current period or adjust them accordingly.
 
As far as I am aware (assumption) the expression is valid as there is no error when I use the validation option in the expression builder.
 
The two parameters I have created are called FinStart and FinEnd both use their own version of the expression pasted above as the default value. Due to this missing information the values are not being populated at run time causing the report to fail.
 
var where = params["where"]; 
if (params["FinStart"].value) 
 where = " R.FINANCIALPERIOD BETWEEN " + params["FinStart"].value; 
if (params["FinEnd"].value) 
 where = where + " AND " + params["FinEnd"].value; 
if (params["vendor"].value) 
 where = where + where + " AND " + params["vendor"].value;
 
This is the (clumsy) attempt at getting values into the parameters then into the query.
 
Thanks.

Find more posts tagged with

Comments

jfranken

For the default values, the functions you called return integers. Your code is adding them together, not concatenating. Unless there is a specific reason why you can't include the day, I recommend using the following expression for the default:
 
BirtDateTime.firstDayOfMonth(BirtDateTime.today())
 
This way you are using a date rather than converting to a string. If you want to convert to a string, then I believe the code is:
Formatter.format(BirtDateTime.today(), "YYMM")
(I haven't had a chance to test this.)
 
Your code to manipulate the query is incorrect, but you shouldn't need that code. The start and end date values are required. All you need to do is replace the vendor value with a wildcard if the value is not a valid value. There is no need to manipulate the structure of the query.

JagThripp

Hello Jeff,
 
Thanks for the insight on this. We have a field that is type Varchar(6) that has the FINANCIALPERIOD stored in it. 
I was trying to display the latest FP to the user in the parameter entery dialog box. (as you no doubt already guessed)
 
So that I am on the same page as you.
Were I have *BirtDateTime.year(BirtDateTime.Now()) + BirtDateTime.month(BirtDateTime.Now())* entered,
I simply replace the old javascript with your Formatter.format(BirtDateTime.today(), "YYMM") script?
 
And thanks again for your assistance.
 
Jag

jfranken

Hi Jag,
 
I tested the expression:
 
Formatter.format(BirtDateTime.today(), "YYMM")
 
It displays the two digit year concatenated with the two digit month in the parameter box. Be sure the JavaScript expression type is selected (see attached screenshot s1.png).
 
Regards,
Jeff

JagThripp

Cool we are on the same page, thanks Jeff.