Category: Report Conversion

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 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 +

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 +

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 +

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 +

Frames in 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 +

Creating Queries in 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 +

Jasper Reports Scriptlets

Data displayed on the Jasper reports are usually fetched from report parameters and report fields. This data can be processed using the report variables and their expressions. There are situations when a complex functionality cannot be achieved easily using report expressions or variables. For such situations, 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. Scriptlet is declared into two ways: • Using <scriptlet> element. It has a name attribute and class attribute. The class attribute should specify the name of the class, which extends the JRAbstractScriptlet class. The class must be available in the class-path at report filling time and must have an empty constructor so that the engine can instantiate it on the fly. • Using the attribute scriptletClass of the element <jasperReport>, in the report template (JRXML). Any number of scriptlets can be specified per report. If no scriptlet is specified for a report, the engine still creates a single JRDefaultScriptlet instance and registers it with the built-in REPORT_SCRIPTLET parameter.   DataTerrain with years of experience and reliable […]

Read More +

DataTerrain enhances its HCM Report Migration and Development Services

DataTerrain, a leader in Business Intelligence migration solutions, enhanced its Oracle HCM report development services for customers who are looking to migrate or develop reports and dashboards in Oracle HCM. DataTerrain has over 10 years of experience in Planning, Design, Development, Tuning, and Support a variety of Business Intelligence tools and specializes in reporting solutions. The DataTerrain team has in-depth real-world expertise in Oracle HCM application and specifically reporting. The DataTerrain Automation (automation tool) extracts report information from a current reporting source, then converts and publishes your reports to the desired target BI reporting system. Our KEY BENEFIT is Automation in converting or newly creating TaleoWebi reports to Oracle business intelligence at guaranteed fixed time and unbeatable low cost. DataTerrain has created a framework which enables customers with PeopleSoft pre-built Tax/HR/Payroll/Benefits reports to either migrate accurately to Oracle Fusion HCM as custom Extracts and Reports or develop new HCM reports in OTBI/BIP or Extract formats. The development service framework starts with an analysis phase, which involves understanding theexisting source report and create a functional description document. This would be followed by the actual report development and validation. DataTerrain reports have excellent features and efficiency that will unleash full potential of […]

Read More +