When you invest in Crystal Reports for GoldMine not only do you get 49 ready-to-use to Crystal Reports for your edition of GoldMine (Corporate 6.7, Corporate 7.0, Corporate 7.5 or Premium 8.x) but I’ll also release BONUS reports from time to time that you’ll be able to get at no additional charge.
History Report by User With Stacked Bar Graph. (Click on the image for a larger version)
In GoldMine 6.0 and above, you have the ability to customize the columns you see in the Contact Search Center. The Contact Search Center is simply the formal name of the window that pops up when you are trying to find a contact…. Here it is:
It should look familiar. By default, you will see the Company, Contact, City and Phone1 fields. However, this can be changed! In the Contact Search Center toolbar (The icons just above “Lookup”) all the way to the right you’ll see an icon that looks almost like an Excel spreadsheet in GoldMine Standard or Corporate, in GoldMine Premium click the columns button.
Click it, and a window like this will pop up:
Too add a column simply find the column on the left, they are in alphabetical order, and double-click on it, or single click on it and use the right-arrow button. It’ll then move to the right-side of the screen. The order of the columns can be changed by clicking on a field on the right and using the up or down buttons.
Click “OK” and you’ll see your Contact Search Center with your customized fields. Any field from the top half of the screen, the summary tab, or the fields tab can be added. Also, the column widths can be adjusted in the Contract Search Center by dragging the dividers between the column headers, just like in Excel.
Note: In GoldMine Premium Edition 8.5 and above the Email and Web Site fields CAN be added! This is a very nice and welcome addition to the product. They cannot in versions of GoldMine below 8.5.
When you change the columns you see or their widths this is a ‘Sticky’ setting. So once it’s set it does not change when you Exit GoldMine, close the Search Center, etc. Also, it affects only you, no one else.
So you click on the link and ‘Accept’ the disclaimer and then copy and paste your SQL code onto the page.
Click Format and you’ll see a much more readable SQL Query.
Now, the results are not going to be any different, but you’ve got much better code for reading, debugging, etc.
Hope you enjoy as much as I do. I’ll be running all my future SQL Query tips through this!