Planet Jaspersoft

Hi ,

This is an introductory article on automating the Jaspersoft reports server user activities. In this tutorial, you would learn how to effectively implement cucumber framework with java selenium for Jaspersoft server.

NOTE : 
1) Assuming, the reader should already have basic knowledge on all the software's or technologies mentioned below.

Software's used: 
1) Eclipse - Version: 2.3.0.v20191210-0610, Build id: I20191210-0610
2) Java 1.8
3) Maven build tool (default comes with Eclipse)
4) Cucumber 1.2.5
5) Cucumber Junit 1.2.5
6) Junit 4.12
7) Log4j 1.2.17
8) Google Chrome Browser : Version 80.0.3987.132 (Official Build) (64-bit)
9) Jaspersoft 7.5 Community Server

Automation flow architecture: 

Click on the image to view in non-scroll mode or to view the whole flow:




Note that you may have to download and point to correct chromedriver.exe driver. This demonstration is used chrome driver 80 versioned driver.

To get a copy of this demo, drop me a message at
LinkedIn


Video tutorial : Execution flow of the project
TBD

Steps: 
1) Creating a new Maven project

       File -> New -> Project -> Maven -> Maven Project
         (Jaspersoft Automation is the project  name)

2) Add log4j library to the project build path.
     

4)  The final project folder structure is as follows.

5) pom.xml

This will download and install the required libraries for the project. 

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>SMAPI_UI_POC</groupId>
  <artifactId>SMAPI_UI_POC</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <name>SMAPI_UI_POC</name>
  <description>SMAPI_UI_POC</description>
  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>
  <dependencies>

  <!--  cucumber-java -->
<!-- https://mvnrepository.com/artifact/info.cukes/cucumber-java -->
<dependency>
    <groupId>info.cukes</groupId>
    <artifactId>cucumber-java</artifactId>
    <version>1.2.5</version>
</dependency>

  <!--  cucumber-junit -->
<!-- https://mvnrepository.com/artifact/info.cukes/cucumber-junit -->

<dependency>
    <groupId>info.cukes</groupId>
    <artifactId>cucumber-junit</artifactId>
    <version>1.2.5</version>
</dependency>
<!--
<dependency>
        <groupId>io.cucumber</groupId>
        <artifactId>cucumber-junit</artifactId>
        <version>3.0.2</version>
        <scope>test</scope>
    </dependency>
-->
<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
</dependency>

<!-- https://mvnrepository.com/artifact/org.seleniumhq.selenium/selenium-java -->
<dependency>
    <groupId>org.seleniumhq.selenium</groupId>
    <artifactId>selenium-java</artifactId>
    <version>3.141.59</version>
</dependency>
  </dependencies>

  <build>
<pluginManagement>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.21.0</version>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.7.0</version>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>

6) configuration.properties

Read values from properties file 

chrome_driver_path=D:\\chromedriver_80\\chromedriver.exe
jaspersoft_server_url=http://localhost:8080/jasperserver
user_id=jasperadmin
password=jasperadmin

7) 001_LoginJaspersoftServer.feature 

Cucumber feature file with valid and invalid login scenarios using Scenario Outline concept.
This code of language is called as Gherkin 

#Author: sadakar.pochampalli
# https://docs.katalon.com/katalon-studio/docs/cucumber-features-file.html#maintain-features-file
# https://riptutorial.com/cucumber/example/28790/scenario-outline
#https://www.tutorialspoint.com/cucumber/cucumber_scenario_outline.htm
@Login
Feature: Login feature

  As a admin user, I want to login to Jaspersoft Server so that
  I can run the reports, dashboards, create ad-hoc reports and etc.

  @ValidLogin
  Scenario Outline: Login with valid credentials
    Given Chrome browser and Jaspersoft login page
    When I enter User Id as "<UserId>" and Password as "<Password>"
    And I click on Login button
    Then I should be able to login successfully

    Examples:
      | UserId      | Password    |
      | jasperadmin | jasperadmin |
      | joeuser     | joeuser     |

  @InvalidLogin
  Scenario Outline: Login with Invalid credentials
    Given Chrome browser and Jaspersoft login page
    When I enter User Id as "<UserId>" and Password as "<Password>"
    And I click on Login button
    Then I should NOT be able to login successfully

    Examples:
      | UserId  | Password    |
      | baduser | jasperadmin |
      | joeuser | badpassword |
      | baduser | badpassword |

Give below advanced property for the column vizz. If navigation is unable to find add/create "user defined" property.

xAxis.labels.style.textOverflow=wrap



This property may require in combination with above ( not tested, if above doesn't work this should be given)


Sample output: 

Master/Parent Report : 
* Call all the sub reports from Master Report.
* It is not required to give any variables in Mater report to get the page numbers (at least in this example)

Sub Report-1 : 
* In Sub Report-1 drag $V{MASTER_CURRENT_PAGE} variable to the band (presuming the page number is kept in Title band in this case)
* In the variable properties, keep Evaluation Time = Master




Sub Report-2: 
  Perform the same steps as in Sub Reprot-1
Sub Report-3: 
Perform the same steps as in Sub Reprot-1
.
.
.
Sub Report-N: 
Perform the same steps as in Sub Reprot-1


Sample outputs from original example in which I did not keep page number variable for first sub report so my report is displaying page numbers starting from 2nd page.



NOTE: If you publish any of the sub report as an individual report, the report always displays page number starting from 1 

In J.Design  Studio: Drag a text field (not static text) and in the properties give Markup=Styled


Expression inside text field :
"<style forecolor='#ffffff' size='14'> Hi,I am red in color..!</style>"

Sample output: 

References: 
https://community.jaspersoft.com/blog/tip-half-colored-text-static-text-field-or-text-field-jasper-reports-or-basic-usage-markup

https://infosys.ars.usda.gov/svn/code/third_party/Jasper_Reports/jasperreports-4.6.0-project/jasperreports-4.6.0/dist/docs/sample.reference/styledtext/index.html

attributes supported by the <style isBold="true">style</style> 
 tag used to format the text content inside a styled text element:
 
 fontName
 <style size="32">size</style>
 <style isBold="true">isBold</style>
 <style isItalic="true">isItalic</style>
 <style isUnderline="true">isUnderline</style>
 <style isStrikeThrough="true">isStrikeThrough</style>
 pdfFontName
 pdfEncoding
 isPdfEmbedded
 <style forecolor="red">forecolor</style>
 <style backcolor="blue" forecolor="white" isBold="true">backcolor</style>