Trouble viewing images? Click on images to enlarge.

What are Command Tables?

Command Tables are an effective way to both simplify a data source's structure and enable aggregate values to be included on detail results. When Command Tables are applied to a report they act as sub queries within the FROM clause of the VDM View.

Adding A New Command Table

1. Right Click on @CommandTables then click Add.

2. Enter the Name for the new Command Table. (NOTE: Follow Standard SQL Naming Conventions)

3. Creating Command Tables (see the 3 different methods below)

Method 1: Add Method (Not Recommended)

1. Copy your SQL query and paste it into the Command Table text area.

2. Click Add (Repeat for each field)

3. Set the Datatype

4. Set the Description (Optional: Displayed when viewing the Command Table fields)

5. Set the Name for the Field (This is the name that is returned in Command Table)

Method 2: Import Method

1. Open View with desired fields

2. Create a new Command Table

3. Click Import

4. Verify the Datatype

5. Set the Description(Optional: Displayed when viewing the Command Table fields)

6. Verify Field Name

7. Verify Name

Method 3: RS Import Method (Recommended)

1. Create new Command Table

2. Paste SQL Query into Command Table text area

3. Click RS Import