Category: Jaspersoft

Jaspersoft built-in fonts and Font extensions

Jaspersoft built-in or system Fonts can be viewed in the Report viewer provided the fonts are supported by the Operating system. The best way to use a font in JasperReports Library is to use a font extension. • Jaspersoft fonts can be configured in Studio and Server and displayed in the PDF view. Fonts can be referred from an URL and from the file system using the Preferences dialog window from the Jaspersoft Studio. • The fonts .ttf files (True Type Font) can be downloaded and can be configured using the font mapping option available in the Jaspersoft studio. There are different types of font attribute such as font name, size, isBold, italic and so on. • JasperReports fonts can be categorized as logical fonts, physical fonts and font extensions. The logical fonts recognized by Java library are Serif, SansSerif, Monospaced, Dialog, and DialogInput. • The default font type offered by Jaspersoft is SansSerif with font size, 10. And the default pdf font is Helvetica. The default font name and size can be changes in report level and server level. • Font extensions force JasperReports to work with external TTF, SVG, WOFF, or EOT fonts. This ensures that a specific […]

Read More +

Why use DataStage?

ETL Datastage

Datastage is an ETL tool which extracts, transform and load data from source to the target. The data sources might include sequential files, indexed files, relational databases, external data sources, archives, enterprise applications, etc. The reasons for using DataStage • DataStage Module helps in reducing the workload and business rules management. It optimizes hardware utilization and control job activities • It provides user interaction with administrative projects. It also keeps interaction with systems and can manage global settings. The administrator’s responsibility varies from setting up projects, properties, adding, deleting and moving projects. A command interface is given to DataStage Repository administrators. • DataStage repository can be viewed and edited, the main interface of DataStage repository is DataStage Manager. To search or Store DataStage repository and manage to reuse Metadata, the Manager loads all the services. It plays an important role in organizing all tasks to the DataStage Repository. • It helps in creating jobs on DataStage or app by giving the design interface. Each job from outside view specifies the instinct of data, possible transformations, and the target as well. The designer will also provide user graphical interface which is easy. The server will take care of loading the executable […]

Read More +

Creating Queries in Jaspersoft Reports

Jaspersoft reports

Jaspersoft Studio provides tools to help user define report fields and create a proper query if a query language is used to acquire the data for the report. These tools are presented in the Dataset and Query dialog. It also provides an easy way to build SQL queries by using a drag-and-drop query builder. This allows users who don’t know SQL or just are not sure about the syntax to quickly join tables and produce complex data filters and where conditions. SQL Builder also provides a way for skilled users to explore the database and list the metadata such as schemas and available tables. Using Dataset and Query Dialog: The dataset and query dialog allows a user to: • Select a data adapter with which to configure the dataset. Usually, a data adapter is selected, but it is possible to change it if necessary. • Select a query language for the dataset being edited (which can be the main dataset or a sub-dataset used to populate a chart or a table). • Specify the query by typing text or by using a tool, if available, designed for the selected language. A tool is available for several languages including SQL, XPath […]

Read More +

Frames in Jaspersoft Reports

Jaspersoft reports

A frame is an element that can contain other elements and optionally draw a border around them. Since a frame is a container of other elements, in the document outline view the frame is represented as a node containing other elements. A frame can contain other frames, and so on recursively. To add an element to a frame, just drag the new element from the palette inside the frame. Alternatively, the user can use the outline view and drag elements from a band into the frame and so on. The position of an element is always relative to the container position. If the container is a band, the element position is relative to the top of the band and to the left margin. If the container is a frame, the element coordinates are relative to the top left corner of the frame. Since an element dragged from a container to another does not change its top/left properties, when moving an element from a container to another its position is recalculated based on the new container location. Advantages of using a frame: • When the user moves a frame, all the elements contained in the frame move. • While using a […]

Read More +

Jaspersoft reporting with JSON (JavaScript Object Notation) Datasource

Jaspersoft Reports

Jaspersoft business intelligence reporting can be done using a JSON data source. The following are some features and benefits of Jaspersoft with JSON data source. • In the BI world, time is taken for data retrieval and memory consumption are the key factors in determining efficiency and performance. With JSON data source, Jaspersoft offers to transport data between a server and a client (web) application provided with increased efficiency and performance. • A JSON file with the actual report data can be passed to the report either from a file location or from a remote location. Once a data-adapter is created using a JSON file, the fields from the JSON can be used in the report layout. • The data-adapter from the Jaspersoft studio can be downloaded and uploaded to the Jaspersoft Server and the same report can be run from the server also. • The JSON data source can also be passed as a parameter from the main report to the sub-report in the sub-report connection expression properties. • JSON data-source offers a lightweight syntax and ease of use. Reports can be created quickly once the data are populated in the JSON file. • JSON data-source has wide advantages […]

Read More +

Jasper Reports Global Scriptlets

Pre-built reports

When complex functionality cannot be achieved easily using report expressions or variables, JasperReports provides us with a simple and powerful means of doing this with Scriptlets. Scriptlets are sequences of Java code that are executed every time a report event occurs. Values of report variables can be affected through scriptlets. User can associate scriptlets by declaring the scriptlets globally. The global scriptlets apply to all reports being filled in the given JasperReports deployment. This is made easy by the fact that scriptlets can be added to JasperReports as extensions. The scriptlet extension point is represented by thenet.sf.jasperreports.engine.scriptlets.ScriptletFactory interface. Jasper Reports will load all scriptlet factories available through extensions at runtime. Then, it will ask each one of them for the list of scriptlets instances that they want to apply to the current report that is being run. When asking for the list of scriptlet instances, the engine gives some context information that the factory could use in order to decide, which scriptlets actually applied to the current report. Data Terrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We […]

Read More +

Salient Features of Jaspersoft Server

Jaspersoft Server (also called JasperReports server), is the core of the Jaspersoft BI Suite. It builds on the JasperReports Library to provide a fully functional and stand-alone report server. Jaspersoft Server provides many important features such as security, a repository, and scheduling. • Jaspersoft server can be downloaded and installed separately. Once installed it can be accessed via the URL andfrom Jaspersoft studio. • Jaspersoft Server commercial edition offers a complete user-friendly web-based drag and drop Adhoc reporting feature. Users can build interactive charts, tables and cross tab analytics. • Jaspersoft server supports all datasource connectors that are available in Jaspersoft library. • Jaspersoft server provides flexible, modern and embeddable server architecture such as data caching and storage architecture, REST and SOAP based web services for simplified integration, mobile application and multi touch capability and so on. • Report scheduling based on a calendar can be performed for the deployed reports from the Jaspersoft server. • Security setup can be done by Administrators from Jaspersoft server by providing user based and role-based access to reports, dashboards, resources and folders. • Jaspersoft server Commercial edition also has the capability to design a metadata layer called Domain with business logic and joins. […]

Read More +