Now you can easily (without a single line of code) add a footer to your grid and display: Sum, Average, Minimum, Maximum, Count, or Custom Text under any field in the grid.

Easy to use design-time field editor will help you create the footer with colors, fonts and bevels the way you want them.
 
With Nag-Screen
Source: On purchase/registration
Price: $74.50

The rather distinguished features are:

• Multiple cell lines per record and multiple text lines per cell. DbAltGrid allows the user to customize the grid layout freely. The user can adjust the height of each line in rows separately.
• Hierarchial columns. Now you can sort your columns into logical categories, consolidate them and assign to shared parent columns. Parent columns are expandable and collapsible, so this way you can imitate a tree-like column structure. You can merge several columns and display them in a RTF summary column.
• Two-way data transfer through the Clipboard and drag-and-drop using most popular formats, including ones native to MS Office.
• Inplace editing of MEMO fields, including RTF fields.
• Hyperlinks in cells.
• Graphics of any kind.
• Short learning curve. DbAltGrid is fully compatible with common DBGrid that comes with the VCL. The TDbAltGrid class is a TCustomDBGrid descendant, as TDBGrid is. By migration to DbAltGrid, you will not get any code conflict. There is a component that helps with TDBGrid to TDbAltGrid migration.

DotNet4Delphi extensions delivers two components:

• TVirtualDataset - Hook up your memory stored data to data aware controls by simply implementing a few events.
• TListDataset - Hook up any collection (List, Array, Dictionary) to data aware controls. All published properties of the items contained in the list will be available as fields in the dataset. Furthermore, items can be editied, added and/or removed without further actions from the programmer.

• Gradient background according to cell type
• Integrated search capabilities for string fields
• Sorting columns
• Hot tracking
• Automatically adjust the width of columns
• Row and column resizing
• Supporting mouse wheel
• Word wrapping cells
• Sound effects
• Integrated and configurable popup menu for applying commands on individual records
• Supporting bidirectional mode
• Loading and saving configurations.

It has the following new Public Properties and Procedures: Canvas, Col, Row, FixedCols, FixedRows, TopRow, SelectedRows, DataLink, ColCount, RowCount, ColWidths, GridLineWidth, InplaceEdit, TitleOffset, OnColumnResize, OptWidth (making the 'Grid' automatically size itself so that no white space is left at the right), VisibleRowCount, VisibleColCount, GridHeight, GridWidth, LeftCol, ExportGrid, ExportToFile, GridPreview, DataSetPreview, SaveToRegistry, LoadFromRegistry, CopyToClipboard, CutToClipboard, PasteFromClipboard, ShowCustomizeDialog, ShowQueryByForm and ShowSortByForm.

It has the following new Published Properties: ScrollBars, EditColor, DefaultRowHeight, RowSizingAllowed, DisplayImages, DisplayMemo, DisplayBoolean, GridAutoSize (making the columns automatically resize so that they are as wide as the row with the widest entry), GridAutoWidth (making the columns automatically resize so that no white space is left at the right), FullSizeMemo, Cells3D (when False, the Grid has a Flat look and feel - also the 3D Cells can be any color), CellHints (when True and Columns are not wide enough for the DisplayText, moving the mouse over a cell shows the text in a hint window), RowColor1, RowColor2, UseRowColors (using the properties RowColor1 and RowColor2), MultiLineTitles, TitleCheck (which places a marker in the top left of the grid and enables the grid popup menu when clicked), BackgroundPicture, UseBackgroundPicture, ExportDelimiter, AllowAutoAppend, DrawFocusRect, EnterAsTab, HighlightColor, ImageHighlightColor, HighlightFontColor, ReportCaption, HotTrack, HotTrackColor, LockedCols, LockedFont, LockedColor, FlatCheckBox, FlatCheckBoxType, MemoViewType, RegistrySaveName, ShowTextEllipsis, ShowTitleEllipsis, MultiLineRows, LinesPerRow, DisplayDateTime, SearchMode (when True, clicking on the column titles will display a search box for the column - Case Sensitive), ExMenuOptions, ScrollHints, UseBitmapDrawing (if active, a temporary bitmap is used to draw cells within the grid - it decreases flickers but draws a cell a bit slowly), MemoInplaceEditor and DisplayPopupEditors (when false, memos can be edited inplace by single clicking the cell), GridAutoWidthDisplay, MaskedColumnDrag, ShowTitlesWhenInactive, BoldTitlesWhenCells3D and BoldIndicatorsWhenCells3D.

It has the following new Methods: MoveToRow and CellRect (which is extremely useful if you want to drop other controls on the grid i.e. pop a dropdown list over a cell when the user enters it).

In addition, it also has the following Features: Design Time and Run Time viewing of images, including JPEG support, Flat look and feel, Grid Printing, Grid Exporting, Enhanced Scrollbar Tracking, Selecting and UnSelecting all records, Column Customizing, Drag and Drop implementation and Automatic Column Sorting (Fields that have indexes will be sortable by clicking the Column Titles), QueryByForm and SortByForm implementation (For Paradox and dBASE any column names specified in the SortByForm procedure must already be indexed. For SQL-based tables, the specified columns need not be indexed.) It also has support for English, Italian and Portuguese Languages, as well as support for BDE Datasets, ADO Datasets, Advantage Datasets and DAO Datasets.

