Making It Happen
Accounting and Information Technology, Assistance and Support
Sage 50 - "Who has had what report" example Excel linked worksheet

Creating a who has had what pivot table analysis

You may need to install Sage ODBC second install the MSQuery component of MSOffice - these are already installed in modern versions of Sage 50 and MS Office

click image for full size view

Download the Excel spreadsheet (if using Internet explorer right click and chose save target as)

When you open it you will see notes on how it works and how to do the ODBC link

These sheets are provided without warranty, support or anything else, it is really for you to use as a learning tool so that you can create your own.