SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Suggestion: Excel like SUM on status bar
Goto page 1, 2  Next
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Suggestion: Excel like SUM on status bar
Author Message
hitesh



Joined: 15 Oct 2007
Posts: 104

Post Suggestion: Excel like SUM on status bar Reply with quote
May I suggest SoftTree to add MS Excel like aggregates (SUM/AVG) on sql server status bar when more then one row/col(of type numeric) is selected on query result pane . As a developer i find it difficult to sum few rows on sql server result pane, every time i need to copy those data on excel to get sum at a glance. Hope u understood what i mean.

Hitesh
Fri Feb 24, 2012 5:49 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2100

Post Reply with quote
+1
Fri Feb 24, 2012 8:04 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Version 6.2 will allow direct data export/import to Excel. Hope that will make our life easier.

Anyone interested in testing the current preview version?
Sat Feb 25, 2012 12:27 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2100

Post Reply with quote
SysOp wrote:
Version 6.2 will allow direct data export/import to Excel.

I'm not quite sure that's what Hitesh was thinking about. As for me, I use a couple of hotkey enhancements that make copy-paste and task switching a whole lot easier but it's still much slower than to select the cells and check the value. Losing the line of sight to the source code/result set makes me anxious :)

SysOp wrote:

Anyone interested in testing the current preview version?

Well, I always am.
Sat Feb 25, 2012 4:26 am View user's profile Send private message
hitesh



Joined: 15 Oct 2007
Posts: 104

Post Reply with quote
SysOp wrote:
Version 6.2 will allow direct data export/import to Excel. Hope that will make our life easier.

Anyone interested in testing the current preview version?


Sorry I think u have not got my point stright, I did not mean Imp/Exp of data to/from excel.
What i mean is excel like feature to see SUM at a glance on status bar of qurey result pane.

To make u understand my point, just open ms excel and
- type in value 10 (in A1), 20 (in B1), 30 (in A2), 40 (in B2)
- now select A1,A2 and see their SUM in excel status bar, likewise
- select all 4 cols (a1,a2,b1,2) see their SUM in excel status bar.

This will be a real handy feature for developers if provided in SQL Assitance.

Hope I made my point clear now!
Sat Feb 25, 2012 8:12 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
I'm pretty sure i know what you described, it s called "auto SUM" Excel feature for selected cells. What I tried to say, is while there is no exact match in SQL Assistant, version 6.2 will provide one-click data export to Excel, directly from the data grid, so that if you need to analyze the data, you can use full power of Excel and it will be just 1 click away. Yes, it requires 1 extra step, but then you can slice and dice that data anyway you want. In the end, may be it's not that bad after all :)
Sat Feb 25, 2012 9:06 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2100

Post Reply with quote
Certainly :) Every new feature is welcome. With two screen setup it could be extremely useful. I'll definitely try it.
Sun Feb 26, 2012 6:00 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Thank you. We will send you a private invite as soon as the new build is ready for trial.
Sun Feb 26, 2012 11:06 am View user's profile Send private message
hitesh



Joined: 15 Oct 2007
Posts: 104

Post Reply with quote
I got your point and it will be usefull indeed.
BUT, Think about Adding a status bar to sql assistant query result pane that would be helpfull in displaying auto SUM/COUNT etc.
Mon Feb 27, 2012 7:51 am View user's profile Send private message
hitesh



Joined: 15 Oct 2007
Posts: 104

Post Reply with quote
hitesh wrote:
I got your point and it will be usefull indeed.
BUT, Think about Adding a status bar to sql assistant query result pane that would be helpfull in displaying auto SUM/COUNT etc.


SoftTree guys any update on "display of auto SUM/Count of selected cells or rows or cols" feature request?
Fri Aug 26, 2016 3:22 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
As far as I know this new feature was planned tentatively for the upcoming release of the new major version. I'm not sure about the status of the implementation, I will check and get back to you by Monday.
Sat Aug 27, 2016 9:14 am View user's profile Send private message
hitesh



Joined: 15 Oct 2007
Posts: 104

Post Reply with quote
SysOp wrote:
As far as I know this new feature was planned tentatively for the upcoming release of the new major version. I'm not sure about the status of the implementation, I will check and get back to you by Monday.


If this is done as requested, it will save lot of time indeed. I can get rid off using manual calculator and also i can see SUM using any combination of cells (by rows or cols). Can't wait to see this working on my SQL editor
Mon Aug 29, 2016 2:49 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Here is the response I got, It's planned for release, but not yet completed, we're still working on that and it should be complete before the beta version is out.
Mon Aug 29, 2016 3:01 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2100

Post Reply with quote
Any status updates on this one?
Thu Oct 06, 2016 5:16 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 804
Country: United States

Post Reply with quote
I like this one too +1.
Thu Oct 06, 2016 5:17 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.