Used to locate raw values from other facilities (databases) into the report.

USING:

Use the facility pulldown list  to choose the facility. 

Pick your variables and move them () to the Variables list.

Click  to locate the data on the form.

 

BUTTONS:

	Use the variable browser to add vars to the list.
	Moves the selected variables from the variable list on the left to the Variables List on the right.
	Removes the currently selected variable from the list.
	Clear the list of variables.
	Moves the currently selected variable(s) up one row.  Variables will be places in columns in the order they appear on the list.
	Moves the currently selected variable(s) down one row.  Variables will be places in columns in the order they appear on the list.
	Closes the form and locates the data.
	Closes the form.

FIELDS:

Locate _____ Variables:  Choose the variable frequency (i.e. Daily, Hourly,etc...) you want to locate data for.  You can only locate variable's with the one frequency (i.e. you can locate daily vars or hourly vars but not both at the same time).

Display xx Values: Sets the number of days to display

Place Date beside Data: Places the corresponding date in the column next to the located data.

Date Format: Sets the format (ie 12/31/97, Dec 31, etc...) for the date column.  See Date Formats.

Use Date in Column: If the dates are already on the report, you can use the dates in the column specified (instead of placing the Date beside the data).  Uses the same row to find the date.  For example, if you locate data starting in F5 and select column B for the Date column, cell F5 will use the date in B5, cell F6 will use B6, etc...

NOTES:

Uses the SQLFIRST function to locate the data

Use STATZ function to summarize data from the other facilities that contain data qualifiers.