jpclerc

Gaby38 Wrote: In fact you cannot write : where tab.col = '$P{LoggedInUser}.getFullName()' You have to define another parameter $P{FullName} initialized through its default value to $P{LoggedInUser}.getFullName()' and use it in where clause Merci beaucoup ....

Pour complèter ma demande .... soory ... to add somthong for my topic LoggedInUser.getFullName() is the fullname but what is the "shotname", the login only for exemple JP / Monsieur Jean-Paul LoggedInUser.getFullName() = "Monsieur Jean-Paul" How can I do to retrieve only "JP"

Hello, Thank you for your help Matt :-) I have open in ireport 3.7.6 "/reports/samples/SalesByMonth" I have found the use of "LoggedInUser" (Parameter class : com.jaspersoft.jasperserver.api.metadata.user.domain.User) But I have the error : Java.land.ClassNotFoundException : com.jaspersoft.jasperserver.api.metadata.user.domain.User I have fetch the use of ths parameter in the query but I guess that the syntax should be select ... from .. where tab.col = '$P{LoggedInUser}.getFullName()' So I do and I have ther error : 1. Parameter type not supported in query : LoggedInUser class com.jaspersoft.jasperserver.api.metadata.user.domain.User Thank you for your help

Hello, sory for my poor english .... when I add <import value="com.jaspersoft.jasperserver.api.metadata.user.domain.User"/> <parameter name="LoggedInUser" class="com.jaspersoft.jasperserver.api.metadata.user.domain.User" isForPrompting="false"/> I have the error " The selected Jrxml could not be parsed." when i load the JRXML using the Report Wizardof fasperserver 3.7.1 Is it possible to have a simple way to use "LoggedInUser" in que query ? I do not undersand enough "http://jasperforge.org/plugins/mwiki/index.php/Jasperserver/Cascading_input_controls#Detailed_specification" Please help, tell me the way to do this easily ( "copy/paste")

Post Edited by jpclerc at 01/13/2011 02:10

Hello, sory for my poor english .... when I add <import value="com.jaspersoft.jasperserver.api.metadata.user.domain.User"/> <parameter name="LoggedInUser" class="com.jaspersoft.jasperserver.api.metadata.user.domain.User" isForPrompting="false"/> I have the error " The selected Jrxml could not be parsed." when i load the JRXML using the Report Wizardof fasperserver 3.7.1 Is it possible to have a simple way to use "LoggedInUser" in que query ? I do not undersand enough "http://jasperforge.org/plugins/mwiki/index.php/Jasperserver/Cascading_input_controls#Detailed_specification" Please help, tell me the way to do this easily ( "copy/paste")

I need the same thing I use Jasper-CE 3.7.1 I have read http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=15545 But nothing change when I do some thing ! Jean-Paul PS : sorry for my english !

Hello ! sorry for my poor english ... it's OK in ireport for the parameter isOnJS ! it's OK with the defalt value in ireport ! But what must I do to have isOnJs=True when I am in jasperServer ?