Category: Jaspersoft

Overview of Security Features in Jaspersoft Reports server

Jasper Reports Server has built-in security that ensures that users can only access the data they are allowed to view. The following are the major Jaspersoft Server security features. • Jaspersoft Server provides Security configuration in User level, Application level and Domain level. • Jaspersoft offers setting up Authentication and Authorization. These steps can be configured through the “Manage Security” option will be visible to the Admin users in the Jaspersoft server. • Authentication includes creating users and roles from Jaspersoft server using the “Add user” option. Once users are created, roles can be assigned to specific users. Also, a user may belong to any number of roles. The administrator can create, modify and delete Users and Roles. • Authorization includes control over Menu options and pages, Organization scope, Resource permissions, Administrator privileges, Data-level security and Profile attributes. • Row-level security and Column level security can be applied to the Domains security file in XML format configured in Jaspersoft Server Commercial edition. • Application level security can be achieved in configuration level which includes protection against SQL injection, password encryptions in configuration files, restriction of file uploading, disabling Unused HTTP verbs, etc. DataTerrain with years of experience and reliable experts […]

Read More +

Charting Functionality in Jaspersoft

JasperReports support many built-in charts created using the popular open source library JFreeChart. These charts help to create visually compelling reports and dashboards. • Chart components of the Jaspersoft reports simplify the way to insert the charts into the reports and also the process of gathering chart data becomes easier. • When compared to other reporting tools many varieties of charts can be created in Jasper such as Pie, Pie 3D, Scatter, Bubble, High-Low-Open-Close, Candlestick, Gantt, xyBarChart, linechart etc. • Pixel perfect report designer includes layouts containing charts and images are being supported in all types of editions. • Characteristics such as orientation and background color can be defined in jasper reports. For instance, the label rotation attribute allows the text labels on the x-axis to rotate clockwise or anti-clockwise. • Configuration can be done for all charts such as a border around all sides, title font, show/hide legend, plot area background color, subtitle font etc. • Commercial editions provide advanced HTML5 charts which are interactive DataTerrain 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 are flexible in […]

Read More +

Jaspersoft – Feature rich Open source BI tool

Jaspersoft is a leader among open source business intelligence (BI) and reporting tools. This is primarily due to the rich set of features which comes as part of the Jaspersoft platform. • Jaspersoft reports Server embeds the Jaspersoft Reports engine and provides a user-friendly, web-based interface for end-users to run and view reports. • Jaspersoft has an in-built report scheduler wizard through which we can set up a schedule and define the recurrence and frequency. • Different types of export options are available such as PDF, XLS, CSV, DOCX, RTF, ODT, ODS, etc. • Reports can be viewed seamlessly in desktop screen and mobile devices. • Jaspersoft server supports a variety of datastores including Oracle, PostgreSQL, and NoSQL. • Jaspersoft handles a large volume of data with ease. Jaspersoft displays the initial page of a large report quickly and then loads the subsequent pages in the background, hence the output appears to be rendered fast. • Charts, visual text rotation and graphs can be created perfectly with some in-build properties such as appearance, borders, hyperlink, chart and chart plot. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in […]

Read More +

Jaspersoft Report–Basic Element Properties and Palette

All elements have a set of common properties. Other properties are specific to the element type. An element’s properties determine its appearance and position on the page. Users can access the properties of a selected element in the Properties view (by default in the upper right area of the UI). In Jaspersoft Studio user place elements within bands (containers). Depending on the elements it contains, the user can change the vertical size of a band. The Palette: Elements appear in the Palette, located by default in the top right of the UI. The palette contains three sub-palettes: Basic Elements: It contains the elements and components available in all editions of Jaspersoft Studio Composite Elements: It contains elements created as combinations of other elements, such as Page Number and Time. Users can add their own composite elements to any palette. Components Pro: contains elements only available in commercial versions of Jaspersoft Studio. This subpalette is not visible in the community edition. DataTerrain 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 are flexible in working hours and do not need […]

Read More +

How to create Alternate Row backgroundcolor in Jaspersoft reports

Conditional styles combined with some specific report built-in variables can be used to generate alternate row colors in the detail section of Jaspersoft reports. As known, the detail section is repetitive and contains common layout information for records in the dataset. For each record in the dataset, a detail section filling process is called at fill time. Being related to records, one of the most common layouts used for the detail section is the table row layout. And like in any other table, alternate row colors might be needed. To obtain alternate row colors, two things are necessary: 1. To know the current record number in order to determine if it’s odd or even. 2. A conditional style with specific style properties for odd or even rows. The first requirement is accomplished with the help of report built-in counting variables: • REPORT_COUNT – If the row color alternation does not depend on the page, column or group breaks. • PAGE_COUNT – If each new detail page should start with the same row color. • COLUMN_COUNT – If each new detail page column should start with the same row color • <group_name>_COUNT – If each new group of records should start […]

