Filter by tags:
April 10, 2020
Tip : Cucumber options(classpath, tag, glue, pretty and monochrome) for cucumber.api.cli.Main.main …
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
If we wan to run the cucumber project from command line/prompt using executable jar , we should create main method and inside it have to pass string values of cucumber options.
The options for command line differs from what we give in CucumberRunner.java (cucumber runner class with )
These options for command line are presented with -g, -p, -m and etc.
-g for glue code
-p for pretty
-m for monochrome
and to read the .feature files give "classpath:features".
The below piece of code explains how the cucumber options should be passed to main method.
Basepage.java
CucumberRunner.java
In standalone cucumber runner class options are represented with tags, glue, plugin and etc.
MANIFEST.FM
Adding main method for BasePage.java class and appropriate jar assembly plugin in pom.xml with the fully qualified class name say com.sadakar.selenium.common.BasePage
(in which main method is written), generates the MANIFEST.FM file that can be viewed if extracts the jar
(in which main method is written), generates the MANIFEST.FM file that can be viewed if extracts the jar
The options for command line differs from what we give in CucumberRunner.java (cucumber runner class with )
These options for command line are presented with -g, -p, -m and etc.
-g for glue code
-p for pretty
-m for monochrome
and to read the .feature files give "classpath:features".
The below piece of code explains how the cucumber options should be passed to main method.
Basepage.java
package com.sadakar.selenium.common;
import org.openqa.selenium.WebDriver;
public class BasePage {
public static WebDriver driver;
public static void main(String args[]) throws Throwable{
try {
cucumber.api.cli.Main.main(
new String[]{
"classpath:features",
"-t","@scenario_AccountPage",
"-g", "com.sadakar.cucumber.stepdefinitions/",
"-g","com.sadakar.cucumber.common",
"-p","pretty",
"-p","json:target/cucumber-reports/Cucumber.json",
"-p", "html:target/cucumber-reports",
"-m"
}
);
}
catch(Exception e) {
System.out.println("Main method exception");
}
}
}
CucumberRunner.java
In standalone cucumber runner class options are represented with tags, glue, plugin and etc.
package com.sadakar.cucumber.runner;
import org.junit.runner.RunWith;
import cucumber.api.CucumberOptions;
import cucumber.api.junit.Cucumber;
@RunWith(Cucumber.class)
@CucumberOptions
(
features="classpath:features",
tags="@scenario_AddAccountPage",
glue={"com.sadakar.cucumber.stepdefinitions/","com.sadakar.cucumber.common"},
plugin = { "pretty", "json:target/cucumber-reports/Cucumber.json",
"junit:target/cucumber-reports/Cucumber.xml",
"html:target/cucumber-reports"},
monochrome = true
)
public class CucumberRunner {
}
MANIFEST.FM
Manifest-Version: 1.0
Built-By: Sadakar
Class-Path: cucumber-java-1.2.5.jar cucumber-core-1.2.5.jar cucumber-h
tml-0.2.3.jar cucumber-jvm-deps-1.0.5.jar gherkin-2.12.2.jar cucumber
-junit-1.2.5.jar junit-4.12.jar hamcrest-core-1.3.jar selenium-java-3
.141.59.jar selenium-api-3.141.59.jar selenium-chrome-driver-3.141.59
.jar selenium-edge-driver-3.141.59.jar selenium-firefox-driver-3.141.
59.jar selenium-ie-driver-3.141.59.jar selenium-opera-driver-3.141.59
.jar selenium-remote-driver-3.141.59.jar selenium-safari-driver-3.141
.59.jar selenium-support-3.141.59.jar byte-buddy-1.8.15.jar commons-e
xec-1.3.jar guava-25.0-jre.jar jsr305-1.3.9.jar checker-compat-qual-2
.0.0.jar error_prone_annotations-2.1.3.jar j2objc-annotations-1.1.jar
animal-sniffer-annotations-1.14.jar okhttp-3.11.0.jar okio-1.14.0.ja
r log4j-1.2.17.jar poi-4.1.0.jar commons-codec-1.12.jar commons-colle
ctions4-4.3.jar commons-math3-3.6.1.jar poi-ooxml-4.1.0.jar poi-ooxml
-schemas-4.1.0.jar commons-compress-1.18.jar curvesapi-1.06.jar xmlbe
ans-3.1.0.jar poi-scratchpad-4.1.0.jar
Created-By: Apache Maven 3.6.3
Build-Jdk: 1.8.0_181
Main-Class: com.inovalon.selenium.common.BasePage
maven-assembly-plugin in pox.xml
maven-assembly-plugin in pox.xml
<plugin>
<!-- NOTE: We don't need a groupId specification because the group is
org.apache.maven.plugins ...which is assumed by default.
-->
<artifactId>maven-assembly-plugin</artifactId>
<version>3.1.1</version>
<configuration>
<archive>
<manifest>
<addClasspath>true</addClasspath>
<mainClass>com.sadakar.selenium.common.BasePage</mainClass>
</manifest>
</archive>
<descriptorRefs>
<descriptorRef>jar-with-dependencies</descriptorRef>
</descriptorRefs>
</configuration>
<executions>
<execution>
<id>make-assembly</id>
<phase>package</phase>
<goals>
<goal>single</goal>
</goals>
</execution>
</executions>
</plugin>
Eclipse command to generate the jar from Maven build:
clean compile assembly:single install
Hope this helps someone in the community.
Cheers.!
Sadakar Pochampalli
April 10, 2020
How to read excel test data from the file added in eclipse project folder or from the file bundled …
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Programming is not always easy
ExcelUtils.java
1 | package com.sadakar.excel.utilities; |
1 | package com.sadakar.cucumber.stepdefinitions; |
April 10, 2020
Hi,
In this post
In this post
1 | public static InputStream getResource(String filename) { |
April 10, 2020
April 2, 2020
This is an extended tutorial of my post back in 2015, today, I needed to implement the same and struggled to get the old example working, so, thought of documenting it again with server export available for the community.
https://jasper-bi-suite.blogspot.com/2015/01/tip-intercharts-drill-down-technique-in.html
Tip : Intra charts/components linking technique in Jasper reports : HTML5 charts inter linking with in report in Jasper Studio 6.x
Problem Statement :
How to drill down with in the report ? How to get dynamic data displayed in a table component when performed click action on particular slices from Pie Chart ?
Pie : Number of cars by Occupation
Table : Details of customer by occupation
Solution :
1) Create a parameter say : $P{paramOccupation} for main report and give default value
In this example default value is given as "Manual"
2) Create a data set and create the same parameter and filter the query with this parameter.
3) Design Pie graph and table component.
4) For the Pie graph category create Bucket Property
paramOccupation = $F{paramOccupation}
4) For the pie graph Hyperlink give _report = path of the same report from J.Server.
and add parameter as shown in below image.
i.e.,
(NOTE : Assuming the report is published already to the server)
_report="/Praveen/Drill_with_in_reports"
paramOccupation=Level1.paramOccupation (This is the Bucket property created for category)
5) Make sure the table component "Dateset" is added with Parameter
i.e., In table component properties --> Parameters -->
Add paramOccupation=${paramOccupation}
6) Re publish the report to Jasper Server and hide the paramOccupation parameter
Download the server zip file for live example : Click Me
Import this zip to your jasper server and run "Drill with in report" report from "Praveen" folder
JRXML:
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 7.2.0.final using JasperReports Library version 6.6.0 -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Drill with in reports" pageWidth="1000" pageHeight="842" columnWidth="960" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="4b0b908c-5907-4119-9d85-00671c2494af">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
<property name="ireport.jasperserver.user" value="superuser"/>
<property name="ireport.jasperserver.reportUnit" value="/Praveen/Drill_with_in_reports"/>
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
<property name="ireport.jasperserver.report.resource" value="/Praveen/Drill_with_in_reports_files/main_jrxml"/>
<style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Table_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<subDataset name="Dataset1-table" uuid="24749c25-55a5-49c2-be2d-f5dc1ec06acb">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<parameter name="paramOccupation" class="java.lang.String"/>
<queryString>
<![CDATA[select * from customer where occupation= $P{paramOccupation} limit 10]]>
</queryString>
<field name="customer_id" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="customer_id"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="account_num" class="java.lang.Long">
<property name="com.jaspersoft.studio.field.label" value="account_num"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="lname" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="lname"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="fname" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="fname"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="mi" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="mi"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address1" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address1"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address2" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address2"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address3" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address3"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address4" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address4"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="city" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="city"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="state_province" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="state_province"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="postal_code" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="postal_code"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="country" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="country"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="customer_region_id" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="customer_region_id"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="phone1" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="phone1"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="phone2" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="phone2"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="birthdate" class="java.sql.Date">
<property name="com.jaspersoft.studio.field.label" value="birthdate"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="marital_status" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="marital_status"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="yearly_income" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="yearly_income"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="gender" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="gender"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="total_children" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="total_children"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="num_children_at_home" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="num_children_at_home"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="education" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="education"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="date_accnt_opened" class="java.sql.Date">
<property name="com.jaspersoft.studio.field.label" value="date_accnt_opened"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="member_card" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="member_card"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="occupation" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="occupation"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="houseowner" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="houseowner"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="num_cars_owned" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="num_cars_owned"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="fullname" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="fullname"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
</subDataset>
<parameter name="paramOccupation" class="java.lang.String">
<defaultValueExpression><![CDATA["Manual"]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select occupation, sum(num_cars_owned) cars from customer
group by occupation
order by occupation]]>
</queryString>
<field name="occupation" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="occupation"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="cars" class="java.lang.Long">
<property name="com.jaspersoft.studio.field.label" value="cars"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<summary>
<band height="420" splitType="Stretch">
<componentElement>
<reportElement x="0" y="80" width="400" height="340" uuid="07f8444d-5b85-4950-aefc-4e4b3f62c16c"/>
<hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Pie">
<hc:chartSetting name="default">
<hc:chartProperty name="title.text" value=""/>
<hc:chartProperty name="credits.enabled" value="false"/>
<hc:chartProperty name="credits.href" value=""/>
<hc:chartProperty name="credits.text" value=""/>
<hc:chartProperty name="yAxis.title.text" value=""/>
<hc:chartProperty name="chart.zoomType" value="xy"/>
<hc:chartProperty name="plotOptions.pie.showInLegend" value="true"/>
</hc:chartSetting>
<multiAxisData>
<multiAxisDataset/>
<dataAxis axis="Rows">
<axisLevel name="Level1">
<labelExpression><![CDATA["Level Label expression"]]></labelExpression>
<axisLevelBucket class="java.lang.Comparable">
<bucketExpression><![CDATA[$F{occupation}]]></bucketExpression>
<labelExpression><![CDATA[]]></labelExpression>
<bucketProperty name="paramOccupation"><![CDATA[$F{occupation}]]></bucketProperty>
</axisLevelBucket>
</axisLevel>
</dataAxis>
<dataAxis axis="Columns"/>
<multiAxisMeasure name="Measure1" class="java.lang.Number" calculation="Nothing">
<labelExpression><![CDATA["Cars"]]></labelExpression>
<valueExpression><![CDATA[$F{cars}]]></valueExpression>
</multiAxisMeasure>
</multiAxisData>
<hc:series name="Measure1">
<hc:contributor name="SeriesItemHyperlink">
<hc:contributorProperty name="hyperlinkTarget" valueType="Constant" value="Self"/>
<hc:contributorProperty name="hyperlinkType" valueType="Constant" value="ReportExecution"/>
<hc:contributorProperty name="_report" valueType="Expression">
<hc:valueExpression><![CDATA["/Praveen/Drill_with_in_reports"]]></hc:valueExpression>
</hc:contributorProperty>
<hc:contributorProperty name="paramOccupation" valueType="Bucket" value="Level1.paramOccupation"/>
</hc:contributor>
</hc:series>
</hc:chart>
</componentElement>
<componentElement>
<reportElement x="420" y="60" width="540" height="60" uuid="100a6fe4-7159-4de7-a8af-ec3abb357d30">
<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
</reportElement>
<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
<datasetRun subDataset="Dataset1-table" uuid="10d6d999-3da9-4530-b062-fe2fc3cd4330">
<datasetParameter name="paramOccupation">
<datasetParameterExpression><![CDATA[$P{paramOccupation}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:column width="110" uuid="6eabdd56-6307-4a16-b24d-0bd7f9d8af20">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="110" height="30" uuid="8a77e308-071d-4305-b50d-0a4c2469db0c"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[account_num]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="110" height="30" uuid="894b8b9c-47e8-4943-9ce9-1d5d9da3895d"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{account_num}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="130" uuid="bd701c03-37dd-4ac7-9d88-bbd6ad9e6ef3">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="130" height="30" uuid="e0a9941b-2b4e-473c-98bf-c1dc4039b841"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[occupation]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="130" height="30" uuid="8d464964-5455-4479-9ff3-30badb9dbc13"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{occupation}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="140" uuid="ec42ddc4-b560-400f-ae5c-2661a02e2607">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="140" height="30" uuid="81af8ec1-0046-4c1e-87dd-fdc7693678b9"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[country]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="140" height="30" uuid="bb5ab017-42ca-49cd-847a-94c55853cc52"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{country}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="160" uuid="313a65a4-3caa-494e-a6fb-502eb5030755">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="160" height="30" uuid="ceb0dd75-ca3f-4351-a343-93e4d33515f0"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[total_children]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="160" height="30" uuid="ef9155f3-1e33-405f-9b7f-861d02b5fd95"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{total_children}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
</jr:table>
</componentElement>
<textField>
<reportElement x="30" y="20" width="130" height="30" uuid="859c4814-f726-45ab-b928-07af80779061"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="10" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$P{paramOccupation}]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>
https://jasper-bi-suite.blogspot.com/2015/01/tip-intercharts-drill-down-technique-in.html
Tip : Intra charts/components linking technique in Jasper reports : HTML5 charts inter linking with in report in Jasper Studio 6.x
Problem Statement :
How to drill down with in the report ? How to get dynamic data displayed in a table component when performed click action on particular slices from Pie Chart ?
Pie : Number of cars by Occupation
Table : Details of customer by occupation
Solution :
1) Create a parameter say : $P{paramOccupation} for main report and give default value
In this example default value is given as "Manual"
2) Create a data set and create the same parameter and filter the query with this parameter.
3) Design Pie graph and table component.
4) For the Pie graph category create Bucket Property
paramOccupation = $F{paramOccupation}
4) For the pie graph Hyperlink give _report = path of the same report from J.Server.
and add parameter as shown in below image.
i.e.,
(NOTE : Assuming the report is published already to the server)
_report="/Praveen/Drill_with_in_reports"
paramOccupation=Level1.paramOccupation (This is the Bucket property created for category)
5) Make sure the table component "Dateset" is added with Parameter
i.e., In table component properties --> Parameters -->
Add paramOccupation=${paramOccupation}
6) Re publish the report to Jasper Server and hide the paramOccupation parameter
Download the server zip file for live example : Click Me
Import this zip to your jasper server and run "Drill with in report" report from "Praveen" folder
JRXML:
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 7.2.0.final using JasperReports Library version 6.6.0 -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Drill with in reports" pageWidth="1000" pageHeight="842" columnWidth="960" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="4b0b908c-5907-4119-9d85-00671c2494af">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
<property name="ireport.jasperserver.user" value="superuser"/>
<property name="ireport.jasperserver.reportUnit" value="/Praveen/Drill_with_in_reports"/>
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
<property name="ireport.jasperserver.report.resource" value="/Praveen/Drill_with_in_reports_files/main_jrxml"/>
<style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Table_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
<topPen lineWidth="0.5" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<subDataset name="Dataset1-table" uuid="24749c25-55a5-49c2-be2d-f5dc1ec06acb">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<parameter name="paramOccupation" class="java.lang.String"/>
<queryString>
<![CDATA[select * from customer where occupation= $P{paramOccupation} limit 10]]>
</queryString>
<field name="customer_id" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="customer_id"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="account_num" class="java.lang.Long">
<property name="com.jaspersoft.studio.field.label" value="account_num"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="lname" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="lname"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="fname" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="fname"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="mi" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="mi"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address1" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address1"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address2" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address2"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address3" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address3"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="address4" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="address4"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="city" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="city"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="state_province" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="state_province"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="postal_code" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="postal_code"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="country" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="country"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="customer_region_id" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="customer_region_id"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="phone1" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="phone1"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="phone2" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="phone2"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="birthdate" class="java.sql.Date">
<property name="com.jaspersoft.studio.field.label" value="birthdate"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="marital_status" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="marital_status"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="yearly_income" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="yearly_income"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="gender" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="gender"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="total_children" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="total_children"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="num_children_at_home" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="num_children_at_home"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="education" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="education"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="date_accnt_opened" class="java.sql.Date">
<property name="com.jaspersoft.studio.field.label" value="date_accnt_opened"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="member_card" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="member_card"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="occupation" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="occupation"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="houseowner" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="houseowner"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="num_cars_owned" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="num_cars_owned"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="fullname" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="fullname"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
</subDataset>
<parameter name="paramOccupation" class="java.lang.String">
<defaultValueExpression><![CDATA["Manual"]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select occupation, sum(num_cars_owned) cars from customer
group by occupation
order by occupation]]>
</queryString>
<field name="occupation" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="occupation"/>
<property name="com.jaspersoft.studio.field.tree.path" value="customer"/>
</field>
<field name="cars" class="java.lang.Long">
<property name="com.jaspersoft.studio.field.label" value="cars"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<summary>
<band height="420" splitType="Stretch">
<componentElement>
<reportElement x="0" y="80" width="400" height="340" uuid="07f8444d-5b85-4950-aefc-4e4b3f62c16c"/>
<hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Pie">
<hc:chartSetting name="default">
<hc:chartProperty name="title.text" value=""/>
<hc:chartProperty name="credits.enabled" value="false"/>
<hc:chartProperty name="credits.href" value=""/>
<hc:chartProperty name="credits.text" value=""/>
<hc:chartProperty name="yAxis.title.text" value=""/>
<hc:chartProperty name="chart.zoomType" value="xy"/>
<hc:chartProperty name="plotOptions.pie.showInLegend" value="true"/>
</hc:chartSetting>
<multiAxisData>
<multiAxisDataset/>
<dataAxis axis="Rows">
<axisLevel name="Level1">
<labelExpression><![CDATA["Level Label expression"]]></labelExpression>
<axisLevelBucket class="java.lang.Comparable">
<bucketExpression><![CDATA[$F{occupation}]]></bucketExpression>
<labelExpression><![CDATA[]]></labelExpression>
<bucketProperty name="paramOccupation"><![CDATA[$F{occupation}]]></bucketProperty>
</axisLevelBucket>
</axisLevel>
</dataAxis>
<dataAxis axis="Columns"/>
<multiAxisMeasure name="Measure1" class="java.lang.Number" calculation="Nothing">
<labelExpression><![CDATA["Cars"]]></labelExpression>
<valueExpression><![CDATA[$F{cars}]]></valueExpression>
</multiAxisMeasure>
</multiAxisData>
<hc:series name="Measure1">
<hc:contributor name="SeriesItemHyperlink">
<hc:contributorProperty name="hyperlinkTarget" valueType="Constant" value="Self"/>
<hc:contributorProperty name="hyperlinkType" valueType="Constant" value="ReportExecution"/>
<hc:contributorProperty name="_report" valueType="Expression">
<hc:valueExpression><![CDATA["/Praveen/Drill_with_in_reports"]]></hc:valueExpression>
</hc:contributorProperty>
<hc:contributorProperty name="paramOccupation" valueType="Bucket" value="Level1.paramOccupation"/>
</hc:contributor>
</hc:series>
</hc:chart>
</componentElement>
<componentElement>
<reportElement x="420" y="60" width="540" height="60" uuid="100a6fe4-7159-4de7-a8af-ec3abb357d30">
<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
</reportElement>
<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
<datasetRun subDataset="Dataset1-table" uuid="10d6d999-3da9-4530-b062-fe2fc3cd4330">
<datasetParameter name="paramOccupation">
<datasetParameterExpression><![CDATA[$P{paramOccupation}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:column width="110" uuid="6eabdd56-6307-4a16-b24d-0bd7f9d8af20">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="110" height="30" uuid="8a77e308-071d-4305-b50d-0a4c2469db0c"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[account_num]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="110" height="30" uuid="894b8b9c-47e8-4943-9ce9-1d5d9da3895d"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{account_num}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="130" uuid="bd701c03-37dd-4ac7-9d88-bbd6ad9e6ef3">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="130" height="30" uuid="e0a9941b-2b4e-473c-98bf-c1dc4039b841"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[occupation]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="130" height="30" uuid="8d464964-5455-4479-9ff3-30badb9dbc13"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{occupation}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="140" uuid="ec42ddc4-b560-400f-ae5c-2661a02e2607">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="140" height="30" uuid="81af8ec1-0046-4c1e-87dd-fdc7693678b9"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[country]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="140" height="30" uuid="bb5ab017-42ca-49cd-847a-94c55853cc52"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{country}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="160" uuid="313a65a4-3caa-494e-a6fb-502eb5030755">
<jr:columnHeader style="Table_CH" height="30">
<staticText>
<reportElement x="0" y="0" width="160" height="30" uuid="ceb0dd75-ca3f-4351-a343-93e4d33515f0"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[total_children]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="Table_TD" height="30">
<textField>
<reportElement x="0" y="0" width="160" height="30" uuid="ef9155f3-1e33-405f-9b7f-861d02b5fd95"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{total_children}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
</jr:table>
</componentElement>
<textField>
<reportElement x="30" y="20" width="130" height="30" uuid="859c4814-f726-45ab-b928-07af80779061"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="10" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$P{paramOccupation}]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>
April 2, 2020
March 31, 2020
Tip : Set relative path for selenium chrome web driver
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
In this post, you will see java snippet inputs for calling chromedriver.exe file eclipse project relative path.
1) Create folder "drivers" for the project.
2) Upload the chromedriver.exe file as shown in below image. (chromedriver_80 another folder created under drivers folder)
3) Right click on the "chromedriver.exe" and make note of the path
for example : /Jaspersoft Automation/drivers/chromedriver_80/chromedriver.exe
4) Define a key-value pair for the driver path in configuration.properties file
chrome_driver_path=\\drivers\\chromedriver_80\\chromedriver.exe
5) While setting System property for driver, give the relative path
System.setProperty("webdriver.chrome.driver",path+chromeDriverPath);
Run the project using Junit and observe that the driver instantiated from the relative path provided.
Detailed code snippets follows....
configuration.properties
# Give this relative path of the driver uploaded for "drivers" folder in eclipse project.
chrome_driver_path=\\drivers\\chromedriver_80\\chromedriver.exe
Code snippet in CommonFunctions.java file i.e., instantiating the chrome driver
public void initDriver() {
String chromeDriverPath=PropertyManager.getInstance().getChormeDriverPath();
String path = System.getProperty("user.dir");
System.out.println(path);
System.setProperty("webdriver.chrome.driver",path+chromeDriverPath);
}
getChromeDriverPath() is the method defined in PropertyManager.java
public class PropertyManager {
private static PropertyManager instance;
private static final Object lock = new Object();
//private static String propertyFilePath=System.getProperty("user.dir") + "\\configuration.properties";
private static String app_mangt_url;
private static String auth_uname_pwd_autoit_path;
private static String chrome_driver_path;
private static String browser_type;
private static String ie_driver_path;
private static String auth_uname_pwd_autoit_path_ie;
//Create a Singleton instance. We need only one instance of Property Manager.
public static PropertyManager getInstance () {
if (instance == null) {
synchronized (lock) {
instance = new PropertyManager();
instance.loadData();
}
}
return instance;
}
//Get all configuration data and assign to related fields.
private void loadData() {
//Declare a properties object
Properties prop = new Properties();
//Read configuration.properties file
try {
//prop.load(new FileInputStream(propertyFilePath));
prop.load(this.getClass().getClassLoader().getResourceAsStream("configuration.properties"));
} catch (IOException e) {
System.out.println("Configuration properties file cannot be found");
}
//Get properties from configuration.properties
app_mangt_url = prop.getProperty("app_mangt_url");
auth_uname_pwd_autoit_path=prop.getProperty("auth_uname_pwd_autoit_path");
chrome_driver_path=prop.getProperty("chrome_driver_path");
browser_type=prop.getProperty("browser_type");
ie_driver_path=prop.getProperty("ie_driver_path");
auth_uname_pwd_autoit_path_ie=prop.getProperty("auth_uname_pwd_autoit_path_ie");
}
public String getAppMangtURL () {
return app_mangt_url;
}
public String getAuthUnamePwdAutoIT () {
return auth_uname_pwd_autoit_path;
}
public String getChormeDriverPath () {
return chrome_driver_path;
}
public String getbrowserType () {
return browser_type;
}
public String getIEDriverPath () {
return ie_driver_path;
}
public String getAuthUnamePwdAutoITIE () {
return auth_uname_pwd_autoit_path_ie;
}
}
Hope this helps you.
Cheers.!
1) Create folder "drivers" for the project.
2) Upload the chromedriver.exe file as shown in below image. (chromedriver_80 another folder created under drivers folder)
3) Right click on the "chromedriver.exe" and make note of the path
for example : /Jaspersoft Automation/drivers/chromedriver_80/chromedriver.exe
4) Define a key-value pair for the driver path in configuration.properties file
chrome_driver_path=\\drivers\\chromedriver_80\\chromedriver.exe
5) While setting System property for driver, give the relative path
System.setProperty("webdriver.chrome.driver",path+chromeDriverPath);
Run the project using Junit and observe that the driver instantiated from the relative path provided.
Detailed code snippets follows....
configuration.properties
# Give this relative path of the driver uploaded for "drivers" folder in eclipse project.
chrome_driver_path=\\drivers\\chromedriver_80\\chromedriver.exe
Code snippet in CommonFunctions.java file i.e., instantiating the chrome driver
public void initDriver() {
String chromeDriverPath=PropertyManager.getInstance().getChormeDriverPath();
String path = System.getProperty("user.dir");
System.out.println(path);
System.setProperty("webdriver.chrome.driver",path+chromeDriverPath);
}
getChromeDriverPath() is the method defined in PropertyManager.java
public class PropertyManager {
private static PropertyManager instance;
private static final Object lock = new Object();
//private static String propertyFilePath=System.getProperty("user.dir") + "\\configuration.properties";
private static String app_mangt_url;
private static String auth_uname_pwd_autoit_path;
private static String chrome_driver_path;
private static String browser_type;
private static String ie_driver_path;
private static String auth_uname_pwd_autoit_path_ie;
//Create a Singleton instance. We need only one instance of Property Manager.
public static PropertyManager getInstance () {
if (instance == null) {
synchronized (lock) {
instance = new PropertyManager();
instance.loadData();
}
}
return instance;
}
//Get all configuration data and assign to related fields.
private void loadData() {
//Declare a properties object
Properties prop = new Properties();
//Read configuration.properties file
try {
//prop.load(new FileInputStream(propertyFilePath));
prop.load(this.getClass().getClassLoader().getResourceAsStream("configuration.properties"));
} catch (IOException e) {
System.out.println("Configuration properties file cannot be found");
}
//Get properties from configuration.properties
app_mangt_url = prop.getProperty("app_mangt_url");
auth_uname_pwd_autoit_path=prop.getProperty("auth_uname_pwd_autoit_path");
chrome_driver_path=prop.getProperty("chrome_driver_path");
browser_type=prop.getProperty("browser_type");
ie_driver_path=prop.getProperty("ie_driver_path");
auth_uname_pwd_autoit_path_ie=prop.getProperty("auth_uname_pwd_autoit_path_ie");
}
public String getAppMangtURL () {
return app_mangt_url;
}
public String getAuthUnamePwdAutoIT () {
return auth_uname_pwd_autoit_path;
}
public String getChormeDriverPath () {
return chrome_driver_path;
}
public String getbrowserType () {
return browser_type;
}
public String getIEDriverPath () {
return ie_driver_path;
}
public String getAuthUnamePwdAutoITIE () {
return auth_uname_pwd_autoit_path_ie;
}
}
Hope this helps you.
Cheers.!
March 31, 2020
March 30, 2020
Automating JasperReports Server Login Page using java-selenium-cucumber | Video tutorial on how to …
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Hi,
In this post, I'd like to share my experience on automating jaspersoft login page using valid (not invalid) credentials using cucumber frame work.
The core of this post is how to generate jar file to run the cucumber project/features from command prompt. You can watch the below video tutorial for the whole project flow, coding inputs, etc. and I hope this will be helpful for someone in the community.
Watch this ~15 min video tutorial for the cucumber execution flow and for some coding inputs
Below are the steps for core part that is how to generate jar and run cucumber project from jar file.
1) In the pom.xml ensure to provide plugin details for jar and mainClass.
This is used to generate the manifest file where the project execution starts when execute the jar from command prompt.
2) Write a main method and pass the cucumber options as String to the Main class.
3) Run the project as Maven build by providing : clean package shade:shade
4) Note down the path of the generated jar
5) Open command prompt and navigate to the path run this command
java -jar <GeneratedJarFile>
pom.xml plugin snippet for jar:
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-jar-plugin</artifactId>
<version>3.2.0</version>
<configuration>
<archive>
<manifest>
<addClasspath>true</addClasspath>
<mainClass>com.sadakar.selenium.common.BasePage</mainClass>
</manifest>
</archive>
</configuration>
</plugin>
calling main method with cucumber options as input
package com.sadakar.selenium.common;
import org.openqa.selenium.WebDriver;
public class BasePage {
public static WebDriver driver;
public static void main(String args[]) throws Throwable{
try {
cucumber.api.cli.Main.main(
new String[]{
"classpath:features",
"-t","@ValidLogin",
"-g", "com.sadakar.cucumber.stepdefinitions/",
"-g","com.sadakar.cucumber.common",
"-p","pretty",
"-p","json:target/cucumber-reports/Cucumber.json",
"-p", "html:target/cucumber-reports",
}
);
}
catch(Exception e) {
System.out.println("Main method exception");
}
}
}
In this post, I'd like to share my experience on automating jaspersoft login page using valid (not invalid) credentials using cucumber frame work.
The core of this post is how to generate jar file to run the cucumber project/features from command prompt. You can watch the below video tutorial for the whole project flow, coding inputs, etc. and I hope this will be helpful for someone in the community.
Watch this ~15 min video tutorial for the cucumber execution flow and for some coding inputs
Below are the steps for core part that is how to generate jar and run cucumber project from jar file.
1) In the pom.xml ensure to provide plugin details for jar and mainClass.
This is used to generate the manifest file where the project execution starts when execute the jar from command prompt.
2) Write a main method and pass the cucumber options as String to the Main class.
3) Run the project as Maven build by providing : clean package shade:shade
4) Note down the path of the generated jar
5) Open command prompt and navigate to the path run this command
java -jar <GeneratedJarFile>
pom.xml plugin snippet for jar:
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-jar-plugin</artifactId>
<version>3.2.0</version>
<configuration>
<archive>
<manifest>
<addClasspath>true</addClasspath>
<mainClass>com.sadakar.selenium.common.BasePage</mainClass>
</manifest>
</archive>
</configuration>
</plugin>
calling main method with cucumber options as input
package com.sadakar.selenium.common;
import org.openqa.selenium.WebDriver;
public class BasePage {
public static WebDriver driver;
public static void main(String args[]) throws Throwable{
try {
cucumber.api.cli.Main.main(
new String[]{
"classpath:features",
"-t","@ValidLogin",
"-g", "com.sadakar.cucumber.stepdefinitions/",
"-g","com.sadakar.cucumber.common",
"-p","pretty",
"-p","json:target/cucumber-reports/Cucumber.json",
"-p", "html:target/cucumber-reports",
}
);
}
catch(Exception e) {
System.out.println("Main method exception");
}
}
}
Build the jar file : clean package shade:shade
Navigate to the target folder where jar is generated and running it.
C:\Users\sadakar\eclipse-workspace\Jaspersoft Automation\target>java -jar Jaspersoft_Automation-0.0.1-SNAPSHOT.jar
Click on the image to get the best view of the content:
Sample output:
March 30, 2020
March 28, 2020
Drill down from Parent report to Child report in Jaspersoft Studio reports - Pie chart to tabular d…
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Software :
----------------
1) J. Studio 7.2 pro
2) Jasperreports server 7.5 Enterprise
Requirement :
-----------------
Drill down to customer detailed report from customer total number of cars by occupation
i.e., Pie graph to tabular data.
Watch 10 min video tutorial:
Click on image to get best view of content:
SQL query :
--------------
Parent report :
-----------------
select occupation, sum(num_cars_owned) cars from customer
group by occupation
order by occupation
Child report:
-----------------
select * from customer where occupation= $P{paramOccupation}
Steps :
-----------
1. Design Parent report with Pie graph.
2. Design Child report with tabular data having "paramOccupation" parameter.
3. Publish Parent report and unit test the output.
4. Publish Child report and unit test the output with various input values for the parameter.
Hyperlinking/Drill down to the Child report from Parent report
----------------------------------------------------------------
1. Edit the Pie vizz. of Parent report.
2. For Categories Levels, create "Bucket Properties" i.e., paramOccupation=$F{occupation}
3. For Measures, click on "Edit Hyperlink" -> check "Use Hyperlink"
4. Click on _report[SeriesItemHyperlink] -> Use Constant value i.e.,_report=/Praveen/Child
5. Clcik on Add to link the parameter
PropertyName=paramOccupation
UseBucketValue=Level1.paramOccupation
Click on image to get best view of content:
Post linking steps:
----------------------
1. Re-publish the Parent report.
2. In the server, edit the child report --> navigate to "Controls and Resources"
3. Change : Display Mode= In Page and un-check "Always prompt"
NOTE:
---------
1. In the Child report JRXML, for the parameter, check the "Is For Prompting" property.
----------------
1) J. Studio 7.2 pro
2) Jasperreports server 7.5 Enterprise
Requirement :
-----------------
Drill down to customer detailed report from customer total number of cars by occupation
i.e., Pie graph to tabular data.
Watch 10 min video tutorial:
Click on image to get best view of content:
SQL query :
--------------
Parent report :
-----------------
select occupation, sum(num_cars_owned) cars from customer
group by occupation
order by occupation
Child report:
-----------------
select * from customer where occupation= $P{paramOccupation}
Steps :
-----------
1. Design Parent report with Pie graph.
2. Design Child report with tabular data having "paramOccupation" parameter.
3. Publish Parent report and unit test the output.
4. Publish Child report and unit test the output with various input values for the parameter.
Hyperlinking/Drill down to the Child report from Parent report
----------------------------------------------------------------
1. Edit the Pie vizz. of Parent report.
2. For Categories Levels, create "Bucket Properties" i.e., paramOccupation=$F{occupation}
3. For Measures, click on "Edit Hyperlink" -> check "Use Hyperlink"
4. Click on _report[SeriesItemHyperlink] -> Use Constant value i.e.,_report=/Praveen/Child
5. Clcik on Add to link the parameter
PropertyName=paramOccupation
UseBucketValue=Level1.paramOccupation
Click on image to get best view of content:
Post linking steps:
----------------------
1. Re-publish the Parent report.
2. In the server, edit the child report --> navigate to "Controls and Resources"
3. Change : Display Mode= In Page and un-check "Always prompt"
NOTE:
---------
1. In the Child report JRXML, for the parameter, check the "Is For Prompting" property.
March 28, 2020
Hi All, Find detailed post about steps to be taken to create a connection to your google drive using Talend. 1. Obtain access token to your google drive account. a. Go to Google API Console b. Create a new project,...
March 28, 2020
March 24, 2020
Handling internet explorer windows based authentication to a website using AutoIT script in java-cu…
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
Hi,
7) When you run your project (in my case its a maven-java-selenium-junit-cucumber) the pop-up should read the username and password from the auto_it.exe file and fill the corresponding values as shown in below image.
NOTE :
In this post, you will see tips on how to authenticate a website that is based on windows authentication.
Reader is assumed to have some prior fundamental knowledge on the java-selenium-cucumber framework/setup.
NOTE:
This post is not written to give step-by-step procedure instead written to give direct inputs on specific areas.
Sample cucumber feature file and scenario:
@feature_login
Feature: Launch internet browser and login with valid credentials
This is a windows based authentication for sadakar.selenium.com site using internet browser.
@senario_loginsadakar.selenium.com
Scenario: Login to sadakar.selenium.com with internet explorer windows based authentication
When I open internet explorer browser
Then I login with username and password and navigate to sadakar.selenium.com
Problem statement :
When you try to open sadakar.selenium.com and if the website is configured for windows based authentication as shown in below image - how do you navigate to the site using java-selenium code ?
Click on the image to get best view of the content:
Solution :
1) Install latest Auto IT tool ( download : https://www.autoitscript.com/site/autoit/downloads/ )
2) Then :
a) Open the website with its security pop-up for windows based authentication
b) Open the AutoIt tool on top of the the website's windows security pop-up.
3) Hold on "Finder Tool" on AutoIT and drag that on to the security pop-up window.
4) Note down "Title" and "Class" in the AutoIt tool.
Click on the image to get best view of the content:
5) Now, in Notepad++ file write below code and save it as "autoit_ie.au3"
$sUsername = "SADA001\administrator"
$sPassword = "SADAPassWord@001"
$sTitle = WinGetTitle("Windows Security")
Sleep(1000)
If $sTitle = "Windows Security" or WinWaitActive("[CLASS:Credential Dialog Xaml Host]") or WinWaitActive("Windows Security") or WinWaitActive("iexplore.exe") or WinWaitActive("Connecting to sadakar.selenium.com")Then
Send($sUsername)
Send("{TAB}")
Send($sPassword,1)
Send("{TAB}")
Send("{ENTER}")
EndIf
6) Right click on the saved file and compile it (just compile) and you would see "autoit_ie.exe" generated in the folder where you saved your au3 file.
NOTE :
if you try open this .exe, you would see some encrypted data that will not be readable.
7) How to call the generated autoit_ie.exe file in java-selenium.
public void getCredentialsFromAutoITExe() {
try {
Log.debug("Reading Username and Password from IE AutoIT exe file");
System.out.println("Reading Username and Password from IE AutoIT exe file");
Runtime.getRuntime().exec("D:\\autoit_ie.exe");
Log.debug("Read Username and Password from AutoIT exe file");
}
}catch(Exception e) {
Assert.fail("failed to Read Username and Password from AutoIT exe file");
System.out.println("failed to read credentials from AutoIT exe file"+" "+e);
}
}
public void getAppManagementURL() {
Log.debug("Authenticating to sadakar.selenium.com URL");
driver.get("http://sadakar.selenium.com/");
Log.debug("Authenticated to Application URL and opened the site
http://sadakar.selenium.com/");
}
7) When you run your project (in my case its a maven-java-selenium-junit-cucumber) the pop-up should read the username and password from the auto_it.exe file and fill the corresponding values as shown in below image.
NOTE :
Runtime.getRuntime().exec("auto it exe file path") should be called before driver.get("URL")
Thank you, for stopping by and I hope it helps someone in the community.
March 24, 2020
March 13, 2020
Jaspersoft reports server valid login and invalid login automation tutorial using Java-Selenium-Cuc…
( JasperSoft BI Suite Tutorials - Sadakar Pochampalli )
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 |
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
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.
3) Ensure installed JRE points to locally installed jdk as shown in below image.
i.e., C:\Program Files\Java\jdk1.8.0_181
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 |
8) log4j.properties
DEBUG, ERROR, INFO logs displayed in file at : D:\\jasper_selenium\\jasper_selenium.logs
# Root logger option
log4j.rootLogger=DEBUG,stdout,dest1,ERROR,INFO
# Direct log messages to a log file
log4j.appender.dest1=org.apache.log4j.RollingFileAppender
log4j.appender.dest1.File=D:\\jasper_selenium\\jasper_selenium.logs
log4j.appender.dest1.MaxFileSize=10MB
log4j.appender.dest1.MaxBackupIndex=10
log4j.appender.dest1.layout=org.apache.log4j.PatternLayout
log4j.appender.dest1.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n
log4j.appender.dest1.Append=false
# Direct log messages to stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n
#ERROR
log4j.appender.ERROR=org.apache.log4j.RollingFileAppender
log4j.appender.ERROR.layout=org.apache.log4j.PatternLayout
log4j.appender.ERROR.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n
#log4j.appender.ERROR.File=D:\\smapiui_logs\\smapi_ui.logs
#INFO
log4j.appender.INFO=org.apache.log4j.RollingFileAppender
log4j.appender.INFO.layout=org.apache.log4j.PatternLayout
log4j.appender.INFO.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n
#log4j.appender.INFO.File=D:\\smapiui_logs\\smapi_ui.logs
9) Hooks.java - This class displays each scenario name with it's status.
package com.sadakar.cucumber.common;
import com.sadakar.resource.utilities.Log;
import cucumber.api.Scenario;
import cucumber.api.java.After;
import cucumber.api.java.Before;
public class Hooks {
@Before(order=0)
public void before(Scenario scenario) {
System.out.println("------------------------------");
Log.info("------------------------------");
Log.info("Scenario: '" + scenario.getName() );
Log.info("******************************");
System.out.println("Starting - " + scenario.getName());
System.out.println("------------------------------");
}
@After(order=0)
public void after(Scenario scenario) {
System.out.println("------------------------------");
Log.info("Scenario: '" + scenario.getName() + "' has status " + scenario.getStatus());
Log.info("******************************");
Log.info("------------------------------");
System.out.println(scenario.getName() + " Status - " + scenario.getStatus());
System.out.println("------------------------------");
}
}
10) CucumberRunner.java
In this class, give path for the features, glue code, which scenarios to test/run and cucumber plugins such as reports in various formats
package com.sadakar.cucumber.runner;
import org.junit.runner.RunWith;
import cucumber.api.CucumberOptions;
import cucumber.api.junit.Cucumber;
@RunWith(Cucumber.class)
@CucumberOptions
(
features="classpath:features",
tags="@ValidLogin,@InvalidLogin",
glue={"com.sadakar.cucumber.stepdefinitions/","com.sadakar.cucumber.common"},
plugin = { "pretty", "json:target/cucumber-reports/Cucumber.json",
"junit:target/cucumber-reports/Cucumber.xml",
"html:target/cucumber-reports"},
monochrome = true
)
public class CucumberRunner {
}
11) LoginToJaspersoft.java
In this class define the step definitions for the scenarios. This code is called glue code. Wherever required, add the wait, sleep statements based on the logon speed of your jaspersoft server.
package com.sadakar.cucumber.stepdefinitions;
import com.sadakar.resource.utilities.Log;
import com.sadakar.selenium.common.BasePage;
import com.sadakar.selenium.common.CommonFunctions;
import cucumber.api.java.en.And;
import cucumber.api.java.en.Given;
import cucumber.api.java.en.Then;
import cucumber.api.java.en.When;
import java.util.concurrent.TimeUnit;
import org.junit.Assert;
import org.openqa.selenium.By;
import org.openqa.selenium.Keys;
public class LoginToJaspersoft extends BasePage{
CommonFunctions cf = new CommonFunctions();
@Given("^Chrome browser and Jaspersoft login page$")
public void chrome_browser_and_Jaspersoft_login_page() throws Throwable {
try {
cf.initDriver();
cf.maximizeDriver();
driver.manage().timeouts().implicitlyWait(15, TimeUnit.SECONDS);
cf.getJapsersoftURL();
driver.manage().timeouts().implicitlyWait(60, TimeUnit.SECONDS);
}
catch(Exception e) {
Log.error("failed to open the Japsersoft URL or Login page"+e);
Assert.fail("failed to open the Japsersoft URL or Login page"+e);
}
}
@When("^I enter User Id as \"([^\"]*)\" and Password as \"([^\"]*)\"$")
public void i_enter_User_Id_as_and_Password_as(String arg1, String arg2) throws Throwable {
Log.debug("Enter User Id");
driver.findElement(By.xpath("//*[@id='j_username']")).sendKeys(arg1+Keys.TAB);
Log.debug("Enter tab");
Log.debug("Enter Password");
driver.findElement(By.xpath("//*[@id='j_password_pseudo']")).sendKeys(arg2+Keys.TAB);
Log.debug("Enter tab");
}
@And("^I click on Login button$")
public void i_click_on_Login_button() throws Throwable {
Log.debug("Click Login button");
driver.findElement(By.xpath("//*[@id='submitButton']")).click();
Thread.sleep(5000);
}
@Then("^I should be able to login successfully$")
public void i_should_be_able_to_login_successfully() throws Throwable {
if(driver.getCurrentUrl().equalsIgnoreCase(
"http://localhost:8080/jasperserver/flow.html?_flowId=searchFlow")){
Log.debug("Login Successfull");
} else {
Log.debug("Login NOT Success full");
Assert.fail("Login NOT Success full");
}
driver.close();
driver.quit();
}
@Then("^I should NOT be able to login successfully$")
public void i_should_NOT_be_able_to_login_successfully() throws Throwable {
if(driver.getCurrentUrl().equalsIgnoreCase(
"http://localhost:8080/jasperserver/login.html?error=1")){
Log.debug("Invalid Login Successfull");
} else {
Log.debug("Invalid Login NOT Success full");
Assert.fail("Invalid Login NOT Success full");
}
driver.close();
driver.quit();
}
}
12) Log.java
package com.sadakar.resource.utilities;
import org.apache.log4j.Logger;
public class Log {
public static Logger log= Logger.getLogger(Log.class.getSimpleName());
//Logger log2 = Logger.getLogger("devpinoyLogger");
/**
* To print Log for the start test case
*
* @param startTestCaseMessage
*/
public static void startTestCase(String startTestScenario ) {
log.info("********************* " + "S_T_A_R_T" + " *********************");
log.info("********************* " + startTestScenario + " *********************");
}
/**
* This is to print Log for the ending of the test case
*
* @param endTestCaseMessage
*/
public static void endTestCase(String endTestScenario) {
log.info("********************* " + "-E---N---D-" + " *********************");
log.info("********************* " + endTestScenario + " *********************");
}
public static void info(String infoMessage) {
log.info(infoMessage);
}
public static void warn(String warnMessage) {
log.warn(warnMessage);
}
public static void error(String errorMessage) {
log.error(errorMessage);
}
public static void fatal(String fatalMessage) {
log.fatal(fatalMessage);
}
public static void debug(String debugMessage) {
log.debug(debugMessage);
}
}
13) PropertyManager.java
package com.sadakar.resource.utilities;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.Properties;
public class PropertyManager {
private static PropertyManager instance;
private static final Object lock = new Object();
private static String propertyFilePath=System.getProperty("user.dir") + "\\configuration.properties";
private static String jaspersoft_server_url;
private static String chrome_driver_path;
private static String user_id;
private static String password;
//Create a Singleton instance. We need only one instance of Property Manager.
public static PropertyManager getInstance () {
if (instance == null) {
synchronized (lock) {
instance = new PropertyManager();
instance.loadData();
}
}
return instance;
}
//Get all configuration data and assign to related fields.
private void loadData() {
//Declare a properties object
Properties prop = new Properties();
//Read configuration.properties file
try {
prop.load(new FileInputStream(propertyFilePath));
//prop.load(this.getClass().getClassLoader().getResourceAsStream("configuration.properties"));
} catch (IOException e) {
System.out.println("Configuration properties file cannot be found");
}
//Get properties from configuration.properties
jaspersoft_server_url = prop.getProperty("jaspersoft_server_url");
chrome_driver_path=prop.getProperty("chrome_driver_path");
user_id=prop.getProperty("user_id");
password=prop.getProperty("password");
}
public String getAppMangtURL () {
return jaspersoft_server_url;
}
public String getChormeDriverPath () {
return chrome_driver_path;
}
public String getUserId () {
return user_id;
}
public String getPassword () {
return password;
}
}
14) Basepage.java
package com.sadakar.selenium.common;
import org.openqa.selenium.WebDriver;
public class BasePage {
public static WebDriver driver;
public static void main(String args[]){
}
}
15) CommonFunctions.java
package com.sadakar.selenium.common;
import org.openqa.selenium.chrome.ChromeDriver;
import org.openqa.selenium.chrome.ChromeOptions;
import com.sadakar.resource.utilities.Log;
import com.sadakar.resource.utilities.PropertyManager;
import org.openqa.selenium.PageLoadStrategy;
public class CommonFunctions extends BasePage{
String chromeDriverPath=PropertyManager.getInstance().getChormeDriverPath();
String appMangtURL = PropertyManager.getInstance().getAppMangtURL();
public void initDriver() {
Log.debug("finding chrome driver path");
System.setProperty("webdriver.chrome.driver",chromeDriverPath);
Log.debug("Chrome driver path found");
Log.debug("Initiate Chrome driver");
ChromeOptions options = new ChromeOptions();
//options.addArguments("--headless");
options.addArguments("--disable-gpu");
options.setPageLoadStrategy(PageLoadStrategy.NONE);
options.addArguments("--allow-insecure-localhost");
options.addArguments("--allow-running-insecure-content");
options.addArguments("--ignore-certificate-errors");
options.addArguments("--no-sandbox");
options.addArguments("--window-size=1280,1000");
options.setCapability("acceptSslCerts", true);
options.setCapability("acceptInsecureCerts", true);
driver = new ChromeDriver(options);
Log.debug("Chrome driver is being initiated");
}
public void maximizeDriver() {
Log.debug("Maximize Chrome Browser");
driver.manage().window().maximize();
Log.debug("Chrome Browser maximized");
}
public void getJapsersoftURL() {
Log.debug("Authenticating to Jaspersoft Reports Server");
//System.out.println("App magt URL="+appMangtURL);
//driver.get("http://management.myabilitynetwork.lab/");
driver.get(appMangtURL);
Log.debug("Enter User ID and Password");
}
public void closeDriver() {
Log.debug("Closing driver: Closing browser");
driver.close();
Log.debug("Driver is closed: Closed browser");
}
public void quitDriver() {
Log.debug("Closing driver session");
driver.quit();
Log.debug("Driver session is closed");
}
}
16) Cucumber reports
17) jasper_selenium.logs
2020-03-13 19:22:57 INFO Log:30 - ------------------------------
2020-03-13 19:22:57 INFO Log:30 - Scenario: 'Login with valid credentials
2020-03-13 19:22:57 INFO Log:30 - ******************************
2020-03-13 19:22:57 DEBUG Log:46 - finding chrome driver path
2020-03-13 19:22:57 DEBUG Log:46 - Chrome driver path found
2020-03-13 19:22:57 DEBUG Log:46 - Initiate Chrome driver
2020-03-13 19:23:07 DEBUG Log:46 - Chrome driver is being initiated
2020-03-13 19:23:07 DEBUG Log:46 - Maximize Chrome Browser
2020-03-13 19:23:07 DEBUG Log:46 - Chrome Browser maximized
2020-03-13 19:23:07 DEBUG Log:46 - Authenticating to Jaspersoft Reports Server
2020-03-13 19:23:07 DEBUG Log:46 - Enter User ID and Password
2020-03-13 19:23:07 DEBUG Log:46 - Enter User Id
2020-03-13 19:23:08 DEBUG Log:46 - Enter tab
2020-03-13 19:23:08 DEBUG Log:46 - Enter Password
2020-03-13 19:23:08 DEBUG Log:46 - Enter tab
2020-03-13 19:23:08 DEBUG Log:46 - Click Login button
2020-03-13 19:23:14 DEBUG Log:46 - Login Successfull
2020-03-13 19:23:15 INFO Log:30 - Scenario: 'Login with valid credentials' has status passed
2020-03-13 19:23:15 INFO Log:30 - ******************************
2020-03-13 19:23:15 INFO Log:30 - ------------------------------
2020-03-13 19:23:15 INFO Log:30 - ------------------------------
2020-03-13 19:23:15 INFO Log:30 - Scenario: 'Login with valid credentials
2020-03-13 19:23:15 INFO Log:30 - ******************************
2020-03-13 19:23:15 DEBUG Log:46 - finding chrome driver path
2020-03-13 19:23:15 DEBUG Log:46 - Chrome driver path found
2020-03-13 19:23:15 DEBUG Log:46 - Initiate Chrome driver
2020-03-13 19:23:24 DEBUG Log:46 - Chrome driver is being initiated
2020-03-13 19:23:24 DEBUG Log:46 - Maximize Chrome Browser
2020-03-13 19:23:24 DEBUG Log:46 - Chrome Browser maximized
2020-03-13 19:23:24 DEBUG Log:46 - Authenticating to Jaspersoft Reports Server
2020-03-13 19:23:24 DEBUG Log:46 - Enter User ID and Password
2020-03-13 19:23:24 DEBUG Log:46 - Enter User Id
2020-03-13 19:23:25 DEBUG Log:46 - Enter tab
2020-03-13 19:23:25 DEBUG Log:46 - Enter Password
2020-03-13 19:23:25 DEBUG Log:46 - Enter tab
2020-03-13 19:23:25 DEBUG Log:46 - Click Login button
2020-03-13 19:23:30 DEBUG Log:46 - Login Successfull
2020-03-13 19:23:31 INFO Log:30 - Scenario: 'Login with valid credentials' has status passed
2020-03-13 19:23:31 INFO Log:30 - ******************************
2020-03-13 19:23:31 INFO Log:30 - ------------------------------
2020-03-13 19:23:31 INFO Log:30 - ------------------------------
2020-03-13 19:23:31 INFO Log:30 - Scenario: 'Login with Invalid credentials
2020-03-13 19:23:31 INFO Log:30 - ******************************
2020-03-13 19:23:31 DEBUG Log:46 - finding chrome driver path
2020-03-13 19:23:31 DEBUG Log:46 - Chrome driver path found
2020-03-13 19:23:31 DEBUG Log:46 - Initiate Chrome driver
2020-03-13 19:23:40 DEBUG Log:46 - Chrome driver is being initiated
2020-03-13 19:23:40 DEBUG Log:46 - Maximize Chrome Browser
2020-03-13 19:23:41 DEBUG Log:46 - Chrome Browser maximized
2020-03-13 19:23:41 DEBUG Log:46 - Authenticating to Jaspersoft Reports Server
2020-03-13 19:23:41 DEBUG Log:46 - Enter User ID and Password
2020-03-13 19:23:41 DEBUG Log:46 - Enter User Id
2020-03-13 19:23:42 DEBUG Log:46 - Enter tab
2020-03-13 19:23:42 DEBUG Log:46 - Enter Password
2020-03-13 19:23:42 DEBUG Log:46 - Enter tab
2020-03-13 19:23:42 DEBUG Log:46 - Click Login button
2020-03-13 19:23:47 DEBUG Log:46 - Invalid Login Successfull
2020-03-13 19:23:48 INFO Log:30 - Scenario: 'Login with Invalid credentials' has status passed
2020-03-13 19:23:48 INFO Log:30 - ******************************
2020-03-13 19:23:48 INFO Log:30 - ------------------------------
2020-03-13 19:23:48 INFO Log:30 - ------------------------------
2020-03-13 19:23:48 INFO Log:30 - Scenario: 'Login with Invalid credentials
2020-03-13 19:23:48 INFO Log:30 - ******************************
2020-03-13 19:23:48 DEBUG Log:46 - finding chrome driver path
2020-03-13 19:23:48 DEBUG Log:46 - Chrome driver path found
2020-03-13 19:23:48 DEBUG Log:46 - Initiate Chrome driver
2020-03-13 19:23:57 DEBUG Log:46 - Chrome driver is being initiated
2020-03-13 19:23:57 DEBUG Log:46 - Maximize Chrome Browser
2020-03-13 19:23:57 DEBUG Log:46 - Chrome Browser maximized
2020-03-13 19:23:57 DEBUG Log:46 - Authenticating to Jaspersoft Reports Server
2020-03-13 19:23:57 DEBUG Log:46 - Enter User ID and Password
2020-03-13 19:23:57 DEBUG Log:46 - Enter User Id
2020-03-13 19:23:58 DEBUG Log:46 - Enter tab
2020-03-13 19:23:58 DEBUG Log:46 - Enter Password
2020-03-13 19:23:58 DEBUG Log:46 - Enter tab
2020-03-13 19:23:58 DEBUG Log:46 - Click Login button
2020-03-13 19:24:03 DEBUG Log:46 - Invalid Login Successfull
2020-03-13 19:24:04 INFO Log:30 - Scenario: 'Login with Invalid credentials' has status passed
2020-03-13 19:24:04 INFO Log:30 - ******************************
2020-03-13 19:24:04 INFO Log:30 - ------------------------------
2020-03-13 19:24:04 INFO Log:30 - ------------------------------
2020-03-13 19:24:04 INFO Log:30 - Scenario: 'Login with Invalid credentials
2020-03-13 19:24:04 INFO Log:30 - ******************************
2020-03-13 19:24:04 DEBUG Log:46 - finding chrome driver path
2020-03-13 19:24:04 DEBUG Log:46 - Chrome driver path found
2020-03-13 19:24:04 DEBUG Log:46 - Initiate Chrome driver
2020-03-13 19:24:14 DEBUG Log:46 - Chrome driver is being initiated
2020-03-13 19:24:14 DEBUG Log:46 - Maximize Chrome Browser
2020-03-13 19:24:14 DEBUG Log:46 - Chrome Browser maximized
2020-03-13 19:24:14 DEBUG Log:46 - Authenticating to Jaspersoft Reports Server
2020-03-13 19:24:14 DEBUG Log:46 - Enter User ID and Password
2020-03-13 19:24:14 DEBUG Log:46 - Enter User Id
2020-03-13 19:24:15 DEBUG Log:46 - Enter tab
2020-03-13 19:24:15 DEBUG Log:46 - Enter Password
2020-03-13 19:24:15 DEBUG Log:46 - Enter tab
2020-03-13 19:24:15 DEBUG Log:46 - Click Login button
2020-03-13 19:24:20 DEBUG Log:46 - Invalid Login Successfull
2020-03-13 19:24:21 INFO Log:30 - Scenario: 'Login with Invalid credentials' has status passed
2020-03-13 19:24:21 INFO Log:30 - ******************************
2020-03-13 19:24:21 INFO Log:30 - ------------------------------
March 13, 2020
Pages
About
Planet Jaspersoft aggregates blog posts from our community. If you would like your blog to be included in the Planet, please follow this help guide. Or just click this link to go straight to your Planet Feeds.
Feed Sources
- JasperSoft BI Suite Tutorials - Sadakar Pochampalli (217) Apply JasperSoft BI Suite Tutorials - Sadakar Pochampalli filter
- Jaspersoft Tutorials (50) Apply Jaspersoft Tutorials filter
- Technology Blog (50) Apply Technology Blog filter
- Jaspersoft Tech Talks (47) Apply Jaspersoft Tech Talks filter
- The Open Book on BI (26) Apply The Open Book on BI filter
- Rajesh Sirsikar (22) Apply Rajesh Sirsikar filter
- Bekwam Data as a Service (21) Apply Bekwam Data as a Service filter
- AgileTech - Ankur Gupta (19) Apply AgileTech - Ankur Gupta filter
- Ankur Gupta - Youtube (17) Apply Ankur Gupta - Youtube filter
- Digital Gene (15) Apply Digital Gene filter
- Tech Poet (13) Apply Tech Poet filter
- iTransparent - Jaspersoft Blog (9) Apply iTransparent - Jaspersoft Blog filter
- Paco Saucedo's blog » JasperReports (6) Apply Paco Saucedo's blog » JasperReports filter
- David Hoppmann's JasperServer Posts (2) Apply David Hoppmann's JasperServer Posts filter
- Jasper Related Posts from Wedjaa (1) Apply Jasper Related Posts from Wedjaa filter
- Kamal's YouTube videos (1) Apply Kamal's YouTube videos filter