Report is empty for $P{LoggedInUsername}

Hello Javed,

Thanks for you reply.

             I changed the query to $P!{LoggedInUsername}, now also i am getting that the report is empty,

I am using the jasper server v3.5 version.

 

regards,

Rohini A.M

 

Hello Javed,

           I changed the query with single quotes also , but i am getting only report empty,

can you send me your .jrxml file i will tested it with my jasperserver. Kindly help me.

With Regards,

Rohini A.M

 

 

 

Hello Javed,
         I go through ur jrxml file , whatever i am giving is right compare to your jrxml,
But i am having doubt in the following line,
SELECT
    id, username, tenantId, fullname
FROM
     `jasperserver`.`JIUser` JIUser
WHERE
     username = '$P!{LoggedInUsername}'

Why u are using back tick for `jasperserver`.`JIUser` JIUser

And also in our jasperserver we are having table jiuser not JIUser.

I think that this things i missed out.

 

I just give the query like the following,

 

select id,username,tenantId,fullname from jiuser where username='$P!{LoggedInUsername}'

 

I am getting the same that 'The Report is empty'.

 

What is the version of your jasperserver?

What is your database ? postgres or mysql

 

Thanks in advance.

Regards,

Rohini A.M

 

 

 

Post Edited by rohinijasper at 07/15/2009 05:12

Hi Javed, I am using iReports v 3.5.0 and Jasperserver v3.5, i found in the jasper server log that 1. Parameter type not supported in query : LoggedInUser class com.jaspersoft.jasperserver.api.metadata.user.domain.User Then in the lib directory of jar i extract the jasperserver-api-metadata-impl-3.5.0.jar But i am not getting the class com.jaspersoft.jasperserver.api.metadata.user.domain.User i am getting com.jaspersoft.jasperserver.api.metadata.user.domain.impl.etc so i am not found the class User. Are you having any jar contains User class, because i also using the same version 3.5 ,.... With Regards, Rohini

Hi Javed, I am using community edition, i didn\'t made any changes in the .jar files. Ok i will do the fresh installation, Actually the errors i took from the jasper server log files. jasperserver/WEB-INF/logs/jasperserver.log

Hi Javed, I am still trying, Actually i did the fresh extraction of war file , i am getting the reports empty message only ,still i am trying.......... I dont know where the actual problem is ... Whether u are using commercial edition for jasper server or community edition. Regards rohini

Hi Javed, I checked with teh when no Data Type , i set it to "All Sections No Details", AFter that it is giving only the username, but not the query output. So i placed all the fields in the title itself there it is showing as null. Regards, Rohini A.M

Hi javed, I checked that it is passing the username as \'null\' in postgresql log. It is not passing the value, it is passing null,. See this is my query log SELECT id, username, tenantId, fullname FROM jiuser WHERE username = \'null\' Whether i need to do any changes in the file like applicationContext.xml With Regards, Rohini

Hi Javed,

           Ok i attached the .xml file , with this. I think that the community edition is not supported for the parameter, what is your view on that.

 

I am having another one question,

whether u are using the jasper server repository in the ireport.

Or u are integrating the jasper server with your application .

 

With Regards,

Rohini A.M

 

 

Hi Javed,

 Very much thanks for your response,

I am having one doubt that in jasperserver side ,

For getting the LoggedInUsername we need to add a parameter in the jasperserver web application or only

jrxml file is ok.

 

I am having my environment like this,

 

I download the jasperserver bin directory and extract that war into the tomcat webapps directory,

Then i use the ireport as a separate and create the jrxml file and upload that into the jasperserver web application.

 

 

Whether i need to explicitly add the LoggedInuser as parameter in jasperserver, if it is then how to add this.

Can you tell me how you add the repository in the ireport nb. Kindly tell me.

 

With Regards,

Rohini A.M