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.
| ||
Last name | First name | City |
Bowen | Michelle | Albany |
Clark | Michael | Albany |
| ||
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 |