Geert.Boeve

Thanks for the tip. I used the standard LoggedInUser in JasperStudio with the wrong class com.jaspersoft.jasperserver.api.metadata.user.domain.client.UserImpl.

I need to create JasperReports with user specific attributes to be used on JasperServer. But the parameters $P{LoggedInUser}.getAttributes() and $P{LoggedInUserAttributes} always return null. Do I need to perform some initialization or are these parameters not available on the community version of JasperServer? We use at the moment JasperServer version 6.0.1

I am building an complex report with jasperreports and have to build a very complex SQL query with several joins and subselections. Is there a simple method in jasperreports to set the value of a parameter with the result of a SQL query? I know you can set an user input selection with a query in jasperserver, but in this report I want initial set a parameter with the result of a query (without user input) and use the parameter values in the main query of an table.