Page Comparison

You can make simple, single-list queries to view the results returned on screen. These on-screen queries can be exported to a file format, for example Microsoft Excel, to be manipulated outside of ShareVision. In the list-view of any selected list or library, an Administrator User or a Staff User with permitted security privileges can create a 'View'. This view can be configured with various parameters to perform and display the results of a simple query on the list data. Parameters include; filtering on values with and/or statements, grouping, sorting and basic math operations.

See: Create a New View

See: List/Library Settings - Views

Once a view (onscreen query) is created, the results can be exported from ShareVision to be manipulated or reported on using other applications. The data is exported initially in a file format called Internet Inquiry (IQY) which is saved to your computer and can be opened in Microsoft Excel. Once open in Excel the file can be saved as an Excel workbook. Note that the IQY file still has a connection to the original, source list and changes made to data in the IQY file will be written to the list in your ShareVision site. Saving the IQY file as an Excel Workbook removes this connection such that changes made in the Excel file will not be reflected on your ShareVision site. Data in the Excel file can be manipulated and imported into other applications.

Where the list view query parameters do not offer enough functionality, Report outputs can perform additional query operations and charting of data. Reports can also perform multi-list queries, combining data from multiple source lists. Reports can be developed through consultation with your Product Expert.