3. Capturing SQL with MS Query
If you know of a query tool that generates SQL statements, you may consider using that tool to facilitate the writing of queries used in OpenRPT report definitions. Having an external query builder can help to accelerate the creation of report definitions. In this section we will look at an example of how this process works using one such query builder: Microsoft Query, which is a component of the Excel program.
Note
Using external query tools can be helpful, as OpenRPT does not currently have a native query builder.
