Product: Aqua Data Studio

Version: 19.0.0-dev-5

Build #: 53676

Build Date: 2017-Mar-23 09:10:38 PM

 

Operating Environment: Linux (4.4.0-42-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_102-b14

Memory: Max=704,643,072; Total=501,219,328; Free=295,195,280; CPUs=8

 

Steps to Reproduce:-

1. Launch ADS

2. Connect SQL Server 2012

3. Expand Database tree node.

4. Right click on table node and Select Query Analyzer.

5. In Query Analyzer Execute below Scripts.

 

CREATE TABLE [dbo].[Employees]  ( 
        [Id]            int NOT NULL,
        [Name]          varchar(25) NOT NULL,
        [Phone_no.]     int NOT NULL,
        [Location]      varchar(25) NOT NULL 
        )


INSERT INTO [dbo].[Employees]([Id], [Name], [Phone_no.], [Location]) 
   VALUES(1, 'Naresh', 97901, 'PUNE')
GO
INSERT INTO [dbo].[Employees]([Id], [Name], [Phone_no.], [Location]) 
   VALUES(3, 'Vaibhav', 23901, 'PUNE')
GO
INSERT INTO [dbo].[Employees]([Id], [Name], [Phone_no.], [Location]) 
   VALUES(5, 'Aditi', 297901, 'MUMBAI')
GO
INSERT INTO [dbo].[Employees]([Id], [Name], [Phone_no.], [Location]) 
   VALUES(4, 'Abhishek', 97141, 'BANGLORE')
GO
INSERT INTO [dbo].[Employees]([Id], [Name], [Phone_no.], [Location]) 
   VALUES(2, 'Pranita', 57901, 'CHENNAI')
GO
Select * from dbo.Employees
GO

 

6. Go to Pivot Grid tab.

7. From Field List,

- Drag id and Location to Drag Row field here section.

- Drag Name to Drag Data Field here section.

 

Result:- You will observe that Grand Total(Count) is getting displayed in Pivot Grid.

 

8. Right click anywhere on Pivot Grid -> Select Copy -> Copy Pivot Grid.

9. Paste it on Query Analyzer.

 

Result:- You will observe that Grand Total (Max) is getting displayed instead of Grand Total (Count).

 

Observations:-

 

 

Behaviour in different ADS builds.	Behaviour of Copy ->Pivot Grid
	WINDOWS	UBUNTU	MAC
ADS 19 dev-5	Y	Y	Y
ADS v18	Y	Y	Y
ADS v17	Y	Y	Y
Y - Issue is Reproducible.
N - Issue is not reproducible.