Define Data Fetcher

Data Fetcher refers to a set of sequential query rules, it can fetch qualified data or records from variously joined data tables. It would return the results to the corresponded table cells according to default or customized filling criteria.

Data Fetcher could make ExcelServer templates to use any report data or records freely within the information system.

For example:

Select Data From <Employee_Main> Where:
<Data Filter:Employee_Main.EmployeeID = thisReport.Sheet1:EmployeeID>
Filling Into <EmployeeDetails_Main>:
Employee_Main.FirstName --->(Set Value) FirstName
Employee_Main.LastName --->(Set Value) LastName
Employee_Main.DepartmentID --->(Set Value) DepartmentID
Employee_Main.DepartmentName --->(Set Value) DepartmentName

A 'Data Fetcher' includes 3 parts:

1. Data source (Selection)

2. Filter condition (settings)

3. Filling methods (selection)

Steps:

1. Open a template

    (1) Open MS Excel;

    (2) Open "ExcelServer" menu,click "Connect..", input " Server Name", "User Name", "Password";

2. Define Data Fields (Single Field, Multiple Field)

3. New (Data) Table

4. From 'Template', open "Data Fetcher", or, right click your mouse, select 'Data Fetcher' from the menu Define Data Fetcher

General (information):

Name - Data Fetcher name

Fire patterns:

• (Firing) Manually - Data Fetchers manually fire (execute) when their requirements are met.
• (Firing) Automatically - Data Fetchers fire (execute) automatically when associated fields values are changing.