Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Question: Would you like to see support for the compute command?
*** This poll has now closed ***

  1 (100%)
  0 (0%)

Total votes: 1
« Created by: Gerrit-Jan Linker on: 20.03.06 at 09:51:50 »

Pages: 1
using BREAK and COMPUTE stmt (Read 6505 times)
satish asnani(Guest)

using BREAK and COMPUTE stmt
20.03.06 at 09:37:07
I want to use following code
BREAK ON dep_no
COMPUTE SUM OF amt ON dep_no
select dep_no,amt from table;
But compute is not supported. How else the same effect be acheived
Back to top
Email   IP Logged
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Re: using BREAK and COMPUTE stmt
Reply #1 - 20.03.06 at 09:50:37
You are correct. Compute is not yet a supported command. The only thing you can do is to use Excel's function to add subtotals. See the Excel data menu.
If there is more demand for this feature I will build it in.  
Please reply to this message to let me know that you also want to have this feature added to SQL*XL.
Back to top

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1