Introduction

In this chapter we will discuss the advanced functions available to you via The Scoop™. This includes advanced data formatting, formulas, SQL Queries and scripting.

This guide is intended to be a primer, and is not intended to be comprehensive. We do not provide free tech support to teach you to use SQL or the programming languages built into The Scoop™. If you want to learn to do advanced things, you need to consult with an expert and or take classes in programming and data management.

We do mark all data accessed by The Scoop as “read only,” but you are expected to ONLY use the SQL Select statement in the Scoop. We do not warrant data integrity or the accuracy of any report, since you determine both things by the way you use the program.