deepthirohini86

November 27, 2009

Hi Sir,

Say i am using one chart , i am giving the width for the chart as 1000 as width size i can display only 50 bars at a time ,

how can i set the width of the chart as dynamic ,

is there is any way , depending upon my query result i need to set the width.

With Regards,

Rohini A.M

November 10, 2009

Code:

Hi Friends,

            My query returns 1000 result at a time, how can i show all the datas in the 

chart in a fixed width,



Kindly help me in this .... How to show all my result in the chart.



Regards,

Rohini A.M

September 12, 2009

Code:

Hi Friends,

          How to do the password encrypted url in jasperserver, which configuration i need to do,

Kindly tell me the steps how i need to achieve.



My Requirement is from my application i need to login into jasper server without login page.

My Application is in php, kindly tell me the solution.



If i pass the username and password it will be got hack. So i any one came across this scenario kindly share it , i am waiting for this



With Regards,

Rohini A.M

September 11, 2009

Hi Friends,
Can any one give my the steps how to write the filter and compiling the filter.

Whether i nee to use maven to compile,

or given me some steps to achieve.

I need to write one filter which will get the encrypt username and password from the url and need to decrypt that and store into the jasperserver username and password.

Kinldy help me how to achieve,

Regards,

Rohini A.M

September 11, 2009

Hi sridevi,

In which programming you are encrypting the username and password. By using which function in java you are decrypting.

Kindly tell me.

August 28, 2009

Hi sir,

I got the solution.Thanks you for your quick response.

August 26, 2009

Hi Friends,

In Bar chart how to display the value expression in integer.

For example i am having score to display in the Y axis.

Say i am having score 5.5 so i put round in query , so i get 5.

But in bar chart it is displaying 5.5 for Value Expression but in the Series Expression it is showing 5.

I dont know why?

It is displaying from 0.0,0.1 upto 0.5

I need to display 0,1,2,3,4,5

How i need to achieve this.

Kindly tell me.

With regards,

Rohini A.M

August 20, 2009

Code:

Hi friends,

            I want to list the users to select the user names in the single select query,

say for example i am have two same name as user but the id will differ.

So internally the input control need to pass the id as the parameter,.



How i need to achieve this.



With Regards,

Rohini A.M

August 10, 2009

Hi sridevi,

Can you share me in deeply about this solution.

I am new to acegi scripts. What steps i need to follow,

Actually now how you are adding the jasper server to your application,by url or by some other things.

What filter i need to write, how i need to achieve without hack , kindly help me.

Regards,

Rohini A.M

August 8, 2009

Code:

Dear Friends,

                I need to login into jasper server without authentication process.

Is there is any way to achieve it.



Regards,

Rohini A.M

July 27, 2009

Hi Swood Sir,

Actually in this forum i upload my problematic jrxml file, whatever steps you given

for getting the LoggedIn user name, i followed . But my problem is if i am using parameter in

the inject query my report is showing "The report is empty" . But if i use the

loggedInUsername in my report without passing the parameter it is showing the LoggedInusername

in report, My question is why the LoggedInUsername is not worked in parameter passing.

Upto date i am not get any solutions,.

I am using community edition.

Kindly suggest me.

Regards,

Rohini A.M

July 25, 2009

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

July 24, 2009

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

July 24, 2009

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

July 24, 2009

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

July 21, 2009

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

July 20, 2009

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

July 20, 2009

Hi Friends,

Actually i am downloaded the jasper server v 3.5.0. For me parameter passing in query is not supported , i already opened one forum with subject : Report is empty refer it for detailed.

Refer:

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=59955

Then i check my logs, i am getting the following error

1. Parameter type not supported in query : LoggedInUser class com.jaspersoft.jasperserver.api.metadata.user.domain.User
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
        at net.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:262)
        at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:144)
        at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:219)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:892)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:1260)

Kindly help me to solve this problem,.

With Regards,

Rohini A.M

Post Edited by rohinijasper at 07/20/2009 11:52

July 20, 2009

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

July 15, 2009

Hi Javed,

For this u can write some trigger for the jiuser table, whenever the new user is added , get that user id and insert the two roles for the jiuserrole table.

Regards,

Rohini A.M

July 15, 2009

Hi,

I am telling the solution for postgresql u can apply this for some other database also.

What jar file you are using in the CLASSPATH, if you are using old version then u need to upgrade,

to postgresql-8.2-506.jdbc3.jar.

Then check whether it is working.

or check the below.

Try this you will get to work correctly,.

Check the url

says example

http://192.168.1.220:5432

Check this url in the browser, if you are getting error for that page , there is no connection like that

then u need to check the database configuration file,

if you are using postgresql,

Then in the file /etc/postgresql/8.1/main/postgresql.conf

change the following line:

listen_address='localhost' to

listen_address='*'.

Then your test will be successful.

Regards,

Rohini A.M

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

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

July 15, 2009

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

July 14, 2009

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

July 14, 2009

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

July 14, 2009

Hi Sridevi,

Sorry for this much delay to reply you , i am new to this forum.

I am also faced the same problem , but i gave some solution.

Do the following :

*) In file jasperserver/WEB-INF/jsp/login_welcome.jsp

you need to comment the front end design for that file and you need to write one function

function setusernamepassword() {
        var queryString=window.top.location.search.substring(1);
        alert(queryString);
        var querystring_split=queryString.split("&");
        var username_details=querystring_split[0].split("=");
        var password_details=querystring_split[1].split("=");

// write the decrypt code for user name and password and set it to the

document.fmLogin.j_username.value=username_details[1];

alert("username:"+username_details[1]);

document.fmLogin.j_password.value=password_details[1];

}

call this function into the validatePassword().

If you do the following changes u can pass the http url itself without showing the login page.

*) Then from your application where you are calling, encrypt the user name and password,

then in the function setusernamepassword() you need to decrypt it.

If you are having any trouble kindly ask me.

########

If you are changing any code in the jsp file then no need to recompile the jasper server.

With Regards,

Rohini A.M

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by deepthirohini86

Products

Explore