Set up Jaspersoft Studio Professional

Prerequisites to setting up Jaspersoft Studio Professional:

Before using Jaspersoft Studio Professional to create or design reports, you must perform the following tasks:

  1. Create the database connection.
  2. Create the JasperReports Server Repository connection.
  3. Install an SSL certificate on the Jaspersoft Studio Professional application host. 

Perform the above steps for every installation of Jaspersoft Studio Professional.

Creating a User in JasperReports Server

To create a user on your JasperReports Server, set up the connection between Jaspersoft Studio Professional and the JasperReports Server. 

To create a user on the JasperReports Server:

  1. Open a browser and enter the following URL to launch the JasperReports Server in standalone mode.


    When the Jaspersoft login page appears, enter User ID sysadmin and Password agiliance.

  2. Go to Manage > Users, then click Add User.

  3. Enter the user information in the following fields: User name, User ID, Email, Password, and Confirm Password. Click Add User to.

  4. Click Edit and scroll down to view the Roles Available section.

  5. Click the ROLE_POWERUSER role. 

  6. Click >> to move the role into the Role Assigned section, then click Save.

Database Configuration

You must establish communication between Jaspersoft Studio Professional and the RiskVision database if they are not installed on the same host server. 

MySQL database: 

Run the following MySQL command to provide access to the database server. By default, both the user name and password are "agiliance".

> grant all on *.* to 'agiliance'@'<ip_address>' identified by 'agiliance' with grant option;

> grant all on *.* to 'root'@'<ip_address>' identified by 'agiliance' with grant option;

> flush privileges;

Oracle database: 

  1. Install and configure the Oracle Client version, then go to the %ORACLE_HOME%\app\network\admin directory to open the tnsnames.ora file using a text editor.
  2. Locate the database name used by the RiskVision Server and change the host to point the Oracle server. 

To create a database connection and jasperreports server repository connection, see: