User-defined reports

EC Gateway supports ODBC user-defined reports.

To display a user-defined report:

Click the Report icon. The list of available reports displays.
Click the New icon on the Menu bar.
The Report window displays with its General tab active.

Enter the appropriate information in the fields listed in Table 3-1.

**Table 3-1: User-defined reports**
Field	Description
Report File	Enter the full path of the report file, or use the Browse button to locate the report.
Title	Enter a title for this report.
Number of Tables	Select the number of tables included in your report. It should be the same as the number of tables already used in your report.
Number of Parameters	(optional) Select the number of parameters used in your report.

Click the Tables tab.
Click Add.
The User Report Table window displays.

Enter the information, then click OK. Repeat this step for each table that exists in your report. The tables must be defined in the same order as they are used in your report.

You cannot add more tables than the number you chose on the General tab of the Report window.

**Table 3-2: User Report Table**
Field	Description
Data Source Name	Enter the data source name (DSN) for the table that will provide the information for your report. Alternatively, you can use the Browse button to locate your DSN.
User ID	Enter the user ID that is needed to access the database.
Password	Enter the password (if required) to access the database.
Table Name	Enter the name of the table in the database that will be accessed for the information.

When you have finished step 9, the Tables tab display of the Report window is filled with the information that you entered using the User Report Table window.
If you want a table without user-controlled parameters, click OK at the bottom of the Report window to end your report definition. Otherwise, go to the next step.
Click the Parameters tab.
Click Add.
Enter a parameter name and click OK. This parameter must already exist. Each reader of your report can insert specific values into this parameter to set the scope of the report.
Repeat steps 12 and 13 for each parameter you want to add to your report. The parameter names must be defined in the same order used in the report. You cannot add more parameters than the number of parameters that you chose on the General tab of the Report window.
When you finish adding parameters, click OK. Your report is added to the list of reports displayed by the EC Gateway Operations Viewer.

You can access your report at any time by double-clicking its listing. When you do this, a window displays asking for the value or values for the parameters you established for your report. Follow this procedure to display your report:

Double-click the title of a report on the listing of reports. A Parameters window displays.
Enter a value for each parameter.
Click OK. The selected report displays with its scope set by the specific parameter values entered.

In this example, a user-defined report prompts for the values of a starting date and an ending date. Enter valid values and click OK. The report displays covering the range entered for the parameters. The parameters used are not restricted to starting and ending dates.

If no parameters are defined here, but your report uses parameters, the report itself displays windows that prompt for the parameter values.