It also has popup viewers and Inplace Editors for Graphic/Memo and Date/Time Fields. To use these and the Checkbox, simply click on the Fields or use the Spacebar, F2 or Enter Keys.

To use TExRxDBGrid you must have RXLib 2.60 or higher installed.
 
Fully functional
Source: Included

The ExpressPivotGrid Suite was engineered from the ground-up to blow away the limitations posed not just by these out-of-process solutions, but to radically improve the way in which data-centric applications deliver information to end-users. With its powerful data architecture, the ExpressPivotGrid is able to slice and dice information efficiently and provide customers with an extremely intuitive end-user experience. It delivers numerous layout customization options with total end-user control over each individual on-screen report. Regardless of the perspective, data can be rendered to answer business questions - and best of all - it allows you to focus on business rules rather than creating dozens and dozens of reports.
 
Demo only
Source: On purchase/registration
Price: $249.99
Source Price: $329.99
Exe-Demo Included

Added Selection Color, Font Selection Color, Active Color, Font Active Color and fixed problem with multiselect.
 
Fully functional
Source: Included

• fix use of scroll whell;
• fix use of drag and drop;
• WheelLinesMode (automatic / manual mode for scoll lines);
• WheelLinesMany (how many lines to scroll with mouse whell).

• Flat interface
• Footers
• Multiple line titles
• Memo and Graphic cell drawing ability
• Row sizing
• Extended user drawing event
• Auto column fit
• Cell-as-checkbox drawing.

Component PDJDBGridEx is based on TDBGrid, have all features from regular TDBGrid with next additional features:

• full XP themes support
• flat look of cells
• gradient titles of columns
• display memo fields
• display Blob Graphic directly in cell. Image will keep original constraint ratio
• display sort arrow on a columns titles
• display rows in different colors, user can change index of colored rows
• dropdown calendar for date-time fields
• check box for boolean fields
• display gradient or solid progress bar with percent value for a numeric fields
• display value of numeric field like images
• display images on titles of columns
• draw ellipsis when text doesn’t fit width of column
• set color of grid lines
• set color of cell selections
• different height of grid rows and titles row
• set char case of text of title and grid rows
• save grid values in to files (*.html, *.csv, *.txt)
• supports mouse wheel events
• save or load user resized grid column’s widths and positions to .INI file
• word wrap text in cells.

• Sizeable Row Height;
• Sizeable Title Height;
• Able to draw Memo and Graphic fields;
• It is fast and flicker free;
• Free for all purpose in use.

TAdvDBColumn:

• multiline columns headers
• bands for group of columns
• footers with various kind of counting (sum, min, max, avg); scope can be set for entire dataset or only for visible rows
• property ColumnKind let You customize visualization of data
• for all numeric and datetime fields appropriate (extreme lightweight) Popup window is available (if property ExtendedEditor is set to True - default)

• AutoSort; if underlaying Dataset has properties IndexDefs and IndexName, or IndexFieldNames then clicking on title automatically sorts underlaying dataset (holding Ctrl or Alt You can click multiple columns for sorting on multiple fields)
• blobs editors (images can be shown in hint windows)
• variable colouring of rows (in both state: on focus in and focus out)
• columns are scrolled horizontally directly on thumb move; vertically, You can decide by including or not oeThumbTracking into OptionsEx
• fields can be edited even if the selected Row is highlighted (dgRowSelect is included into Options)
• rows can be selected by checking checkboxes in indicator column
• support for multifield KeyField of LookupDataList
• for more features see DEMO application

Free for non-commercial use.

• Adds a Datasource & Columns property to TAdvStringGrid to load or edit any datasource into the grid
• Allows DB-aware mini HTML formatting to combine multiple formatted datafields per cell

 
Fully functional
Source: On purchase/registration
Exe-Demo Included

• Allow to create title on several columns (multititle mode) or on the whole grid
• Allow to show a fotter row(s). Opportune to use in combination with TDBSumList
• Allow automatically fit columns width to set grid width equal client width
• Allow change row height and title height
• Allow automatically broken a long lines between words in title and data rows
• Title can act as buttons and show sort marker
• Allow truncate long text by ellipsis.

TDBGridSearch supports Ctrl+Enter, Left/Right and Back Space keys for navigating between grid colums and make powerfull record search (Locate method).

There is simple way to use search in DBGrid: In focused Grid just type first letters what You want to find (search string will be visible in column title).

You can switch between columns for search in any column.

Just put component on the form and select grid to attach in GridEH property in the Object Inspector.
 
Fully functional
Source: Included
Exe-Demo Included

Now you can display and edit memo fields and multiline text fields of different length. The height of strings depend on length of the text.

You have possibility to limit string height and use the scrollbar in inplace editor, to use multiline column headers, to select multiple strings with Shift, Ctrl and mouse keys combination, to realize an enhanced control on colors.
 
Fully functional
Source: Included

There is few ways to make lookup for a field:

