[How to change database name]

can u please check if there is any file named similar to "jasperserver ...xml" under \apache-tomcat-6.0.16\conf..

Bcaz , in certain cases ..that file is used instead of /META-INF/context.xml for refering to jasperserver.

thanks

Ramnik Kaur

Senior QA Engineer

[XML datasource on Jasper Server]

Link from here ..

http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4190

works perfect for me

Ramnik Kaur

Senior QA Engineer

[Move Reports from local system to client system]

1. This seems to me Bug.

2. However , you can try this ..export the resoources from the organization and then try importing them using this command by specifying the organization Id in the import command

js-import --input-zip 31export.zip --org-id MyOrg --org-label UpgradedOrg

 

Hope this helps ..

 

Ramnik Kaur

Senior QA Engineer

[Cascading No order]

Cascading Input Controls feature in JS pro 3.7 works the same way . You can select the values in first filter and all cascaded filter refreshed with values as selected in first filter ..

Ramnik Kaur

Senior QA Engineer

[Role name in jasper]

you can simply use the parameter -> LoggedInUserRoles [ in built parameter] in query

select * from report_roles where  $X{IN, role_name, LoggedInUserRoles}

there is no need to extarct it to string first ..i.e. no need of using LoggedInUserRoleString ..In Built Parameter = LoggedInUserRoles works perfect ..

thanks

Ramnik Kaur

Senior QA Engineer

[how to hide resources for user in JS 3.7 ..???]

It seems yoy are trying to use :"Read Only" permission to hide the resources . however You should use :- No Acess permission to hide the resources from the users

- No acces + all Filters works fine in 3.7, if user have no access permisison and clicks "Al Types" , he still dont see the resources with No access permissions

 

 

thanks

Ramnik Kaur

Senior QA Engineer

[Want to change the display of the report list...]

- Just right click on root , open the properties and change the display name

- you can change the display name of root to anything you want ..

 

 

Ramnik Kaur

Senior QA Engineer

[Help Needed In Jasper Server - Scheduling]

1. Create any Folder and set the permissions on the folder based on user / role ..this way only users for which you have permissions to Read can access the folder

- that folder wil be visible in the list of folders here

 

Ramnik Kaur

Senior QA Engineer

[JasperServer Crashs/Hangs]

You will be able to make your server work Ok by just setting the memory and permGen settings. These are the settings we normally use while testing Jasperserver internally.

 

 

Ramnik Kaur

Senior QA Engineer

[Help Needed In Jasper Server - Scheduling]

screen shot attached

Ramnik Kaur

Senior QA Engineer

[Help Needed In Jasper Server - Scheduling]

There is option to save the output ..you can specify the output folder and can select it from repository ..

screen shot attached

 

The option is :- *Folder ..and you can select the folder in repository. If you choose public folder , it can be shared among users.

Ramnik Kaur

Senior QA Engineer

[JasperServer Crashs/Hangs]

1. Yes .changes in setenv.sh will be helpful

2. To be on safer side ..you can increase the limit for permSize to ..you can make them :- 256m and 512m  ..

 

Ramnik Kaur

Senior QA Engineer

[JasperServer Crashs/Hangs]

The issue is Out Of Memory

1. You can increase the memory to high -> e.g. 1024m Or 2048m

2. The jasperpint obejct not found error occurs when it is looking for some running report object and it cannot find it bcaz server is already got java.heap space error

So, basic issue is :- low memory settings ..making it 2048m or even 1024 m will make your server work ok.

 

 

Ramnik Kaur

Senior QA Engineer

[Get scheduling information when exporting a report]

1. Yes , export utility Export scheduling Information ..i.e. all the scheduled jobs for the reports

2. Try something like this:

js-export --report-jobs /organizations/organization_1/reports/samples/AllAccounts --
output-dir myExport

 

 

Ramnik Kaur

Senior QA Engineer

[Download JRXML file from Jasper Server]

As far as i know , we cannot run just the JRXML for domain report]  directlly from the iReport . Even , i tried myself and i got error . It is not supported way. However, abt embedding the JRXML in ur application ..i may not be right person to answer ..

Ramnik Kaur

Senior QA Engineer

[Download JRXML file from Jasper Server]

Since this is adhoc report , you should try to run it as report unit and not only the JRXML. Because there will be other resources refrenced by this report . and basically , since this is domain report , i think prefrered way is to run it  as repot unit and not just as JRXML

 

- you can run this report unit by right clicking in Jasperserver Plugin and click run report unit

 

Ramnik Kaur

Senior QA Engineer

[Download JRXML file from Jasper Server]

1st way :-

Steps:-

- Open iReport designer

- Open the window Jasperserver Plugin

- Eneter the properties of jasperserver [ ur jasperserver and login information ]

- in the jasperserver repository browser , select the report you want to open

- and right click and select -> open in editor

- from here , click save , and you will be able to save the report as JRXML

screen shot attached

2nd way:-

- export the jasperreport unit using the Buildomatic command -> js-ant export -DexportFile = "filename.zip" -DexportArgs="--uris /organizations/organization_1/reports/etcetc"

in the exported report unit , open the resources folder and you can find out the JRXML file for the rpeort .under files folder

Ramnik Kaur

Senior QA Engineer

[Download JRXML file from Jasper Server]

It is not possible to directly download the JRXML file for a rpeort unit. However , if you export the resources , you can get the JRXML file too ..or

You can open the report unit in iReport [ using Jasperserver Plugin ] and save the JRXML file ..

Ramnik Kaur

Senior QA Engineer

[Compilation Error]

iReport 3.7.3 is not supported with Jasperserver 3.7. Please try to use save the report in iReport with comaptibility options  and while saving -> save iwith comapatibility to Jasperreport 3.7.

Steps:-

In iReport , go to tools -> General -> Comapatibility options.

- select the option -> Jasperreports 3.7.0

- save the report

- and choose -> keep this version while saving.

 

Ramnik Kaur

Senior QA Engineer

[Query as resource in custom datasource]

Here are the steps which can help you :-

1. you add query input control to the report

2. You select locally defind query , select the query language and ad the query

3. then you can define the value column and visible column for the query. this is haw u defind the resultset of query which will be used ..

 

Ramnik Kaur

Senior QA Engineer

[Install with MS SQL Server]

For jasperserver Professional , the information abt deployment to different databases is in install Guide. You can use the steps described in Install Guide to install on any supported platform and Database.

 

Ramnik Kaur

Senior QA Engineer

[export option in jasperserver portlet]

In order , different users should access different report , you can assign permissions to report for specific users in Jasperserver repository.

Ramnik Kaur

Senior QA Engineer

[Install with MS SQL Server]

You should be able to use MS SQL srerver as ur DB. Mysql syntax is not embedded in code. It may be , however , samples wont work ok bcaz by default , sample reports are designed to work on Mysql

For Jasperserver-Pro, you can choose the MS SQL server Db while doing deployment itself.

Ramnik Kaur

Senior QA Engineer

[Changing Schema for JasperServer repository]

1.  change in /META-INF/ context.xml file

2. if you have created any data sources using the Jasperserver DB, please change those too to have right port

 

Ramnik Kaur

Senior QA Engineer

[image resource / not found]

In the JRXML ,

- using the report wizard , you can add the resource -> by clicking -> Add Resources and selecting the image. this will ad dthe image resource with proper prefix ..e.g. if the image is saved under -> /oragnization_1/Image , you need to have that prefix in teh JRXML

 

- If you are using report wizard to do it, it will be done automatically , you may not need to edit the JRXML by hand .

Ramnik Kaur

Senior QA Engineer