robertpopa22

Thank you both! It works now. I have misplaced the parameters. Nice work!

:laugh: Sorry lucian, I haven't seen your post! I am new here... Here is the jrxml... Please help! :) By the way, is it possible to send a file/image to the forum? until now I only could post links to my website.

Hello, Does anyone know how to make such a query? The suggestions from lucian do not work. Anyone else has any idea? Thanks

$P{LoggedInUserName}.getFullName() ? Perhaps you reffered to $P{LoggedInUser}.getFullName() ... Yes, $P{LoggedInUser}.getFullName() returns as String the name of the user... Everything ok here, in the text field. Perhaps there are some differences in the query parser?

Thanks, but it doesn't work yet... I have created a 1st parameter $P{LoggedInUser} from class com.jaspersoft.jasperserver.api.metadata.user.domain.User with no default value (also tried prompt and no prompt) Then I created the 2nd parameter $P{LoggedInUserName} of class java.lang.String with the default value of $P{LoggedInUser}.getFullName() (also tried prompt and no prompt) The query was: SELECT details.`Detail` AS details_Detail, users.`name` AS users_name, users.`db` AS users_db FROM `details` details LEFT OUTER JOIN `users` users ON details.`idUser` = users.`idUser` WHERE users.name = $P{LoggedInUserName} *Note! When I used the default value of "Name1", the report printed out ok, so the query is good. In the SQL Query log we have: SELECT details.`Detail` AS details_Detail, users.`name` AS users_name, users.`db` AS users_db FROM `details` details LEFT OUTER JOIN `users` users ON details.`idUser` = users.`idUser` WHERE users.name = NULL Please help us to understand what are we doing wrong ... :)

Here is the parameter declaration: size=323]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/parameter-893f48770c58cfd689473f77cdfb8ff6.JPG http://www.geseidl.ro/images/jasper/parameter.JPG

Hi, We have a lot of users and we need to create only one report! We need to use the LoggedInUser.getUsername() or LoggedInUser.getFullName() to filter out records, so that the user can see his (an only his) data in the report. We have tried to use (from the posts existing here) this query: Code: and we have declared the parameter like this: size=300] size=323]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/parameter-e7b4ffca05cf8643b7c2d7a18ad396b4.JPG When we publish the report on the server we receive this error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 1. Parameter type not supported in query : LoggedInUser class com.jaspersoft.jasperserver.api.metadata.user.domain.User We have studied the SalesByMonths example, but there is a different approach to LoggedInUser. Please help us with an example or tutorial on how to do this in iReports and publish it on the server. Thank You! P.S. If there is another approach to this matter please show us! :woohoo: