<aside> 💡 Users can Update a Query in order to add more fields or even additional views. The wizard cannot be used to do this without starting a new report.

</aside>

Welcome to the MoveHQ help center! We're here to answer your questions. Can't find what you're looking for? Send our support team an email at [email protected]

Updating an Existing Query 📖

  1. Open a report in the designer

    Untitled

  2. Click the Field List button on the Right side of the page

  3. Click the carrot on the report’s Data Source (the default name is sqlDataSource1)

  4. Click the carrot near the primary view to see the fields already available

  5. Click the Edit Query button on the same row

    Untitled

  6. This brings up the Data Source Wizard; click the Run Query Builder button

    Untitled

  7. Add any additional fields, views and joins then click OK

    Untitled

  8. Click the Finish button on the Data Source Wizard to save changes

    Untitled

  9. Additional fields are now available in the Field List

    Untitled