How to create your own reports

You need BIRT

At first you need the BIRT designer. Is is recommended to use the release 2.3.1. You can get it there : http://www.eclipse.org/downloads/download.php?file=/birt/downloads/drops/R-R1-2_3_1-200809221151/birt-report-designer-all-in-one-2_3_1.zip

Create your report

A BIRT report for Appspy is just a BIRT report. You can learn about BIRT here : http://www.eclipse.org/birt.

  1. Create a new BIRT report with the BIRT designer.
  2. Define the datasource. Enter "java:comp/env/jdbc/appspyds" as JNDI Name for the datasource. The other properties are optional, but very useful to test your report in the BIRT design environment.

    Birt Datasource configuration :

    BIRT Datasource configuration
  3. Define your report parameters.

    The parameters :

    The parameters

    Detail of a parameter :

    Detail of a parameter
  4. Create your data set(s)

    The datasets :

    The datasets

    Choose the datasource :

    The dataset datasource

    Add the parameters :

    The dataset parameters

    Set the SQL Query :

    The dataset query
  5. Create your report elements (a chart for instance)

    Insert a chart for instance :

    Chart design
  6. (Optional) Test it in your BIRT design environment.

    Start the preview :

    Launch the preview

    Is it what you want ?

    Here is the preview

    Change the parameters :

    Change the parameters
  7. Create the report in the Appspy administration application

    Use the administration application to create the report, add the parameters and upload the BIRT report file :

    Create the report in the administration application