How to restrict Multiselect input control values in jaspersoft :

How to restrict Multiselect input control values in Jaspersoft  This blog will teach the reader , how to restrict multiselect input control values in jasper without hampering the performance . DB : Postgres (foodmart) Table : customer Reporting tool : iReport Server : Jasperserver 5.6 I/P Parameter : country Requirement : Get All the informations …Read More

Migrate oracle with pentaho

Steps to migrate Oracle with Pentaho   Step 1:- Run script as DB admin. Script is available in location:- biserver-ce\data\oracle10g. Modify configuration file:- applicationContext-spring-security-hibernate.properties. Location:- pentaho-solutions\system\applicationContext-spring-security-hibernate.properties. original code:- jdbc.driver=org.hsqldb.jdbcDriver jdbc.url=jdbc:hsqldb:hsql://localhost:9001/hibernate jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.HSQLDialect Modified code:- dbc.driver=oracle.jdbc.OracleDriver jdbc.url=jdbc:oracle:thin:@localhost:1521/sysdba jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.Oracle10gDialect hibernate-settings.xml Location:- pentaho-solutions\system\hibernate\hibernate-settings.xml. Original code <config-file>system/hibernate/hsql.hibernate.cfg.xml</config-file> Modified code:-

Working with Virtual Servers on Talend Administration Center (TAC)

  Working with Virtual Servers on Talend Administration Center (TAC) Virtual Server Configuration : A virtual server is a group of physical servers from which the best rated server will automatically get preferred at Job execution time. In Talend Administration Center, simply select physical servers and group them into a virtual server. Then set the …Read More

Remove Repeated Column header, Page Header, Page Footer in CSV Export (JASPER)

In CSV export, we want only column header once and data should be printed. We do not want page header, page footer and repeated columns header. So in order to achieve this do the following. Remove Page Header: <property name=”net.sf.jasperreports.export.csv.exclude.origin.band.(uniqueValue)” value=”pageHeader”/> Remove Page Footer: <property name=”net.sf.jasperreports.export.csv.exclude.origin.band.(uniqueValue)” value=”pageFooter”/> Remove Title Band: <property name=”net.sf.jasperreports.export.csv.exclude.origin.band.(uniqueValue)”value=”title”/> Remove Repeated Column …Read More

buildjob

Scheduling Talend Job on both Windows and Linux OS

Scheduling Talend Job on both Windows and Linux OS In order to schedule a Talend Job, first we have to export the job as build job which will generate the runnable files to execute on required OS. And also all the child jobs in that project converted as jar files. Right click on the parent/main job …Read More

Using Bootstrap Modal with ReactJS

Using Bootstrap Modal with ReactJS Here we will be creating a reusable React-component for Bootstrap Modal. Setup Let’s first create a skeleton for our component. Create a file bootstrap-modal.jsx which contains the following code: var BootstrapModal = React.createClass({ displayName: “BootstrapModal”, render: function () { return ( <div ref=”modal” className=”modal fade”> <div className=”modal-dialog”> <div className=”modal-content”> <div …Read More

DWR

DWR (DIRECT WEB REMOTING) Introduction DWR, or Direct Web Remoting, is a Java open source library that helps developers write web sites that include Ajax technology. It is a RPC library which makes it easy to call Java functions from JavaScript and to call JavaScript functions from Java. How it works? It consists of two …Read More

Installing JasperReports Server 6.0.1 with Oracle DB (in Windows)

Installing JasperReports Server 6.0.1 with Oracle DB (on Windows) Pre-requisite Java JDK 1.6 or 1.7 should be installed. Create and set the JAVA_HOME system environment variable to point to the Java JDK location. Apache Tomcat 5.5, 6, or 7 should be installed. Oracle should be installed. Download the WAR file distribution from http://support.jaspersoft.com. The WAR …Read More