• imediate pickup list of values
• pickup list builded by SQL statement
• imediate list of values and it's captions. (it shows caption instead of field value)
• ist of values and it's caption builded by SQL statements (one to show caption for value, another to build picup list)
• datetime picker.

• to set columns of a grid as fixed
• to keep adjustment Grid of the user in INI - file
• to set height of title
• to set height of data rows
• to show multilower case cells of grid ( as data cell to title cells)
• to create two rows of title and to group columns of bottom row.

Features:

• It is flat like 1C:Enterprise 8.0 grid
• It is self-expansible
• It have the color settings for row, column, title e.t.c.
• It have the indicator settings (through resource file)
• All that you can do with standard DBGrid, you can do with this DBGrid.

TXDBGrid component looks beautiful and implements many additional features like: fixed columns, fixed styles (flat and 3D), Windows XP themes, many variants of gradient drawing style, enhanced flat and 3D scrollbars, proportional scrolling for any DataSet even filtered, expandable columns and title headers, checkboxes, hot buttons, title and indicator images, many variants of pictures drawing into cells, title markers and multicolumns sorting, enhanced lookup lists, pick lists and drop-down lists, calculator, calendar, storing and loading columns layout (to ini file, registry, stream, string), enhanced support for bdRightToLeft BiDiMode, extended rows selection and notification, multiline rows and auto-numbering, hints, tooltips, column stretching and many many more ...

TXDBGrid component is fully compatible with standard TDBGrid and can be used as a replacement without losing existing settings. It's also compatible with Windows XP and can take advantage of Windows XP styles. TXDBGrid has its own ColumnEditor, which can fully support all new column's properties.

TXDBNavigator represents a gradient database navigator. TXDBNavigator is a functional extension of standard TDBNavigator. TXDBNavigator introduces several new properties to control border of buttons, gradient drawing style and parent's background.
 
Trial (work while IDE is running)
Source: On purchase/registration
Price: $84
Source Price: $167

TXDBGrid component is the functional extension of Borland's TDBGrid. TXDBGrid implements all standard TDBGrid's functions and the many additional, which are launched including new Options or by setting values for new properties. TXDBGrid is fully compatible with TDBGrid component on properties level and can be used as a replacement without losing existing values. TXDBGrid has its own ColumnEditor, which can fully support all new column's properties. TXDBGrid component is compatible with Windows XP platform and fully supports Windows XP Styles.

TXQRGrid is a complementary component for TXDBGrid designed for dynamic report creation on the basis of TXDBGrid current settings. TXQRGrid component can print and preview the content of TXDBGrid component. TXQRGrid creates in run-time complete report in QuickReport format. The report can be automatically stretched or created as few parts (vertical bands) depend on selected paper size settings.

TXDBColumnsDialog is a complementary component for TXDBGrid designed for grid columns management in run-time. User can show/hide selected columns in the grid by using convenient dialog which presents columns list with checkboxes.

TXDBPrintColumnsDialog is a complementary component for TXDBGrid & TXQRGrid designed for selection printed columns in run-time. User can select columns that are printed by using convenient dialog which presents columns list with checkboxes.

TXBlobField & TXGraphicField classes extend functionality of TBlobField & TGraphicField to achieve assignment compatibility between graphic BLOB field and TPicture class for another graphic formats. It allows directly using TImage, TDBImage, TQRImage, TQRDBImage with any graphic format stored in graphic BLOB fields (*.bmp, *.ico, *.wmf, *.emf, *.jpg and others supported by FieldGraphicClass).
 
Trial (work while IDE is running)
Source: On purchase/registration
Price: $139
Source Price: $278

• provide gradient background for fixed cells
• introduce drag and drop support
• new record indicator different for editable and readonly grids, new indicator for Cell(0,0)
• shows check boxes for boolean fields (in font color)
• shows glyphs for memo fields and graphics fields (in font color)
• provides DatePicker for DateTime fields
• provides build-in editor for memo fields and long string fields
• provides build-in browser for graphics fields with BMP and JPG format
• can show text in some columns as URL link and can handle it (http, mailto or userdefined links)
• can show any field as boolean checkbox with definable TRUE FALSE values
• can show any field as graphic symbols according field value
• shows complete text as hint for truncated text in cell and for memo field
• shows sort markers in title row (including multi column sorting)
• provides multiple line captions in title row with automatic word wrapping
• shows graphics in title row
• provides text line with selectable font and color in title row
• introduces events for change sorting and click on title cells or fixed column cell
• provides context menu for title row with calculation of SUM, MIN, MAX, AVG, COUNT values for selected column
• can show odd rows by different color
• can show focus rectangle on whole active row
• provides automatic changing of columns width after resizing of grid
• provides enhanced functionality for choosing value in lookup fields and in columns with picklist
• provides functionallity for automatic filling of picklist according existing values in the field
• provides automatic lookup functionality for non editing grid
• provides functionallity for linking to another grid to provide footer summary rows
• provides mouse wheel functionality
• introduces events for getting cell properties (font, background) and for drawing on active row
• introduces event for custom hint on any cell
• provides design time editor for quick setting of all new properties