Search code examples
delphidelphi-7quickreports

Create a 2 dimension Quickreport

I think im asking for the right type of report from Quickreport.

What we have is a simple table, 

gauge,site,value

Gauge and site are the keyfields, (there could be anynumber of Gauge-Site Pairs) normally there is only at most, about 10 sites.

and we are looking to get a reports that looks like this

       site1   site2   site3
gauge1   34      4      45
gauge2   45      6       5
gauge4   34      4      45

Dose anyone know

  • What type this type of report is normally called, (so google can be more help)
  • Is is possible to created this type of report using QuickReport
    if so, any ideas how?
    if not, any ideas on what could be used insted?

Delphi7
QuickReports 3.5
NexusDB (dont think that matters too much)

Solution

  • It's called a cross tabulation. Google for "crosstab", "crosstab report", "crosstab object".