• Passing parameters from crosstab to subreport in jasper

    Passing parameters from Crosstab report to drilldown report in Jasper Studio Scenario: I have created a crosstab report and When user clicked on measure it should open a another details report by passing the same parameters being selected in crosstab report Prerequisites: Jasper Studio Workbench Jasper Server Database: Postgres – Foodmart Main Report Created a cross tab …Read More

  • Anchors in JasperReport

    Anchors in JasperReport What is anchor? Anchor provides easy access to different sections of the  report through link. One can implement this functionality in jasper using anchor expression in hyperlink. Anchor should always return ‘java.lang.String’ values. While creating jasperreports we can use anchors in text field or image element component in the irpeort. Most important thing about …Read More

  • How to increase MYSQL functions character lengths without changing validating SQL in Jasper

    How to increase MYSQL functions character lengths without changing validating SQL in Jasper Prerequisites:: Jasper Server 5.5,IReport Database:: Foodmart Scenario : I have two Tables for Table 1 i need to pass Input Control value column and for  Table2 i need to pass Input Control visible column For Table 1 I have created a multiselect parameter(Customer …Read More

  • Python – Get data from CSV and create chart

    Python – Get data from CSV and create chart Hello everyone, this blog shows how we can import data from csv and plot as mesg grid chart in python libraries, through the help of Pycharm IDE (Community Version) Prerequisite : 1. Install Python 3.6 2. Download Pycharm IDE (Community Version) 3. Basic knowledge of Python …Read More

  • Loops in Pentaho Data Integration

    Loops in PDI   If only there was a Loop Component in PDI *sigh*. But we can achieve Looping Easily with the Help of few PDI Components. Let’s take a requirement of having to send mails. Now if the mails id and files to be sent where fixed we could just use a property file …Read More

  • How to install NTP Client on Ubuntu 16.04

    How to install NTP Client on Ubuntu 16.04 To install NTP Client on Ubuntu 16.04 follow below steps : Note :To install NTP Client it have some dependency ,we need to install libopts25 package before installing NTP Client. 1.Download or use below attached libopts25 package(.deb) which supports Ubuntu 16.04   libopts25_5.18.10-4_amd64   2.Keep package file …Read More

  • Tabbed Dashboard using C3 library

    Tab Pane in Dashboard containing charts using C3 library. In this blog I’ll discuss how we can create tab menu in the dashboards  if one need html reports in the web pages. On click of these tab menus the report will change in the body section of the page. Overview : For creating different charts you …Read More

  • Recursive With Query in Postgres

    Recursive with Queries in Postgres Sometimes we might have a requirement for certain hierarchy relation in data. This can be done with the help of Recursive WITH Queries(Recursive CTE) in Postgres. Consider the example – Location is stored in table location_hierarchy.Query output will have all the children of ‘India’ along with its depth relative to …Read More

  • Analytic Query in Pentaho Data Integration

    Analytic Query in Pentaho Data Integration [LAG & LEAD] The could be a time we get a requirement as follows: Fetch Every Purchases Sum for each Customer in a year, having the following columns customerid, customername, productcost, purchasemonth Now this looks easy, but the tricky part would be fetching the PreviousPurchaseMonth he/she made a purchase …Read More

  • Export Jasper report into Specific formats using Visualize.js in JasperSoft

    Export Jasper report into Specific formats using Visualize.js in JasperSoft Pre-requisites: Used Notepad++ to create html file and jasper server enterprise 6.3 version. In jasper server for a particular jasper report we have specific options to export the report. When user wants to embed the specific jasper report in their application and if they have …Read More

  • Get historical Twitter data using Twitter4j libraries in java

    Get historical Twitter data using Twitter4j libraries in java Pre-requistes : 1. Valid twitter account 2. Some knowledge of core Java. 3. Any IDE for running Java programs and knowledge of using them. (Eclipse or InteliJ) This blog covers the following steps for getting twitter historical data : 1. Create app in twitter. 2. Download …Read More

  • Jasper server upgrade steps from CP 5.x to EE/Pro 6.x

    Jasper server upgrade steps from CP 5.x to EE/Pro 6.x Here we will see how to upgrade Jasper Server Community 5.6 to Jasper Server Enterprise 6.2 Prerequisites:: Jasper Server 5.6 Community,Java 1.8,Jasper Server 6.2 binary.zip,Linux Environment,PostgreSQL Step 1: First Take Backup of Jasper server repository folder of Jasper Server 5.6 It should be present inside …Read More

  • Cassandra Installation and Cluster Setup on Ubuntu

    Cassandra Installation and Cluster Setup Cassandra Introduction Apache Cassandra is a free and open-source distributed NoSQL database management system. It is designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra prerequisites Minimum hardware requirements: CPU: 2 cores RAM: 8 GB Software requirements: Java 8 Installation …Read More

  • Data Source Connection Details Passing from Jasper Server to SubReport Dynamically

    Data Source Connection Details Passing from Jasper Server to SubReport Dynamically Here is how we get it working using a MYSQL connection for a subreport which removes the need to hard code the connection to the sub report’s data source on Jaspeserver Prerequisites:: Ireport 5.6 ,Jasper server 5.6 DataBase : Foodmart,SugarCRM Step 1 : Create a Main …Read More

  • XmlSlurper

    XmlSlurper in Groovy This class belongs to the  package groovy.util.XmlSlurper. The XmlSlurper is very useful in groovy to handle XML related operations   The constructor XmlSlurper() can be used to create a very loose (non-validating and namespace-aware) instance. XmlSlurper parsers The parse method has many flavors. The parse method returns a GPathResult object. parse(File file) : XML …Read More