[help: error w/ installation on win7 os]

1.Jasperreports is a library to create the jasperreports . you need not worry abt it a s it comes with iReport

2. iReport is the jasperreport designer. It uses the jasperreport library. Using iReport -> user can create the JRXML.

3. After user create the JRXML in iReport , he can port the JRXML using the jasperreport unit in Jasperserver.

 

So , in summary flow is like this:-

1. Using iReport , create the JRXML

2. using the jasperserver, create the jasperreport which use the JRXMl.this way reports are ported to a server and can be accessed anywhere.

 

hope it helps ..

Ramnik Kaur

Senior QA Engineer

[help: error w/ installation on win7 os]

Yes , its easy

1. go to tomcat/webapps/jasperserver-pro/META-INF

- in context.xml file , you will find information abt the mysql URL used. Update the URL , username and password for the DB you want to use

 

2. You can alway add data source to point to the Database you want to use and then create reports, domains based on the data source

 

Ramnik Kaur

Senior QA Engineer

[help: error w/ installation on win7 os]

yes ..you can use that ..as long as that MYSQL server allows connection for ur server ..

Ramnik Kaur

Senior QA Engineer

[help: error w/ installation on win7 os]

This is known issue with installer [ bundled/bundled] when machine is slow. Actually , when machine is slow, it tries to connec to mysql before evenr mysql started.

Workaround is :- Install Existing mysql and try using existing mysql when installing. it will work for sure.

thanks

Ramnik Kaur

Senior QA Engineer

[open source license changed in 3.7]

To confirm  , as part of CE 3.7 , all Jaspersoft owned products are migrated to GPL v3 Affero or LGPL v3.

Ramnik Kaur

Senior QA Engineer

[Top of the report result page Text box problem]

I confirmed that top of page - text box works ok in general case . can u please add specific use case and ur report detail to understand whats the issue..

 

thanks

Ramnik Kaur

Senior QA Engineer

[In-memory analysis with jasper]

In memory analysis is implmented as part of data explorer project which is Pro only ..hope it helps

Ramnik Kaur

Senior QA Engineer

[Flashcharts 3.7 and Acrobat]

Fusion charts do not working in version 8. In Version - 9 , it works perfect as tested internally ..

hope it helps ..

Ramnik Kaur

Senior QA Engineer

[Unable to connect to Jasper server from iReport]

i confirmed with latesy release .3.7.1 ..it works perfectly for me ..

 

 

Ramnik Kaur

Senior QA Engineer

[Query filtered by LoggedInUser.getUsername()]

If this is abt cascading input control ..it is available as feature in JR Pro 3.7. , JS CE 3.7 and JS Pro 3.7.1 [ with many bug fixes ]

Ramnik Kaur

Senior QA Engineer

[Migrate JS from Standalone to Glassfish]

1. Yes , it is possible

2. You can deploy the war file using the war file in Glassfish instruction as in Install Guide.

3. You need not to export anything from the tomcat side.

however, it is always recommended to take backup and mysqldump .

thanks

Ramnik Kaur

Senior QA Engineer

[Jasper Server XP Install against existing MySQL]

Actually , the reason it is not prompting for user name and password is that It is not able to find running MYSQL Server Instance at given binary directory and port

After , it detects for running mysql server at 127.0.0.1:3306 , it prompts for username and password

but since, first steps fails , it gives error ..and never get to step 2 asking for username and password

 

Ramnik Kaur

Senior QA Engineer

[Jasper Server XP Install against existing MySQL]

In case you are inetrsted , There is another option to Install ..

 

War file deployment -> Instruction are in install guide . in that case , uyou have more control over the password , user name and what u use as existing mysql ..

Senior QA Engineer

[Jasper Server XP Install against existing MySQL]

i notice this in log:-

"

C:\Program
Files\jasperserver-ce-3.7.0/mysql\bin\mysqladmin.exe: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost'
(using password: YES)'

"
 

it is still going to jasperserver-ce-3.7.0 mysql and not ur existing mysql ...

 

 

Ramnik Kaur

Senior QA Engineer

[How to start iReports in Linux.]

- Command you used to tun iReport is right..

- which version of iReport are u using ?

Ramnik Kaur

Senior QA Engineer

[input control in an ad hoc report]

Jasperserver - adhoc report has been tested to have 400-500 columns. so ..number of columns does not seem to me issue ..:)

i think , you can report the bug on support. this is sth which needs to be fixed ..bcaz both number of rows and columns should not be issue in running the report ..

[ in general , adhoc editor worked really well with 400-500 columns and over million rows ..]

Ramnik Kaur

Senior QA Engineer

[Problems with parameter form]

Selection lost is bug and is fixed in latest version of JS CE 3.7.1 which will be available soon. You can always build latest version of JS CE 3.7.1

Also, You can build 3.7.1 youself if you use the branches/js-for-pro-3.7.x branch (the name is a little funny but it does the job).

Ramnik Kaur

Senior QA Engineer

[Jasper Server XP Install against existing MySQL]

Its kinda weird. its really works for me. i confirmed it again just now
 

question ..- when u choose the binary directory did u try chosing using the browse button available?so that path automatically gets in the path text box ..

 

thanks

Ramnik Kaur

Senior QA Engineer

[Jasper Server XP Install against existing MySQL]

Another thing , can u please check that 127.0.0.1:3306 is accessible in MySQL Workbench, bcaz 127.0.0.1 as IP adress is used in URL to connect to Mysql

 

 

thanks

Ramnik Kaur

Senior QA Engineer

[Jasper Server XP Install against existing MySQL]

Specifically , issue seems to me here with the Binary Directory u specified . please make sure that path is right

Ramnik Kaur

Senior QA Engineer

[Jasper Server XP Install against existing MySQL]

you can check 3 things:-

1. Mysql not running on port specified

2. please check that right binary directory has been specified for existing mysql.

4. check if username and password are right.

hope this helps . this should surely work. if above things are right..

Ramnik Kaur

Senior QA Engineer

[input control in an ad hoc report]

you are welcome:)

here are my suggestions ..

1. There number of rows = 50000 is for sure not the issue. bcaz jaspersever has been performance tested for scalability over 5-6 million rows internally. Dynamic Filter - worked really well internally

2. You can always get help from support and log a bug..

3. i will try to replicate it to see if any settings help ..

thanks,

Ramnik Kaur

Senior QA Engineer

[Jasperserver hangs after clicking on report unit]

can u please add more details regd the report unit , what type of input control u are using ..which version of jasperserver [ seems like 3.7 ] ..that will really help in debugging the issue

thanks

Ramnik Kaur

Senior QA Engineer

[Jasper not starting up.]

Try this command :-

 

./jasperctl.sh start

 

it should work like a charm ..as this has been tested really well internally

thanks

Ramnik Kaur

Senior QA Engineer

[import reports into JS]

Its easy ..

There are two ways :-

1. you take the JRXML , create the jasperreport unit in Jasperserver - using report unit wizard in Jasperserver

2. in iReport ,

- open the Jasperserver Plugin [ enter the properties of the jasperserver in the jasperserver plugin- URL , login ]

- add new report unit

- enter name and select the current JRXML

- select the data source

- save the report unit

- go to Jasperserver -> Report Unit is available in Jasperserver for use ..

 

Hope it helps , let me know if any questions  ..

Ramnik Kaur

Senior QA Engineer