Collapse AllExpand All

4. Report Definition

Now that we have a working query for our report, we will create the report's definition. Again, you learned how to do this in previous chapters of this user guide.

Note

The report definition we will be building introduces the group section concept, which was not covered in depth in previous chapters.

We will begin by running OpenRPT. Note that OpenRPT opens automatically. It does not require authentication to a database. Unless your report definition resides in a PostgreSQL database (such as xTuple), you will save the reports locally as XML definition files.

First let's define our report's properties. Then we will create our query source with the SQL we validated using the MetaSQL editor. Next we will use the section editor to create our report's sections. Then we will define the report's parameters (we will use the ones tested with the MetaSQL editor and embedded in our query). Finally, we will save our report to the XML definition file.