Report Template-Based Programming
Although it is possible to create an entire report programmatically (using just the InetSoft API), the recommended approach is to use the Report Designer to create the report in its entirety.
If you need to bind the data programmatically, first create the report template layout in the Report Designer, load it as a ReportSheet object into a Java program and then use the data binding API to bind data to the report elements.
All operations such as page set-up, presentation, formatting, grouping and summarization, group ranking, etc., should be performed at the template level using the Report Designer. Extracting data from the data sources, creating the appropriate 'Lens' objects, and binding them to the report elements should be done programmatically only if required.
Note: Before calling any InetSoft API function programmatically, first specify the location of the registry directory (SREE Home). To do this from within your program, use the following syntax:
System.setProperty("sree.home", "{path to registry}");
To do this from the command line (for example, when running a program named “ProgramName”), use the following syntax:
java -Dsree.home="{path to registry}" ProgramName
Importing Report Templates
To use a report template in a Java program, the first step is to create a ReportSheet object from the template file. The Builder class in the inetsoft.report.io package handles this.
Builder builder = Builder.getBuilder(Builder.TEMPLATE, new FileInputStream(“report1.srt”)); ReportSheet report = builder.read(“.”);
If the template is not stored in the correct format, an Exception will be returned and it should be properly handled.
The argument to the Builder.read() is a directory which is used to calculate the image paths if relative file paths are used in the template to specify the image file locations. If no image is used in the report, then the directory can be passed with any value.
Report templates can be loaded from a remote site through a URL. To do this, simply get an input stream object from a URL and the builder will read the template information from the remote server pointed to by the URL:
URL url = new URL(“http://…”);
Builder builder = Builder.getBuilder(Builder.TEMPLATE, url.openStream());
ReportSheet report = builder.read(".");
The directory passed into the read() call is ignored in this case, so the template cannot use any local files for image elements.
Perhaps the most flexible way to import a template file is by loading the file in as a resource file. This allows the template files to be packaged as part of the application JAR file or together in the class file directory tree. Once the CLASSPATH is properly setup, resource files can be located by the Java class loader in the same way as other class files. This enables the templates to be used independent of the location of the installation.
InputStream input =
getClass().getResourceAsStream("/templates/report1.srt");
Builder builder =
Builder.getBuilder(Builder.TEMPLATE, input);
ReportSheet report = builder.read(".");
More Articles About Reporting
BI in Credit Operations - Operational business intelligence for a Credit Operations Analyst involves using data and analytics to gain insights and improve the efficiency and effectiveness of credit-related operations within an organization. Here are some examples of operational business intelligence initiatives that a Credit Operations Analyst may undertake: Credit Application Processing Time: Analyzing the time taken to process credit applications can help identify bottlenecks or inefficiencies in the credit approval process. By tracking and measuring the processing time, the analyst can identify areas where the process can be streamlined, such as automating certain steps, reallocating resources, or improving communication channels...
Converged Insight Becomes Critical - At the end of the day converged insight becomes critical, and by converged insight we mean the convergence of data which you are currently holding perhaps with the addition of weather data, location data, data in context, external data, open data, multiple sources of relevant data all pulled together via an analytical fata mashup solution like InetSoft's to help transform enterprise wide decision making. Another interesting comment recently was that that 50% of business leaders think that their existing business model will be out of date within five years, and I wondered about the other 50%. Maybe in five years if they don't change perhaps they won't be in business...
Corporate Knowledge Assets - Afterwards we'll talk about proactive performance management because linking corporate performance management with knowledge management is a proactive approach to improving corporate performance management. I'm also going to talk about the aligning that performance management initiatives have with those corporate knowledge assets and then talk about an example that we use inside of TFI Consulting. So to start it off, a lot of corporate performance management initiatives, especially the smaller ones, are not quite as successful in the long term. They tend to focus on providing a control mechanism. A control mechanism...
How Reporting Software Can Integrate Artificial Intelligence - Automated Data Collection and Integration Overview: AI-powered reporting software can automate the process of data collection and integration from various sources such as databases, cloud services, APIs, and IoT devices. This automation eliminates manual data entry and ensures real-time data synchronization. Benefits: Efficiency: Reduces the time and effort required to gather data from multiple sources. Accuracy: Minimizes human errors in data entry, leading to more reliable reports. Real-time Updates: Ensures that reports are always based on the most current data, which is crucial for decision-making...
Options for Archive Reports - InetSoft's reporting software comes with extensive archive report options that are simple to incorporate in a matter of minutes. View the information below to learn more about the Style Intelligence solution. The following options are available for archived report on the 'Archive' page. The archive has the option 'Delete Removed Report Permanently'. If this option is chosen, then when a report is deleted, it is not placed in the trashcan but is permanently deleted from the system. The 'Archive Indexing' option is by default set to 'true'. When this option has been enabled, a report saved in the archive will be indexed for search capabilities. When this flag is set to 'false' the archive search will be disabled...
| Previous: Programming Reports |