Planet Jaspersoft

Filter by tags:

March 24, 2020

Hi,

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

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.
     
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

February 14, 2020

I'd a report having 15 sub reports. Out of these 15, some were having textual design and some of them needed to connect to database and display certain data using elements such as table component or an html-5 chart.

I'd started keeping/calling all the sub reports in parent reports Title band. When the report is  exported word/pdf file from server, I could see the data has not displayed for the reports having data consuming elements.

If the same sub report published as an individual entity to the server it worked but that's not an option here because this report was one of the sub reports for parent.

Tried "when no data found" property and elements position type properties but non of them worked.

Randomly, added "summary" band to the master/parent report and tried calling the sub report from this band , it worked, i.e., data has displayed for the elements from sub report when ran the master/parent report.

No idea or clue on exact reason for why data is not displayed when keeping the sub report in master/parent report, however, summary solved it.

As a best practice, I would recommend to keep sub reports in summary band instead any other report bands.

February 14, 2020

February 13, 2020

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: 


February 13, 2020

Problem Statement: 
Take a look at the below snapshot. Y1 and Y2 axis's by default gets values when you plot the data on to the chart. In this tip, you would learn how to remove these values. While exploring this example, I've revisited-how to setup conditional colors to the bars. Note that this is column spline graph.



Presuming, you have already know how to set-up dual axis and how to play with advanced properties ? If not, do not worry, copy paste the jrxm provided in professional studio and play around
a) Series bucket properties for conditional colors b) Measures Advanced properties to get Y1 and Y2 axis's b) context specific advanced properties for graph's Y1 and Y2 properties.

Since it is late in the night writing this post, I didn't want just to leave the stuff that took 3-4 days of R&D,

Most of the examples in this site works on postgresql foodmart database(that ships with jaspersoft server installation) including this one.

Removing Y1 Axis Labels
This is simple and straight forward, configure below advanced property

Removing Y2 Axis Labels
There are workarounds in high charts API with opposite=false and with style-lables-enabled=false but non of these worked effectively in studio graph. lable.style.fontSize=0 is the property that removes labels from Y2 axis


Sample output
Conditional colors of bars: 
If you want to print conditional colors for bars based on series values something like below expression should work. 

In series Bucket Properties

color=$F{series}.equals("Rating1") ? "#c00000" : ($F{series}.equals("Rating2")?"#a5a5a5":($F{series}.equals("Rating3")?"#ffc000":($F{series}.equals("Rating4")?"#4472c4":"#ffffff")))
To apply the above to measures, do not forget to give below shown for each of the measure.


Other Notes:
You may also refer to this blog post for understanding how to configure Y1 and Y2 axis's advanced properties

Playing with Advanced Properties of Dual Axis high Chart in Japser Studio 6.x or later - How to control Y axes values (min or max or common zero)

https://community.jaspersoft.com/blog/playing-advanced-properties-dual-axis-high-chart-japser-studio-6x-or-later-how-control-y-axes

