Reports may also contain data lists. We will add one to the report to show the individual instance details. The data list will respect dynamic filters, but we will not allow the list to be used as a drill-down filter.

1. Add a Data List object onto the page, re-size and position near the foot of the page, leaving room for navigation buttons. 2. In the Data List Properties under the Display section, select the Export Button check box. This will allow the user to export the data from the table in CSV or XML format. 3. In the Columns section, click the Add Column button five times. 4. Select each column in turn and specify the following settings (see screenshot below): Column 1: • Caption = Applicant (mouse click in Caption box to change) • Field = Applicant Name (selected in the drop down) • Width = 100 px 5. Repeat the above for: • Column 2 = Department • Column 3 = Last Update (Use Last Submission Date), Sort select Descending • Column 4 = Total • Column 5 = Stage 6. Ensure that the Can Set Dynamic Filter check box is cleared. 7. Modify column widths accordingly. If the combined column widths are less than the total width of the Data List object the last column will expand to take the remain width. 8. Preview the report to see how it looks and how the filters work.

Updated: 6/6/2011  Page url: http://www.perfectforms.com/Documentation/complete_tutorial/html/?r_add_a_data_list.htm
PerfectForms™ -- forms software, workflow software, and business process management