Category: Oracle Reports

Report filling process in Jaspersoft Reports

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 +

Classic and Interactive reports in Oracle Apex

Oracle Apex

Interactive reports: Interactive reports is a formatted result of a SQL query. Interactive reports can be created with both Create Application Wizard and Create Page Wizard. It supports only Desktop applications. Users can customize the report layout and data displayed. Multiple interactive reports per page can be included and developers can restrict the capabilities available to end users. In the application Report functionality, is the same across all reports. End users can customize how and what data displays while viewing an interactive report. By default, in the first column of each row, interactive reports include a search bar, an Actions menu, column heading menus, and edit icons. Classic Reports: A classic report is a formatted result of a SQL query. Classic report creation is supported by both the Create Application Wizard and Create Page Wizard. End users cannot customize a classic report except for sorting and simple filtering. To create a classic report, developers either select a table or provide a SQL statement. Classic reports support general keyword search capability, the ability to specify the number of rows that display, and basic column sorting. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more […]

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 +

How Cloud-based Business Intelligence Tools improve Healthcare Delivery

Oracle Fusion HCM

With the onslaught of COVID-19, healthcare organizations can have a hard time keeping up in tracking the patient care processes. Enterprise Business intelligence platforms like OAC (Oracle Analytics Cloud) and OBIEE, Microsoft Power BI, IBM Cognos, TIBCO Jaspersoft can provide organizations with the data tools necessary to rationalize data, comply with industry standards and improve productivity. These are the major areas where Business Intelligence platforms can help: Data Visualisation and dashboards – Web-based dashboards provide a visual interface of a critical patient, clinical, financial, and performance data points for making calculated decisions. Tools like Oracle Data Visualisation help us to spot patterns and trends, that otherwise might go unnoticed in traditional reports, tables, or spreadsheets. Analytics and Reporting – Business intelligence analytics and reporting tools can assist organizations with the data needed to quickly implement effective ways to identify, measure, and monitor the quality of service and patient care. The reports would also help in adhering to the compliance standards. Data sharing and eliminating redundancy – Having a single Business Intelligence platform would provide a single source of truth and help healthcare providers to share information across medical departments which will significantly improve medical decision outcomes and evidence-based clinical decision-making […]

Read More +

Creation of Dynamic actions on buttons in Oracle Apex

Oracle APEX

A dynamic action in Oracle Apex allows you to define some specific behaviors while executing an action. Oracle Apex has a button named APPLY_CHANGE which performs actions like Submit Page, SQL UPDATE action and create dynamic actionsWhile creating Dynamic Buttons, the values of Event, Selection Type and Button are already populated, under Execution Options by default. Also, the value entered in the Request/Button Name should be exactly the same as the name of the button on which we are creating the Dynamic Action. After setting the appropriate properties of the Dynamic Action, the action can be executed.DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 200 customers in the US and over 60 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +