hope someone can help me.
I am trying to return a value from a subdataset into the main dataset as mentioned at jaspersoft studio - How to add variable from subdataset to report? [Jasper] - Stack Overflow
I have created a variable (SUB_Varaible) in the subdataset and set the Expression to the relevant Databasefield:
I have then created another variable in the main dataset (Main_Variable):
In a list (or table) I created the return value mapping:
I then drag and drop the Main_Variable onto the report but it is still evaluated as “null”.
How can I fix this?
Attached the .jrxml. I have just used the sample DB for testing with the following SQL statement to have only one value:
select * from Address where Firstname = 'Laura' and Lastname = 'Miller'