469,579 Members | 1,056 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

How can you show SUBTOTALS?

How can you show SUBTOTALS in the same column as the data, NOT in a
separate column?

I need to SUBTOTAL in the same column as one of the the data columns,
like the subtotals 700 and 800 under Field 3 below (I really have 21
columns). Also I must show one blank row after each resulting group:

Field1 Field2 Field3 Field4
entry1 data2.1 100 data4.1
entry2 data2.2 400 data4.2
entry3 data2.3 200 data4.3
700
[B L A N K R O W H E R E]
entry4 data2.4 500 data4.4
entry5 data2.5 300 data4.5
800
[B L A N K R O W H E R E]

How can you do this?
Jul 20 '05 #1
2 9233
Scott wrote:
How can you show SUBTOTALS in the same column as the data, NOT in a
separate column?


The closest thing I can find is the GROUP BY ... WITH ROLLUP feature,
implemented in MySQL 4.1.1.

http://dev.mysql.com/doc/mysql/en/GR...Modifiers.html

Bill K.
Jul 20 '05 #2
BILL,
Thank you VERY MUCH!!!
Your help is MOST appreciated.
Scott
Bill Karwin <bi**@karwin.com> wrote in message news:<ce********@enews1.newsguy.com>...
Scott wrote:
How can you show SUBTOTALS in the same column as the data, NOT in a
separate column?


The closest thing I can find is the GROUP BY ... WITH ROLLUP feature,
implemented in MySQL 4.1.1.

http://dev.mysql.com/doc/mysql/en/GR...Modifiers.html

Bill K.

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by dp | last post: by
2 posts views Thread by Scott | last post: by
reply views Thread by Mark | last post: by
2 posts views Thread by Richard Grene | last post: by
4 posts views Thread by Jerry LeVan | last post: by
3 posts views Thread by Greg | last post: by
reply views Thread by Paul Ilacqua | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.