A new way to replicate GP Macros

Learn More at this Link

Replicator makes mapping macro data columns a breeze!

Dynamics CON Live, Spring 2024

Database and Queries and SQL, OH MY... Demystified!

Download slide deck and final query

How to get data out of your MS SQL Database

Community Summit NA, Fall 2023

Deep Dive into Excel Refreshable Reports, SQL Views, GP Macros and Replicator

Download PowerPoint

Put the Pedal to the Metal with GP, Excel Tables, Database Queries, and Macros

Dynamics CON Live, Spring 2023

SQL Tips and Tricks!

Download PowerPoint

Tips and tricks for Microsoft SQL Management Studio (SSMS)


GPUG - Excel Tables Rock!

Download PowerPoint

An inviting tutorial of how to benefit from the powerful nature of Excel tables

Refreshable Report Template

Simplify generation of refreshable reports

Download Excel File

A template for quickly generating Excel refreshable reports with up to 3 parameters

Query String Finder

Efficiently mine Excel refreshable report queries

Download Excel File

An macro enabled Excel spreadsheet that shows you the database connection information for all Excel Refreshables reports in a directory