riodavid

Can you show us your query to retrieve the latest value? Besides, it is probably because of the time zone setting of Jasper server and DB server are different.

Hi Avernekar, Can you show us the query of the second report?

I'm sorry I created the question the 2nd time. I accidentally clicked "Marked as answer" so the previously question got closed. So I opened this new thread: Hi Folks, I have a Jasper report on server, it has an Multi-Select Checkbox input control, which would be like: [] Dog [] Cat [] Fish I want Dog and Cat selected by default like this: [v] Dog [v] Cat [] Fish I know this can be done in Jaspersoft Studio, by setting its "Default Value Expression" to hard coded values: java.util.Arrays.asList( "Dog", "Cat" ) But is it possible to set the default values dynamically? For example, from a query? SELECT ANIMAL FROM ZOO WHERE TYPE = 'LAND' Thank you very much. Dawei -------------------------------------- In the previous thread Mariano answered: "Only if you make a scriptlet that returns a List after making the query. " Thank you Mariano for pointing the direction, if you see this thread can you share an example of the scriptlet?

Hi Folks, I have a Jasper report on server, it has an Multi-Select Checkbox input control, which would be like: [] Dog [] Cat [] Fish I want Dog and Cat selected by default like this: [v] Dog [v] Cat [] Fish I know this can be done in Jaspersoft Studio, by setting its "Default Value Expression" to hard coded values: java.util.Arrays.asList( "Dog", "Cat" ) But is it possible to set the default values dynamically? For example, from a query? SELECT ANIMAL FROM ZOO WHERE TYPE = 'LAND' Thank you very much. Dawei