Article Details
Id:8353
Product:finPOWER Connect
Type:NEW
Version:1.03.00
Opened:22/11/2010
Closed:22/11/2010
Released:24/03/2011
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'