In this example, we want to get a list of customers who did not place orders between January 1, 1998 and January 1, 1999. So, we need to create a query to get a list of customers.
To create a query to get a list of customers:
Select Tabular Report on the main SQR Production Reporting Studio screen and connect to a database.
On the Query Builder - Tables page, select CUSTOMERS.
On the Query Builder - Fields page, select NAME, STATE, and PHONE.
To create a query to get a list of customers: