Note: The following instructions assumes familiarity with, and access to, database tables within Microsoft SQL Server Management Studio. Sage Customer Support does not assist with accessing or retrieving data. Knowledge of proper use of SQL queries is a must.

1. From the Sage 100 Premium (formerly MAS200 SQL) desktop, access the graphical report or form to be previewed
   (Example: Go to Sales Order, Main menu, Sales Order Printing, enter selection criteria, and click Preview.)
2. Keep the Crystal Reports Preview window open displaying the report. (Note: Closing the Preview window would cause the temporary work table for the report to be deleted.)
3. Access Microsoft SQL Server Management Studio for the SQL Server database where Sage 100 ERP Premium data is stored
4. Using Object Explorer, access the following location in the database: Databases, System Databases, tempdb, Temporary Tables
5. Look for the temporary work table created.
   (Example: "dbo.##SO_SalesOrderWrkUSRmmddhhhhhhhh" would be a temporary table, where "USR" is the User Code, "mmdd" is the month and day, and "hhhhhhhh" is the decimal representation of the hour, in this case, around 2:49pm)
6. Open a New Query and write a SQL query statement can be used to retrieve data.
   (Note: Use of the asterisk wildcard returns all values in the temporary table)
   (Example: SELECT * FROM tempdb.dbo.dbo.##SO_SalesOrderWrkUSR12311482058)