Reporting and Analysis
for GoldMine CRM and QuoteWerks quote management
Support Center > Knowledge base> Article: Modify Query

Modify Query

Article ID: 31885

How to modify the underlying query in a MasterMine report


Working with Edit Query textbox

If you are familiar with Transact-SQL, the easiest way to modify the query behind your pivot table is to click on the table, then on the MMTools ribbon click “Edit Query”. This opens a text box within which you can modify the query.

When finished, click “Test” to do a test-run of the modified query.  If an error is generated, make appropriate changes before testing again, or give up by clicking “Cancel”. Once you have a “Query Successful” result from testing, you can click “Save” to lock in the new query.  Don’t forget to save the workbook before exiting to keep the new query in effect.

related articles

Article Details
Views: 748 Created on: Dec 12, 2016

Please let us know what you think of this article.