Help Center
Having Trouble? We are here to help.
Call: 1-855-ASU-5080 (1-855-278-5080)

Use a blank query (Hy11)

Last Updated:  1/28/13 8:36:38 PM 8373-8193-7550

"Blank" queries provide a connection to a set of tables that can be used to build your own queries. To use a blank query, save a copy of the blank query provided in your user folder. Use the copy as the starting point for your own query development.

To save a blank query to your personal user folder:

  1. After opening the blank query, click File >Save to Repository As....

  2. Navigate to your user folder by clicking on the drop down control of the “Look in” field.
  3. Select the Root folder, then the Users folder and then the first initial of your last name to locate your user folder.

  4. Make sure your name appears in the “Look in:” field and then click on Save.
  5. Once the report is saved, close the browser window displaying the query. This should take you back to the main Explorer workspace.
  6. Once back at the Explorer workspace, navigate to your user folder and double click on the report to open it.
  7. Click on Query from the Sections window.

  8. Next, click the "+" next to Tables in the Elements window to expand the table list.

  9. From the Elements window, desired table(s)* can then be dragged into the empty workspace on the right.
    *Note: If you plan on using more than one table, you'll need to disable auto-join first.  

Creating reports from scratch can present a challenge due to the amount of tables available and the structure (such as effective dated entries) within the tables. As a result, please check the existing prebuilt reports before starting a report from scratch. A majority of times the existing prebuilts can be tweaked to meet your reporting needs.

Improve the Help Center. Provide Feedback.
Did this article resolve your issue? *