Authoring Jasper ReportTemplate
This stage involves preparation of ReportTemplate Data Source in Windchill.
1. Authoring ReportTemplate:
a. Create a ReportTemplate or use an existing ReportTemplate.
b. Make sure that ReportTemplate is executed through ReportBuilder without any error.
c. For this section, consider the sample ReportTemplate named PartReportTemplate from site container which selects Name, Number, State, Branch Identifier, and Created columns from WTPart table.
2. Exporting ReportTemplate Data Source:
a. Execute the following command from Windchill shell to export the ReportTemplate data and other artifacts which are needed for Jasper Studio consumption.
windchill com.ptc.util.wbr.export.ExportDataSource reportTemplate -u <username> -p <password> -r 25, where -r specifies the number of data rows to be exposed as part of jar, default value is 10.
On executing the command, the following occurs:
▪ Exports all the existing ReportTemplate objects that are accessible to xyz user with password abc.
▪ Exports ReportTemplate data to XML files which are packaged in datasetddMMyyyyHHmmss.jar located at <WT_HOME>/tmp for Linux and <WT_HOME>\temp for Windows.
▪ Generates one java class for new or existing ReportTemplate in com/ptc/wbr/datasource/providers folder located in jar file. The name of class is the same as the name of the ReportTemplate, however all special characters and white space are replaced with underscore ( _ ). Every class is suffixed by WNCProvider keyword to uniquely identify the classes inside Jasper Studio.
b. This jar is distributed to the host where Jasper Studio is installed.