Jaspersoft How to Connect to KDB database in Jaspersoft By Mounika To Connect to KDB database in Jaspersoft follow the below steps: Open Jasper studio and create a data adapter. KDB requires a separate jar file called ‘jdbc.jar’.Below is the jar file. JDBC.jar file Include this jar file in Driver Classpath....
Jaspersoft Increase the Column Width for Jasper Adhoc Report By Satya Gopi In this blog we are going to cover how to increase the column width for jasper adhoc reports. Perquisites: Jasper 6.4 Enterprise Databases: SugarCRM Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence...
Jaspersoft High-Chart Label Formatting By Ramu Vudugula High-chart label Formatting Prerequisites: Jasper Server 6.4.2 Database: Foodmart In this blog,we trying to formatting the x.axis label in StackedColumnSpline chart. In chart,it shows store_type-Wise, Store-wise Store_Sales, Store_Cost and Unit_Sales with following dataset query. “select s.store_type, s.store_name,sum(store_sales) as sales,sum(Store_cost) as...
Jaspersoft Usage of Virtualizers in JasperServer/Studio By Satya Gopi Before going to the virtualizers we need to know how a Report is generated in Jasper: Generally the reports are created using Jasper Studio or Adhoc Reports which creates a jrxml file, once it complies we will going to get...
Jaspersoft Changing Default Save Folder for Adhoc Views in Jasper By Satya Gopi Prerequisites: Jasper 6.4.0 Enterprise Database: Foodmart Here we can see how we can change the Default Save Folder path for ad-hoc views. If we need to choose a dynamic path, like logged user folder name as the default location, for...
Jaspersoft Adding New Custom Fonts in Jaspersoft Studio and Jasper Server By Ramu Vudugula To display the report using the custom fonts I.e new fonts which do not exist in the Jasper we have to use “font extensions” process. Using this we can add any kind of font in the report. Here I am...
Jaspersoft Create Alphabet Row Numbering in Table Component of Jasper Report By admin Prerequisites: Jasper Server 6.4.0 Database: Foodmart In this blog, we learn to display a simple numbering to row in table component using an alphabet instead of numbers. Make data easy with Helical Insight. Helical Insight is the world's best open...
Jaspersoft How to Create a user in Jasper Server using Jasper REST API in Java By Mounika This blog explains the creation of a user in jasper server using java. Java code uses REST API to create a user in the Jasper server. Make data easy with Helical Insight. Helical Insight is the world's best open source...
Jaspersoft Creating HTML 5 Charts using Multiple Datasets in Jasper By admin Prerequisite: Jasper 6.3 studio Database: Foodmart In this blog we can see how we can use 2 datasets to plot an HTML5 Bar Chart, If we need to plot a chart by using 2 values from different queries then this...
Jaspersoft Creating Report Book in Jaspersoft Studio By Ramu Vudugula Report books are multiple reports or subreports combined into a single report. It combines several sections like cover pages, table of contents, reports, subreports into a book. Make data easy with Helical Insight. Helical Insight is the world's best open...
Jaspersoft How to Make Label Wrapping for Pie Chart in Jasper Reports By admin Prerequisites: Jasper Studio 6.4.0 Database: foodmart In this blog we will discuss how to wrapping the label text for HTML5 pie chart in Jasper reports. Make data easy with Helical Insight. Helical Insight is the world's best open source business...
Jaspersoft Passing Multi Select Values from Jasper to PostgresSQL Function By Satya Gopi Prerequisites: JasperServer Studio 6.3,Postgress DataBase:Foodmart In most of the scenario’s we will think, how we can pass a Multi-select value from Jasper to a SQL function, here is the solution for that Step 1: Created a Sample Report with a...