Microsoft SQL views of Pivoted Datasheets
Reported: January 31, 2017.
Version(s) affected: DataSight 3.0 and 3.1.
Issue: Microsoft SQL views of pivoted datasheets are not saved in pivoted tables. Linking the views to other software products such as Microsoft Excel, then does not produce the desired pivoted tabulation.
Workaround: Save the pivoted datasheets inside DataSight. Then, set up tasks to export .csv, .xls or .xlsx files out to locations on the device or network. The exported files will present your data in pivoted tables.
Unfortunately, we are unable to advise a workaround for this issue with other software products. Please consider upgrading to the next available release with a fix.
Resolution: Fixed in DataSight 3.2.
Last Updated: June 23, 2017.
Related Articles
Pivoted Datasheets
Pivoted datasheets allow you to view data in a spreadsheet or grid layout, with the variable headings at the top of the spreadsheet and the data for each site and datetime stamp below in rows. You may be familiar with this grid layout from Version 1 ...
Microsoft SQL Server Privileges
Administrators need to be aware of the how Microsoft SQL Server privileges for users are managed within DataSight. We can group DataSight users or administrators into four different categories. User Category Limited User Standard User Advanced User ...
Video: Pivoted Datasheets
This video provides a basic overview of pivoted datasheets in DataSight.
Microsoft SQL Server
Microsoft® SQL Server™ (herein abbreviated as MS SQL Server) is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. Note The on-premise DataSight software offering does not include Microsoft SQL ...
Saved Views
Datasheets, charts and reports may be created and then subsequently saved to the Saved Views Panel. This panel displays a tree list of all the saved views for the current database, each distinguished by a saved datasheet, saved chart or saved report ...