Command Tables

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 

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.

mceclip0.png

 

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

mceclip2.png

 

3. Creating Command Tables (3 Different Ways)

mceclip1.png

 

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)

mceclip0.png

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

mceclip3.png

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)

mceclip1.png

6. Verify Field Name

7. Verify Name

mceclip5.png

 

RS Import Method (Recommended)

1. Create new Command Table

2. Paste SQL Query into Command Table text area

3. Click RS Import

4. Verify the Datatype 

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

mceclip2.png

6. Verify Name

Have more questions? Submit a request

Comments