From Button

The From button has two options as the starting point of your Table/Report.

1. SQL Statement: Used to download data based on a SQL Statement.
2. Stored Procedure: Used to download data from a stored procedure.

SQL Statement

Field	Description
Search Tables	Use this to filter the list of Tables.
Tables	This list displays available tables to use as your base table.
Selected Table	This is the table selected as your base table for your data.
Alias	An alias gives the Selected Table an alternate name to make it more readable such as Jobs instead of JCJM
Mimic Table	This is the table used for all Actions other than Download.
Activate Mimic Feature	If checked then all Actions other than Download will use the Mimic Table instead of Selected Table.

Button	Description
	Clears the search box and refreshes the Tables.
	This will save any changes to the From portion of the SQL Statement.
	This will cancel any changes to the From portion of the SQL Statement.

Stored Procedure

Field	Description
Stored Procedure	Contains the stored procedure used in the report.
Parameters	This lists all parameters associated with the stored procedure.
Search Columns	Use this to filter the list of Table Columns.
Selected Parameter	This is the selected parameter that you will associate with a column.
Parameter Column	This is the column that will be used to format your parameter values when downloading the report.
Table Columns	This lists all columns you can associate to the parameter for formatting purposes.

Button	Description
	This pulls all parameters associated with the Stored Procedure. This will also handle new or deleted parameters.
	Clears the search box and refreshes the Table Columns.
	This will save the Selected Parameter and Parameter Column combination.
	This will clear all fields on the form.
	This will save any changes to the Select portion of the SQL Statement.
	This will cancel any changes to the Select portion of the SQL Statement.

Feedback