CODEWITHSUNDEEP
delphidelphi-7quickreports
Christopher Chase
Christopher Chase

Reputation: 2890

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

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

Upvotes: 1

Views: 912

Answers (2)

AIBreveleri
AIBreveleri

Reputation:

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

Upvotes: 4

Kipow
Kipow

Reputation: 51

Maybe you can create a memtable (for example with memoryData of JVCL suite (free)) then print a normal report.

Upvotes: 0

Related Questions