Manually configuring BIRT Reports for the application server

To use BIRT reports, update them with the web application server settings.

Before using the BIRT Viewer application to see predefined reports, edit them to adjust the reports database settings, and then copy the reports to a specific folder on the application server.

1. Go to the MPF Server installation folder created by the IBM Installation Manager.

2. Locate the \report-templates\ folder, which contains a set of .rptdesign files.

3. Copy all of the files with the .rptdesign extension from the \report-templates\ folder to the server web applications folder.

4. Edit each .rptdesign file as needed and adjust the <data-sources> element with the properties of the reports database.

   <data-sources>
     <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" ...>
       <list-property name="privateDriverProperties">
         <ex-property>
           <name>metadataBidiFormatStr</name>
           <value>ILYNN</value>
         </ex-property>
         <ex-property>
           <name>disabledMetadataBidiFormatStr</name>
         </ex-property>
         <ex-property>
           <name>contentBidiFormatStr</name>
           <value>ILYN</value>
         </ex-property>
         <ex-prperty>
           <name>disabledContentBidiFormatStr</name>
         </ex-property>
       </list-property>
       <property name="odaDriverClass">WLREPORT_DRIVER_CLASS</property>
       <property name="odaURL">WLREPORT_JDBC_URI</property>
       <property name="odaUser">WLREPORT_DBUSERNAME</property>
       <encrypted-property name="odaPassword" encryptionID="base64">
         WLREPORT_DBPASSWORD_BASE64
       </encrypted-property>
     </oda-data-source>
   </data-sources>

5. Make sure that BIRT Viewer application is installed and running on the application server

6. To view or edit a BIRT Report, go to the path http://your-server/birt/frameset?__report=[report name].rptdesign., where [report name].rtpdesign represents one of the following files:

   • report_active_users.rptdesign

   • report_daily_hits.rptdesign

   • report_daily_visits.rptdesign

   • report_environment_usage.rptdesign

   • report_license_total_device_count.rptdesign

   • report_new_devices.rptdesign

   • report_notification_messages_per_day.rptdesign

   • report_notification_messages_per_source.rptdesign

Parent topic: Reports database