When we specified the datasource we made a point of not using data from the table columns. Had we done this and then reported on the table data, each entry (row) on the table would be considered as a separate instance; this could affect the results of existing reports.

We will now look at how we can report on the table data without affecting the existing reports. We manage this by creating a new datasource which includes the table data along with data from other fields on the form. We will also apply a global filter to this datasource so only open order lines will be shown.

1. From Report Properties and Datasources, create a new datasource. 2. Select the same Purchase Order form as the Datasource. 3. Name the datasource ‘Purchase Order Table’. 4. Select the following fields to report on: • Applicant • Department • Description • Quantity • Price • Value 5. Click Edit to open the Datasource Filter Editor and set a filter to include only instances at Manager or Director Approval stages, then click OK. 6. Add a Next page button to the bottom of the report. 7. Add a new page by clicking the New button in the Objects section of the Browser bar. 8. Copy graphics from Page 1 and paste onto the new page. 9. Add a Data List to the page near the bottom. 10. Select the Export Button check box. 11. From the Datasource drop-down, select Purchase Order Table. 12. Select the following fields: • Name (Applicant Name) • Description • Quantity • Price • Value 13. Specify suitable column widths. 14. Add a Page button to allow users to navigate to the previous page. 15. If you have some instances with two or more detail lines included in their tables, then you should see more lines in this new table than in the table on the first page.

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