1. Code Samples
  2. Samples
  3. Database

SimplePivot 1

By Chris Lupton

Freeware 12 Mar 2006

In category

Code Samples > Samples > Database

Description

SimplePivot provides a method of displaying crosstab/pivot table data in 2 dimensions from a standard SQL grouping statement.

Given a statement such as...

  • SELECT field1, field2, count(*) as field3 GROUP BY field1, field2
...field2 values are converted into column names in a resultant memory dataset. A more comprehensive readme is included in the zip. It should work with all versions of Delphi although I’ve only tested it with D7 and D2005.

There is a demo included which requires the BDE and JEDI components (the function doesn’t require these however).

Informations

  • Status: Fully functional
  • Source: FW
  • Size: 509 889kB

Platforms:

  • Delphi 2005 (VCL)
  • Delphi 7

Downloads

Download