JRXML: This example is developed using J.Studio 7.2 professional- preferable to use the same or later version to import this example for your studio. 
<?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="Dual Axis-Remove Y1_Y2_AxisLabels_XAxisLabelsWrapping" pageWidth="650" pageHeight="700" columnWidth="650" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="aad33c48-a3a4-4ab3-9120-761b1fe88d16">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/>
<property name="ireport.jasperserver.user" value="superuser"/>
<property name="ireport.jasperserver.reportUnit" value="/EarthlySystems/Test/Dual_Axis_Remove_Y1_Y2_AxisLabels_XAxisLabelsWrapping"/>
<property name="ireport.jasperserver.report.resource" value="/EarthlySystems/Test/Dual_Axis_Remove_Y1_Y2_AxisLabels_XAxisLabelsWrapping_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" uuid="3b042c00-14be-48c4-b1ba-b74d4cedcf22">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="328"/>
<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="665"/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="foodmart"/>
<queryString language="SQL">
<![CDATA[(select 'Rating1' as series, 'category1' as category, 'Number1' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating2' as series, 'category1' as category, 'Number1' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating3' as series, 'category1' as category, 'Number1' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating4' as series, 'category1' as category, 'Number2' As rating , 1.5 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating5' as series, 'category1' as category, 'Number4' As rating , 3 as ratingValue  from customer limit 1 )

UNION ALL

(select 'Rating1' as series, 'category2' as category, 'Number1' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating2' as series, 'category2' as category, 'Number1' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating3' as series, 'category2' as category, 'Number1' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating4' as series, 'category2' as category, 'Number2' As rating , 1.5 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating5' as series, 'category2' as category, 'Number4' As rating , 2 as ratingValue  from customer limit 1 )

UNION ALL

(select 'Rating1' as series, 'category3' as category, 'Number1' As rating , 1.5 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating2' as series, 'category3' as category, 'Number1' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating3' as series, 'category3' as category, 'Number1' As rating , 1 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating4' as series, 'category3' as category, 'Number2' As rating , 1.5 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating5' as series, 'category3' as category, 'Number4' As rating , 2 as ratingValue  from customer limit 1 )


UNION ALL

(select 'Rating1' as series, 'category4' as category, 'Number1' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating2' as series, 'category4' as category, 'Number1' As rating , 1 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating3' as series, 'category4' as category, 'Number1' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating4' as series, 'category4' as category, 'Number2' As rating , 0.5 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating5' as series, 'category4' as category, 'Number4' As rating , 2 as ratingValue  from customer limit 1 )

UNION ALL

(select 'Rating1' as series, 'category5' as category, 'Number1' As rating , 1 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating2' as series, 'category5' as category, 'Number1' As rating , 1 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating3' as series, 'category5' as category, 'Number1' As rating , 1 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating4' as series, 'category5' as category, 'Number2' As rating , 0.5 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating5' as series, 'category5' as category, 'Number4' As rating , 3 as ratingValue  from customer limit 1 )

UNION ALL

(select 'Rating1' as series, 'category6' as category, 'Number1' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating2' as series, 'category6' as category, 'Number1' As rating , 1 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating3' as series, 'category6' as category, 'Number1' As rating , 3 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating4' as series, 'category6' as category, 'Number2' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating5' as series, 'category6' as category, 'Number4' As rating , 3 as ratingValue  from customer limit 1 )

UNION ALL

(select 'Rating1' as series, 'category7' as category, 'Number1' As rating , 1.5 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating2' as series, 'category7' as category, 'Number1' As rating , 1 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating3' as series, 'category7' as category, 'Number1' As rating , 2 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating4' as series, 'category7' as category, 'Number2' As rating , 1.5 as ratingValue  from customer limit 1 )
UNION ALL
(select 'Rating5' as series, 'category7' as category, 'Number4' As rating , 3 as ratingValue  from customer limit 1 )]]>
</queryString>
<field name="series" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="series"/>
</field>
<field name="category" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="category"/>
</field>
<field name="rating" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="rating"/>
</field>
<field name="ratingvalue" class="java.math.BigDecimal">
<property name="com.jaspersoft.studio.field.label" value="ratingvalue"/>
</field>
</subDataset>
<queryString language="SQL">
<![CDATA[select 1 as one from customer limit 1]]>
</queryString>
<field name="one" class="java.lang.Integer">
<property name="com.jaspersoft.studio.field.label" value="one"/>
</field>
<summary>
<band height="414">
<componentElement>
<reportElement x="0" y="0" width="650" height="414" uuid="f8096db8-7106-4544-81f4-4158678dcaee">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
</reportElement>
<hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="ColumnSpline">
<hc:chartSetting name="default">
<hc:chartProperty name="chart.zoomType">
<hc:propertyExpression><![CDATA["xy"]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="colors">
<hc:propertyExpression><![CDATA[java.util.Arrays.asList("#7cb5ec","#434348","#FF0000","#f7a35c","#8085e9","#f15c80","#e4d354","#2b908f","#f45b5b","#91e8e1")]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="credits.enabled">
<hc:propertyExpression><![CDATA[false]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="credits.href">
<hc:propertyExpression><![CDATA[""]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="credits.text">
<hc:propertyExpression><![CDATA[""]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="plotOptions.series.allowPointSelect">
<hc:propertyExpression><![CDATA[Boolean.TRUE]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="plotOptions.series.dashStyle">
<hc:propertyExpression><![CDATA["Dash"]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="title.text">
<hc:propertyExpression><![CDATA[""]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="legend.enabled_customSimpleMode" value="true"/>
<hc:chartProperty name="legend.enabled">
<hc:propertyExpression><![CDATA[false]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="plotOptions.series.marker.symbol" value="diamond"/>
<hc:chartProperty name="plotOptions.series.marker.fillColor" value="#000000"/>
<hc:chartProperty name="plotOptions.column.groupPadding_customSimpleMode" value="true"/>
<hc:chartProperty name="plotOptions.column.pointPadding_customSimpleMode" value="true"/>
<hc:chartProperty name="plotOptions.column.pointPadding">
<hc:propertyExpression><![CDATA[0]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="plotOptions.column.pointInterval_customSimpleMode" value="true"/>
<hc:chartProperty name="plotOptions.series.marker.radius">
<hc:propertyExpression><![CDATA[8]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="xAxis.labels.useHTML_customSimpleMode" value="true"/>
<hc:chartProperty name="yAxis.labels.enabled_customSimpleMode" value="true"/>
<hc:chartProperty name="plotOptions.column.dataLabels.enabled_customSimpleMode" value="true"/>
<hc:chartProperty name="yAxis.labels.enabled">
<hc:propertyExpression><![CDATA[false]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="xAxis.labels.step" value="1"/>
<hc:chartProperty name="xAxis.labels.style.textOverflow" value="wrap"/>
</hc:chartSetting>
<hc:chartSetting name="yAxis">
<hc:chartProperty name="_jrAxisIndex">
<hc:propertyExpression><![CDATA[1]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="id">
<hc:propertyExpression><![CDATA["id1"]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="labels.style.fontSize" value="0"/>
<hc:chartProperty name="linkedTo">
<hc:propertyExpression><![CDATA[0]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="max" value="3"/>
<hc:chartProperty name="min">
<hc:propertyExpression><![CDATA[0]]></hc:propertyExpression>
</hc:chartProperty>
</hc:chartSetting>
<hc:chartSetting name="yAxis">
<hc:chartProperty name="_jrAxisIndex" value="0"/>
<hc:chartProperty name="id">
<hc:propertyExpression><![CDATA["id0"]]></hc:propertyExpression>
</hc:chartProperty>
<hc:chartProperty name="max" value="3"/>
<hc:chartProperty name="min">
<hc:propertyExpression><![CDATA[0]]></hc:propertyExpression>
</hc:chartProperty>
</hc:chartSetting>
<multiAxisData>
<multiAxisDataset>
<dataset>
<datasetRun subDataset="Dataset1" uuid="aa88620b-9675-468d-b14d-e460a4523487"/>
</dataset>
</multiAxisDataset>
<dataAxis axis="Rows">
<axisLevel name="Category">
<labelExpression><![CDATA["Level Label expression"]]></labelExpression>
<axisLevelBucket order="None" class="java.lang.String">
<bucketExpression><![CDATA[$F{category}]]></bucketExpression>
</axisLevelBucket>
</axisLevel>
</dataAxis>
<dataAxis axis="Columns">
<axisLevel name="Series">
<labelExpression><![CDATA[]]></labelExpression>
<axisLevelBucket order="None" class="java.lang.Comparable">
<bucketExpression><![CDATA[$F{series}]]></bucketExpression>
<bucketProperty name="color"><![CDATA[$F{series}.equals("Rating1") ? "#c00000" : ($F{series}.equals("Rating2")?"#a5a5a5":($F{series}.equals("Rating3")?"#ffc000":($F{series}.equals("Rating4")?"#4472c4":"#ffffff")))]]></bucketProperty>
</axisLevelBucket>
</axisLevel>
</dataAxis>
<multiAxisMeasure name="Measure1" class="java.math.BigDecimal" calculation="Nothing">
<labelExpression><![CDATA[""]]></labelExpression>
<valueExpression><![CDATA[$F{ratingvalue}]]></valueExpression>
</multiAxisMeasure>
<multiAxisMeasure name="Measure2" class="java.math.BigDecimal" calculation="Nothing">
<labelExpression><![CDATA[""]]></labelExpression>
<valueExpression><![CDATA[$F{series}.equals("Rating5")?$F{ratingvalue}:null]]></valueExpression>
</multiAxisMeasure>
</multiAxisData>
<hc:series name="Measure1">
<hc:contributor name="SeriesProperty">
<hc:contributorProperty name="yAxis" valueType="Constant" value="id0"/>
</hc:contributor>
<hc:contributor name="SeriesItemProperty">
<hc:contributorProperty name="color" valueType="Bucket" value="Series.color"/>
</hc:contributor>
</hc:series>
<hc:series name="Measure2">
<hc:contributor name="SeriesProperty">
<hc:contributorProperty name="yAxis" valueType="Constant" value="id1"/>
</hc:contributor>
</hc:series>
</hc:chart>
</componentElement>
</band>
</summary>
</jasperReport>


February 13, 2020

February 11, 2020


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 

February 11, 2020

February 4, 2020


Wrong : "<style forecolor='#ffffff' size='14'>Sadakar & Rohit </style>"

Correct : "<style forecolor='#ffffff' size='14'>Sadakar &amp; Rohit </style>"

Reason: Styled Markup takes XML symbols\syntax's

Sample output: 


February 4, 2020

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>

February 4, 2020

June 21, 2019

Load Data

rajeshsirsikar
Rajesh Sirsikar )

In this final section we look at the data load. Here we will use the same tUnpivot row component to transpose the actual row data into columns and assign the column values from the column_config file. In this we will use the same…

June 21, 2019

Manage Order

rajeshsirsikar
Rajesh Sirsikar )

This section is direct extraction from Bekwam Blog Here we will assign the value of primary columns to a HashMap object called fieldname. Input file is the same input file from tFileList tJaveRow has the code to assign values. The code is as…

June 21, 2019

Pages

Feedback