To XML

To export the results of a report to an XML format file, follow the steps below:

1. In JReport Designer, open the web report or the report tab in a page report that you want to export.
2. On the report tab bar, click the report tab.
3. Click File > Export To > XML to bring out the Export to XML dialog. See the dialog.

   

4. Specify the destination of the exported file in the Export to field box.
5. In the Schema File Name field, specify an XSD file to export the web report or report tab to an XML file based on the specified XSD file.
6. Check the Only Data checkbox to only export data of the web report or report tab.
7. Check Run Linked Report if you want to include the linked reports in the exported XML result.
8. When done, click the OK button, and a file with the extension .xml will be generated.

See also Export to XML dialog for detailed explanation about options in this dialog.

The following are some notes you should be aware of when exporting report results to XML:

• The existing schema file that you specify must also be generated from the web report or report tab. If you use other schema files, a NullPointerException exception will be thrown out.
• If the existing schema file that you specify contains only data, and you have cleared the Only Data checkbox in the Export to XML dialog, the exported XML file will then only contain database column information. The content of the exported XML file will be consistent with the schema file it is based on.
• If you delete an element node or an attribute node from the existing schema file, the exported XML file which is based on it, will not contain the corresponding column. In a not only data schema file, only the removal of an element used in a formula control property will affect an exported XML file which is based on it.

  Example: Deleting an element node from a schema file affects the exported XML file which is based on it

  Let's take EmployeeInformation.cls as an example.

  1. Click File > Open on the menu bar.
  2. In the Open Report dialog, click the Browse button to open the catalog file SampleReports.cat in <install_root>\Demo\Reports\SampleReports, then open the sample report EmployeeInformation.cls.
  3. Export EmployeeInformation.cls to an XML file. You will then get two files: EmployeeInformation_report1.xml and EmployeeInformation_report1.xsd.
  4. Open the EmployeeInformation_report1.xsd file, and delete EmoloyeeInformation_report1_ReportBody_PagePanel_PageHeaderPanel_ label3 from EmoloyeeInformation_report1_ReportBody_PagePanel_PageHeaderPanel.
  5. Export EmployeeInformation.cls to an XML file again. This time, specify the modified EmployeeInformation_report1.xsd as the file to base it on.

     The newly exported EmployeeInformation_report1.xml file will not contain information about EmoloyeeInformation_report1_ReportBody_PagePanel_PageHeaderPanel_ label3.

• If you do not want to see all the property values in a generated XML file, you can comment out any unwanted properties in this way:
  1. Open the file JRXMLTag.properties located in resource.jar in <install_root>\lib.
  2. Add a question mark in front of any unwanted properties to comment them out. See below:

     Change: Suppressed=Suppressed

     To: ?Suppressed=Suppressed

  3. When you export the web report or report tab to XML, the exported XML file will not contain the property Suppressed for each report object.
  4. Save the property file and refresh the one in resource.jar.

     In addition, when you uncheck Only Data, and add an @ sign in front of the value in JRXMLTag.properties, the property listed in the Element node will then move to the Attribute node.

     For example, in JRXMLTag.properties,

     Change: StartYPos=StartYPos

     To: StartYPos=@StartYPos

     You will now find that the StartYPos property is now listed in the Attribute node.

     Before adding the @ sign in front of the value, the StartYPos property will have been listed in the Element node.