Report Options

On this page you can select an index if the data source is a dBASE table. You can also enable a report group, define a filter and create a drill down report.

Index can be used with dbf files only. If you use a SQL file you must include the sql order by clause in the sql statement.

Filter. Enable the report filter to create a Query and Response application. You must select the field to use in the filter from the "Field to filter on" combobox. This is the field whose value must match the query value passed by the user. Web Reports uses a rowset filter to constrain data. (The dBASE Web Wizard uses the SQL WHERE clause to do this.) The filter option is set to match partial length and ignore the case.

Group By. The group heading is based on the same field that determines the sort order. If you use an index, the group by field must be the same as the index field. If the index is a compound index, the group by field must be the same as the first key of the compound index. If you use a SQL file with an order by clause, the group by field must be the same as the first order by field.

 
Albany

Last name First name City
Bowen Michelle Albany
Clark Michael Albany

 
San Jose

Last name First name City
Anderson Mark San Jose

Drill down reports. The command is the name of cgi application that is called by the hyper link in a drill down report. Following the convention of the dBASE Web Wizard, the name of the cgi variable passed to this application is "SEARCH". You must select the field name that contains the value to lookup the corresponding record.

Last name First name City
Anderson Mark St. Louise
Bowen Michelle San Jose
Clark Michael Albany