Download User Manual - MasterMine Software

Transcript
PivotTable Options See PivotTable formatting
Pop Record ........................................................79
Preferences .................................................. 34, 37
Preserve Formatting ...................................... 107
Profile field
as Date ...........................................................37
as Numeric ...................................................37
profiles ............................................................. 137
Profiles ...............................................................45
Purge ...................................................................81
Purge Selected Field..........................................75
Record Type or View .......................................53
Refresh ......................................................... 67, 81
Refresh on open ......................................... 70, 87
Refresh Query............... 15, 58, 81, 98, 108, 134
periodic ................................................ 108, 134
Refreshing Reports ........................................ 121
Report ................................................................61
Report Builder Templates ...........................49
Requirements
hardware .........................................................22
knowledge .......................................................14
memory ..............................................22, 50, 58
software...........................................................22
RollUp/RollDown ............................................76
Row Area ................................................... 64, 177
Sales Manager’s Toolkit ...............................49
Save Data with Table Layout ....................... 108
Save report without data ........................... 71, 87
Save SQL password ......... 27, 41, 71, 85, 86, 87
Schedule printing ....................................... 71, 88
Search.............................................................. 104
Search Field Content ........................................75
Security ........................................... 23, 27, 69, 86
select report criteria ....................................... 141
Selecting Fields ............................................... 123
Selecting Reports ...................................... 50, 144
Setup ...................................................................24
Share Report ......................................................70
ShortRef..............................................................38
Show GoldMine Database names ..................54
Show Pages ..................................................... 134
Show Stats ..........................................................74
snapshot..............................................................88
Snapshot .............................................................71
Sort Columns .....................................................80
Sort Fields ..........................................................53
Sort fields for drilldown ...................................53
Sort unselected fields ........................................54
Sorting ...............................................................99
SQL expressions ............................................ 125
SQL Installation ................................................26
Hide unused filters ........................................... 69
How to deploy a report .............................70, 87
How to...
add fields to an existing query .................. 125
add MasterMine users .................................. 34
add/remove subtotals ................................ 110
create a MasterMine report ......................... 43
drill down for detail .................................... 111
manage existing reports .................... 121, 133
refresh data in an existing report ...... 81, 108,
121, 134
troubleshoot reports ................................ 133
Installation ...................................................21, 24
Multiple ....................................................29, 30
Integration of non-GoldMine data . 15, 19, 123
Items Per Field ................................................ 177
joins .................................................................... 46
Joins ......................................................... 127, 134
Label ................................................................ 109
Large File Handling ...... See Memory: managing
usage
Launch Dialog ................................................... 34
Licensing ......................................................21, 24
limit query size .................................................. 57
Line Listing ................................................... 111
MasterMine Drilldown Ribbon ...................... 78
MasterMine Ribbon ......................................... 67
Memory
managing usage .................................... 50, 134
Menu Launch .................................................... 34
MMTools Ribbon ............................................. 72
MMUpdater ....................................................... 79
MS Office installation ...................................... 22
MS Office® ........................................................ 22
MS Query®.......................................... 83, 86, 123
Notes ....................................................... 110, 169
Number formats ............................................... 78
Numeric data ...............................................28, 37
Numeric Range ................................................. 78
Open MasterMine Report… ................. 43, 143
Open Report ..................................................... 72
Optimize Column Widths ............................... 68
Page Area .................................................. 64, 107
Page Filters ...................................................... 97
Page Layout ..................................................... 108
Page setup .......................................................... 69
PivotTable
formatting ...................... 68, 83, 107, 134, 139
functionality ................................................... 63
limitations ..................................................... 175
memory usage....................................... 23, 175
preferences .................................................... 107
179