Retrieve the available data views and fields

1. Go to Reports.

2. Select the appropriate Report Category and Report Sub-Category.

3. Select the Custom Reports tab.

4. Select Add Custom Report.

5. Select the database icon and select NEW DATA.

6. Select Shared and select the Shared DataSource in the dropdown.

7. Select CONNECT.

8. Expand the dbo folder.

9. Expand the Views folder to list the available Sage Construction Management views.

10. Expand the views to list the available fields.

    For example, expand the vw_ProjectInfoSimple view to list its available fields.