DBGrid total
lazarus / 16-Databases

----------------------------------------------------------------------
xinyiman · 2016-03-21 20:44

Hello guys, who tells me how to get a line to the bottom of dbgrig I
displays the totals for a particular column?

Thank you

----------------------------------------------------------------------
rvk · 2016-03-21 21:45

You can't do this with standard DBGrid and I don't know any third
party components which can do this (other then just putting a label
below the DBGrid with the total).

But can't you change your SQL-statement to include a summary-record?
In some SQL-variants you can use ROLLUP. If your DB doesn't support
that you could use UNION ALL and do a SELECT with SUM in the second
part.

----------------------------------------------------------------------
dogriz · 2016-03-22 06:44

There is a very good DBGrid component for that and many other things:
http://www.ehlib.com/
But, sadly, it is not free

----------------------------------------------------------------------
wp · 2016-03-22 07:25

I think the rx components have one (https://sourceforge.net/p/lazarus-
ccr/svn/HEAD/tree/components/rx/)

----------------------------------------------------------------------
JZS · 2016-03-22 07:43

RX is the one you are looking for.

----------------------------------------------------------------------
dogriz · 2016-03-22 11:28

I didn't know about RX. Very nice set of components.