Concatenate two strings in Jaspersoft

[tec_user]

Hi !! I am a newbie to Jaspersoft. I am trying to concatenate two strings(“2016” and “-01-01”) to get a complete string like “2016-01-01”.

I created two parameters of class String. First parameter named as "year" is prompted from the user and the expression is $P{year}, where the user is expected to enter a year(like 2016, 2015,etc). The expression for the second parameter named as start_date is $P{year}+”-01-01”. When I run the program, it says document is empty without any errors. I tried using concatenate function of string without using + . It still failed. In the query, I used to_date function to convert the string to a date. Can anyone help why this is happening? Thanks in advance

[hozawa]

Try executing your report without using any parameter by hard coding the value to see if that'll work. If you still don't get your report, it's a problem with your data.

[tec_user]

I tried hard coding the entire string “2016-01-01” and named it  start_date under parameters, it is executing fine without any issues and generates the report. It is not working only when I try to concatenate something like this, $P{year}+”-01-01”.

[szaharia]

Hi,

If possible, please post your JRXML sample here. 

Thanks,

Sanda

[tec_user]

<?xml version="1.0" encoding="UTF-8"?>

      

[tony.dunlop]

you might have to convert the param to a string first depending on what type your year param is. Like this :

$P{year}.toString()+”-01-01”