DBgrid add a summary row

I have a dbgrid in which I insert records, the records have fields with integer values, I want to create a new row every time a record is inserted which will give me the sum of the 5 columns which columns have integer values.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Geert GOracle dbaCommented:
you could recreate your query to do this...
otherwise you will need to go for a other option like a second grid below the first with the summarized values or a commercial grid like:
quantumgrid: http://devexpress.com/Products/VCL/ExQuantumGrid/
or tms grid: http://www.tmssoftware.com/site/gridpack.asp

recreate query:
you will have to write your own insert query with catching the beforeinsert event.
select * from (
select a, b, c, d, e, f, g, 0 as data from table
select null, sum(b), sum(c), sum(d), sum(e), sum(f), null, 1 from table) as X
order by data, a

Open in new window

your values are usually displayed in so called 'footers'.
so either you use a dbgrid component that has footers incorporated or you will have to do it yourself in code.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Geert GOracle dbaCommented:
both solutions are possible
agree with geeert - it should not be refunded just like that....
Geert GOracle dbaCommented:
@ aikimark
how do you populate a dbgrid programmatically ?

i'm very interested to see your solution ... :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.