The easiest way to do this is to simply re-run the report, placing check marks on the desired fields. Many people don’t think to do this because they don’t realize how quick and easy it is to create a report using MasterMine, or because someone else generated the report originally and they just “share” it, and may not be familiar with the fields included.

However, sometimes you’ve done so much work with a report that you’re not confident you can recreate it quickly. For these situations, there’s MSQuery–MS Excel’s back-end query management tool. Full instructions for using MSQuery for this purpose are in Chapter 10 of MasterMine’s user manual. MSQuery allows you to drag in additional fields from existing tables, link additional tables, and even modify the Transact-SQL expression by hand.

For those more familiar with Transact-SQL, here’s an additional trick that could save you hours and get you quickly to a solution: Get the approved MasterMine SQL syntax for any field from the MasterMine “Create” dialog, which you can then copy and paste into the SQL expression in MSQuery.

1. Start with the MasterMine report you want to change already open in Excel.
2. Go to MSQuery (Click the “Info” button on the MasterMine toolbar, click “Query Text”, “Modify Query”, “Back”, “Get Data”)
3. In MSQuery, click the “SQL” button on the toolbar to expose the SQL Expression.

Here, you could modify the SQL query by hand, OR you can use this handy trick:
1. Back in GoldMine, run the MasterMine “Create” dialog.
2. Select a report or template that has the same tables you are using in the existing report.
3. Click the “uncheck” button so that no fields are selected (except required ones).
4. Check on the names of fields you want to add to the existing report.
5. Click on the “SQL Query” menu item to expose the SQL statement as it would be if you ran the report now.
6. Copy the lines you need (field expressions) from the select statement.
7. Now go back to MSQuery and paste the SQL lines into your existing SQL statement, taking care to preserve proper syntax like terminating every field expression with a comma except the last one before the FROM clause, etc.