OP Reports Tutorials

a guide for the fearless
Module 1
Module 2

Databases

  1. Database Basics (15 minutes)
  2. Data Dictionary (30 minutes)
  3. More on Tables (20 minutes)
Module 3

A Very Gentle Introduction to SQL

  1. A Gentle Guide to SQL (30 minutes)
Module 4

The OP Reports Interface

  1. Creating OP Reports (30 minutes)
  2. Data Tabs (20 minutes)
  3. More on Tables (20 minutes)
  4. Delving into the OP Reports Interface (20 minutes)
  5. Organization and Layout: Part 2 (30 minutes)
Module 5

Example Reports

  1. Walkthrough Example #1: Find BMIs and the Correct Z-Code to Maximize P4P Revenue
  2. Walkthrough Example #2: Mass Creation of Patient Forms
  3. Walkthrough Example #3: Making a School Allergy Form
Module 6

Other Lessons

  1. Guide to the PHYSICAL Table
  2. Guide to caps and mixed caps
  3. Working with dates

Video Lessons

OP Reports Navigation Basics: Finding reports and folders in OP Reports; moving and renaming reports; running and editing reports.

OP Reports Quickstart: In under 2 1/2 minutes, create a simple report of your active patients, showing their patient chart number, first name, and last name.

Direct SQL Editing: Rather than using the visual design tabs to create your OP query, enter the SQL as text directly. Copy your entire SQL and export it for troubleshooting.