Read More +

DataTerrain launches SAS BI to Japsersoft report conversion solution

DataTerrain a leader in Business Intelligence migration solutions, announced the launch of a report conversion solution for customers who are migrating from SASBI to the Jaspersoft platform. Jaspersoft offers both community and professional edition which could result in significant savings in license costs. DataTerrain’s conversion solution enables customers with SAS BI reports migrating to the Jaspersoft Platform. The conversion framework includes the analysis phase, where all the source elements are examined, and the missing elements are identified, that can be used for pin-pointed analysis to narrow down to report migration issues. DataTerrain’s experts can help recommend solutions for the compatibility issues and resolve. The conversion solution also includes the conversion of native functions and complex formula logics embedded in SAS BI reports and provides an equivalent solution to achieve the same in the Jaspersoft platform. Customers can take advantage of DataTerrain’s conversion solution to preserve years of effort in designing the reports while migrating to the Jaspersoft platform. DataTerrain’s conversion Services are offered under a Fixed-cost basis and for any type or number of reports basis. There are NO long-term contracts required and can be utilized for a specific project to a broader spectrum of support Please contact connect(at)dataterrain(dot)com for […]

Read More +

DataTerrain launches SAS BI Automated Report Conversion Solution

DataTerrain a leader in Business Intelligence migration solutions, announced the launch of Automated reports conversion solution for customers who are migrating from SASBI platforms to other BI platforms like Jasper, Cognos or OBIEE. DataTerrain’s Automated conversion solution enables customers with SAS BI reports migrating accurately to the target Platform. The Automated conversion framework includes the analysis phase, where all the source elements are examined and the missing elements are identified, that can be used for pin-pointed analysis to narrow down the report migration issues. DataTerrain’s experts can help recommend solutions for the compatibility issues and resolve them. The Automation conversion solution also includes conversion of native functions and complex formula logics embedded in SAS BI reports and provide an equivalent solution to achieve the same in the target platform. Customers can take advantage of DataTerrain’s Automated conversion solution to preserve years of efforts in designing the reports while migrating to new BI platform. DataTerrain’s Automation conversion services are offered under a Fixed-cost basis for any type or number of reports basis. There are NO long-term contracts required and can be utilized for a specific project to a broader spectrum of support Please contact connect(at)dataterrain(dot)com for more information. About DataTerrain DataTerrain […]

Read More +

Report filling process in Jaspersoft Reports

The main objective of any reporting tool is to produce high-quality documents. Report filling process helps reporting tool to achieve this by manipulating sets of data. The main inputs required for the report-filling process are – • Report Template: Its actual JasperReport file. • Report Parameters : These are basically named values that are passed at the report filling time to the engine. • Data Source: User can fill a Jasper file from a range of data sources like an SQL query, an XML file, a CSV file, an HQL (Hibernate Query Language) query, a collection of Java Beans, etc. The output generated by this process is a .jrprint document which is ready to be viewed, printed, or exported to other formats. The facade class net.sf.jasperreports.engine.JasperFillManager is usually used for filling a report template with data. This class has various fillReportXXX() methods that fill report templates. There are two categories of fillReportXXX() methods in the façade class – • The first type receives a java.sql.Connection object as the third parameter. Most of the times, reports are filled with data from a relational database. This is achieved by – Connect to the database through JDBC. Include an SQL query inside the report […]

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 +

Properties view in Jaspersoft Report

  The Properties view in Jaspersoft Report helps the user to configure a selected element. If more than one element is selected, only the properties of those elements have in common are shown. If the Properties view is not visible, open the context menu for the selected elements and find the Show Properties menu item, which shows and brings to the front the Properties view. Properties are organized into tabs and sections for a better organization and usability. Tabs can include the following: Appearance tab, which contains all the properties responsible for element size, position, colors, style and flags when the element is shown in the runtime. Borders tab, where user can configure how borders of the element are painted. An element tab allows the user to set evaluation time along with properties specific to the element type. For example: The Static Text tab allows the user to define unchangeable text for a field and control its appearance. The Text Field tab allows the user to format and position a text field element. The Image tab allows the user to set image alignment, fill, and scale properties. Advanced tab, which contains all the properties for the report element in the […]

Read More +