|
DBGrid Footer
Professional looking footers for your applications.
Click on the image above to download.
About
TSDBGridFooter component is a powerful tool that will give
your application professional look. It provides automatic calculations
for your DBGrid and displays that information in a customizable footer
under the grid. The component is designed to work with TSDBGrid that is also
included in this product. The TSDBGrid component inherits from TDBGrid and it
doesn't introduce any new properties.
What's so great about this approach? Well, you've probably
seen many DBGrids that have footer display capabilities, but if
you use one, you're limited to whatever it offers. I have tried using
many different DBGrids, but one of them had footers, the other had checkboxes
and bitmaps, but none of them had all the features that I needed. In
the end, I have settled for one of them that had the most to offer. But,
it had no footers. So I decided to develop a footer component that fits any
DBGrid.
Of course, with all the custom made 3rd party DBGrids, this task
is practically impossible. Since most of these 3rd party DBGrids inherit from
TCustomDBGrid, the optimal solution is to have a footer component that can be
attached to any TCustomDBGrid descendant. That's how TSDBGridFooter was
born.
That's great, but is the TSDBGrid necessary? Yes. The TSDBGrid
component inherits from TCustomDBGrid and adds some methods to allow the footer
component to access data from dataset and to paint itself properly, under the
appropriate DBGrid columns.
How can you use this solution with your favorite DBGrid? It's very
simple, actually. Once you register, you will receive full source code
to both TSDBGrid and TSDBGridFooter. All you need to do is change two lines
of code inside the SGrid.pas file and you will have the DBGrid of your choice
working with TSDBGridFooter.
Is it complicated to implement this footer component into
an application? Not at all. Simply put TSDBGrid on a form and connect
it to a data source as you would have normally, put a TSDBGridFooter under it
and set Grid property to the DBGrid's name. Use design-time editors to set all
the columns that you need in the footer and you're done! Best of all,
it doesn't matter what field types you use, the component is smart enough
to calculate sums, averages, minimum and maximum values automatically. For example,
if you want to display the sum for a TTimeField column, the component will show
you correct number of hours, minutes and seconds without any intervention on
your part.
New in version 2.0 - you can let the user choose the type
of calculation for each cell in the footer. Delphi versions 3, 4, 5 and 6 and
C++ Builder versions 3, 4 and 5 are now supported. Help file is included and
demo project that uses DBDEMOS (from your Delphi installation) and BCDEMOS (from
your BCB installation) database to show how simple it is to have footers
on both the master and the detail grid (it takes only one line
of code!).
Download
Trial version (with demo
project source)
Demo EXE (for Delphi's DBDEMOS database)
Demo EXE (for C++ Builder's BCDEMOS
database)
Key Features
|
•
|
Available for Delphi versions 3,
4, 5, 6 and C++ Builder versions 3, 4
and 5 |
|
•
|
Every cell of the footer can contain
text. It can be one of the following:
|
•
|
opSum - automatic field
total without a single line of code |
|
•
|
opCount - number of records
in grid |
|
•
|
opAverage - field's average
value |
|
•
|
opMin - field's lowest value |
|
•
|
opMax - field's highest
value |
|
•
|
opText - custom text
in footer cell |
|
•
|
opNone - no text in cell |
|
|
•
|
Design-time property editor provides you with
ability to change each cell's color or font |
|
•
|
Use any descendant of TCustomDBGrid with
it (just change the class declaration - one line in source code).
Check readme.htm inside the archive on how to do this. Please
note that this option is not applicable if you do not buy a license with
source code |
| • |
One year of free upgrades for registered
users, regardless of price change |
| • |
Free email and phone customer support |
| • |
Help and demo included |
|
•
|
Royalty free licenses for use in any
number of your applications |
|
•
|
Easy to use |
Pricing
You can register online by clicking on the button below
and download full source code within minutes.
We accept AMEX, Diners, Master Card, VISA, Solo, Switch, JCB, Connect,
Eurocard, Delta, UK and US checks, Purchase Orders and PayPal. Click the button
below to order this component online from SWREG in England,
the oldest online software store in the world, or ShareIt!, one of the
biggest online software stores.
| Description |
Option |
Price
|
Register secure online
|
| Single Developer License |
with source |
$49.50 |
|
| 5 Developers License |
with source |
$148.50 |
| Site License |
with source |
$495.00 |
Don't want to pass your credit card details over
the Internet or have no credit card? Contact
us.
|
| FREE Newsletter |
We will never give, lease or sell your personal
information. Period! If you have any questions at all about our privacy
policy, please email us
|
|
