||
Skip to end of metadata
Go to start of metadata

You can  generate a table report from a preferred datasource added to the WSO2 server. You can select the datasource, field names of the table, formatting of the table design, etc, with a few steps, and get the data in a table report. A sample table report is as follows.

example table report

Following sections explain how you can generate a table report in WSO2 BAM. 

Prerequisites

Run the KPI sample, which is shipped with WSO2 BAM to get sample data to generate the report. For instructions on running the KPI sample, see Monitoring key Performance Indicators.

Adding the Datasource

Follow the steps below to create a datasource to retrieve data from the H2 database table, which creates when the KPI sample was executed. For more information on datasources, see Datasources.

If you have already added a datasource, skip this section and move to the next section.

  1. Log in to WSO2 BAM management console, and click Configure.
  2. Click Datasources, and then click Add Data Source as shown below.
    click Add Data Source
  3. Enter the details about the datsource of the KPI sample as follows.
    enter new datasource details
  4. Click Test Connection, to validate the connection.
  5. If the connection is successful, click Save to add the datasource to the WSO2 server.

Adding the report

Follow the steps below to create the table report.

  1. Log in to WSO2 BAM management console, and click Tools.
  2. Click Add in the Reports menu, and then click Table Report.
  3. Enter the details of the database and the table for which, you generate the report as follows. 
    step 1 of generating the table report
  4. Click Next.
  5. Enter the report formatting details as follows.
    enter report formatting details
  6. Click Create. This displays the list of available reports.

Generating the report

Follow the steps below to generate the table report.

  1. Log in to WSO2 BAM management console, and click Tools.
  2. Click List in the Reports menu.
  3. Click on the name of the created report in the list of available reports.
  4. Select PDF for the Report Type, and click Generate.
  5. To download the report as a PDF file, click Save File on the pop-up screen as shown below, and then click OK.
    save and download the report as a PDF file.
  6. Open the saved PDF file to view the generated report as follows.
    generated table report output
  • No labels