NEW1.03.00 · Released 24 March 2011
NEWfinPOWER Connect
Released in
1.03.00
24 March 2011
  1. Opened22 Nov 2010
  2. Closed22 Nov 2010
  3. Released24 Mar
Article 8353 Job J006676

Reports,Run Query;Ability to view datatables from Datasets that have multiple unlinked data tables

If a Query has a dataset that contains multiple datatables, and the datatables are not linked to each other, only the data in the main datatable could be viewed on the screen.

A new feature has been added so the user can view any datatable in the dataset.
If a dataset contains multiple tables then a dropdown of the datatable names will be displayed in the button control at the bottom of the grid. When a datatable is selected a new form will open displaying this datatable.

There are 2 ways to view this new feature:

1. Run the Account Control query.
Report, Run Query, AccountControl

Click on the 'View DataTable' button.

Select datatable 'SuspenseItems'

2. Preview the Account Control Report.
Report, Report Explorer, Account Control Report

Click the 'Export Report Data' button. The export data is displayed.

Click on the 'View DataTable' button.

Select datatable 'SuspenseItems'