Understanding the Difference Between Reports and Queries

The Reports module contains two methods of extracting detailed information from the netFORUM Pro database: 

• Report Central
• Query Central

To understand when to use a report versus when to use a query, keep in mind these differences: 

• A query is a function or tool that pulls data or information from a database that is often organized and presented in a very loose fashion.  For example, netFORUM Pro presents the data in List format.  The query will not give totals for accounting data if searched for invoices or open order data for specific customers.  Rather, the query pulls up all of those invoices, by date, for each customer along with their contact information, if requested. 
• A report takes data or information from a database and places it into a useful or meaningful format which is often used for printing or presentations because it uses columns, headings, and so forth.  A report will also draw conclusions on the data such as totaling accounting data. 

Queries help filter large amounts of data into more manageable quantities. Reports present data in meaningful formats so that conclusions and information about the data can be more easily seen.  Queries are often used to put together reports so that information can be distributed to organizations.

It is important that the very first decision you make when using the Reports module in netFORUM Pro is to decide which function will provide you what you need: a report or query.