Jasper reports server

PaperCut ships with a 3rd party reports engine called Jasper. Since PaperCut NG/MF version 19.1, it is possible to add custom created reports. PaperCut built-in reports have used the Jasper engine for some time now.PaperCut 19.1 adds the capability to run custom-written reports that are compatible with the Jasper engine.This guide provides a brief overview of the process of writing a custom report.We assume an understanding of SQL, and familiarity with the Jasper Studio report writing tool. It is also necessary to know which external database your organization uses, as SQL syntax varies slightly between the different RDBMS vendors.You need to have hooked up your PaperCut deployment to an external database.Jasper StudioJasper Studio Community Edition is a freeware product available from the Jaspersoft website. Download Jaspersoft Studio Community Edition version 6.x from: example report into Jasper StudioLet’s have a quick look at a report that was created by our tech services team.Run Jasper Studio. You should see a work screen similar to the one shown above.Click on the File tab and select “Open File” to bring up a file selection dialog box and load one of the example custom reports.The example reports are located here:\PaperCut MF\server\examples\reportsOr\PaperCut NG\server\examples\reportsNext, we’ll need to set our compatibility option. The instructions below outline the process for changing the settings globally, but this can also be done on a per-project basis by switching the radio button to Use Project Settings.Go to Project, PropertiesOn the left go to Jaspersoft Studio, CompatibilitySelect the Use Workspace Settings radio button, and click Configure Workspace Settings. In the new setting window, look for Version and select 6.20.6 from the dropdown list. (this may not be the current version)Now, we’re going to look at the custom_shared_account_pcsf_breakdown _report.There are three versions of each example report, each created to match a specific external database server.Choose the version of that report that matches your database server.Once you have loaded the report, you should see a work screen similar to the one shown above.This gives an idea of what a completed report will look like.If you click on the Source tab, you can browse the source code of the report.Create a new reportOk, now it’s time to create your own report. We’re going to go through the process of recreating the example report we looked at above.This report was based on an actual customer request. In essence it takes the built-in Shared account print/copy/scan/fax - breakdown report and adds the current balance of each account as well.We recommend keeping the example report open (in Jasper Studio you can have more than one report design open at once and easily switch between them) as a reference in case you have problems with any of the report creation

What is the JasperReportsIntegration?Related ProjectsDownloadInstallationSystem RequirementsQuickstartInstallationUpgradeIntegration and UsageConfigurationPL/SQL APIExternal Documentation / TrainingLegacy DocumentationChange Log / Release NotesCreditContributingLicenseFAQ/ TroubleshootingSupport / Forum What is the JasperReportsIntegration?JasperReportsIntegration provides an interface to use the JasperReports reporting engine in an Oracle database application, specifically with Oracle Application Express (Oracle APEX)."The JasperReports Library is the world's most popular open source reporting engine. It is entirely written in Java and it is able to use data coming from any kind of data source and produce pixel-perfect documents that can be viewed, printed or exported in a variety of document formats including HTML, PDF, Excel, OpenOffice and Word."The main purpose is to provide a cost free alternative for high-fidelity printing / PDF generation with Oracle APEX. This integration kit allows to run JasperReports reports from within your Oracle APEX application.How does it work?This integration approach focuses on the integration with Jasper Reports, but is not limited to it. Using a generic URL-based approach, it can easily be extended to call any other reporting engine that provides a URL based interface for running reports, for example Oracle Reports, BIRT or Crystal Reports.What are the parts of the integration?The integration kit consists of the following components:a J2EE application to call the specified report definition file, make a connection to the target database and return the generated reportThis J2EE application (jri.war) is deployed in a standard J2EE container.Also, all reports we want to use have to be copied to the J2EE server, so that they are accessible by the J2EE application. These Jasper Report definition files are usually created with the iReport designer or the newer Jaspersoft Studio, this is the most convenient way.Finally, we need to configure the JNDI datasources in the J2EE server (or the application.properties file) to connect to our Oracle databases.a PL/SQL interface which can you can use in your application (package XLIB_JASPERREPORTS)This package essentially takes the parameters and constructs a URL for the J2EE application. This URL is then passed to the J2EE application via UTL_HTTP. Once the report is run, it will return the report as a BLOB. This BLOB can be displayed immediately, stored

Using Reports JasperReports is a third-party application that works with your Windchill data to provide rich and flexible report options. You can choose to display reports in multiple output formats, such as HTML, PDF, CSV, and Microsoft Excel. Reports that use JasperReports implementation are displayed in the Reports table with the reporting system specified as JasperReports. Viewing a Report1. From the Reports table, click the report name or the view report icon , or select View Report from the right-click actions menu for the report that you want to view.Alternatively, from the report information page, select View Report from the Actions menu.2. In the find object pane in the displayed dialog box, specify the object for which you want to see the report, and click OK.The find object pane collapses, and the report for the selected object appears. The default format is HTML. You can change the format using the Action list. Use the First, Previous, Next, and Last links to navigate through the report. Open the collapsed pane to select a different object for the report.Importing and Exporting a ReportA Jasper report can be imported or exported the way you import or export other reports. For more information, see Exporting and Importing Windchill Reports.When you export a Jasper report, the supporting artifacts, such as compiled Jasper files, resource bundles, and images used in the report are also exported. However, any custom JSP files that are part of the codebase are not exported. These files must be manually copied into the target system.The given image shows the exported artifacts. The .jasper file is the compiled Jasper report schema and .properties files are the resource bundles for the supported localization languages. For example, Problem_Report_Summary_Report_ja.properties is a resource bundle corresponding to Japanese localized labels. JasperReports fetches data from data sources, such as Info*Engine tasks and report templates. Access permission restrictions affect the data returned by these data sources and presented by the JasperReports engine. For more information, see Security Configuration for Report Templates.Execution of Reports in the backgroundWith Windchill 12.0.1.0 release, you have the option to schedule and execute the long-running Jasper reports in the background. With this feature, you may choose to navigate away from the report execution window while the report is still executing in the background. On clicking Run In background, selection of any configured report format is possible. E-mail that has the link to the generated report will be send to you on your configured e-mail address. Acknowledgement message to confirm this action will be displayed after selecting the report format type.Default Font Rendering for Jasper ReportsFor report rendering, Windchill supports Noto Sans font family to generate any OOTB reports. You may be note that:• PTC support fonts