Cross Tab Query in Interbase 6

How do i wriite cross tab query in interbase6.
princemaheshAsked:
Who is Participating?
 
ITugayConnect With a Mentor Commented:

"Decision Cube CrossTab for multidimensional analysis of data" components pack available only in enterprise edition.

btw, it located in dcldss50.bpl (~83kb size). Not sure about licensing agreement, but you can try to download this file somewhere.

-----
Igor.
0
 
kretzschmarCommented:
?
select afield, sum(afield2), max(afield3) from tablelist where condition group by afield


alternate
use the decissioncube-components
0
 
ITugayCommented:
Hi princemahesh,
meikl :)

I saw crosstab query in MS Access. It's different from SQL statements usually we use :-) There is no analog for Interbase.

Try to use decissioncube as meikl told you, or prepare result in memory and then put it into grid.

-----
Igor.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
kretzschmarCommented:
hi igor ;-)
0
 
princemaheshAuthor Commented:
Where can i find decissioncube-components.
0
 
ITugayCommented:
It should be in "Decision Cube" component palette.
0
 
princemaheshAuthor Commented:
I have installed delphi5 Professional but it is not showing me the decisioncube components.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.