rajniyadav
asked on
CrossTab query
I am using Sql server 7 as backend and connection to the databse through ADO.
i have a table like this
Class Language text
========================== ========== =========
Universe German """AAAA"""
Universe English """BBBB"""
Universe French """VVVV"""
Universe Italian """DDDD"""
DB English """XXXX"""
i want to generate the cross tab query
and the output in the grid
my grid should look like this
Class German English French Italian
Universe """AAAA""" """BBBB""" """VVVV""" """DDD"""
DB """XXX"""
Is there any way to get this output in the grid?
I don't watn to generate a table at runtime.
Is it possible to do it through Descision query?
Please help asap :-)
Rajni
i have a table like this
Class Language text
==========================
Universe German """AAAA"""
Universe English """BBBB"""
Universe French """VVVV"""
Universe Italian """DDDD"""
DB English """XXXX"""
i want to generate the cross tab query
and the output in the grid
my grid should look like this
Class German English French Italian
Universe """AAAA""" """BBBB""" """VVVV""" """DDD"""
DB """XXX"""
Is there any way to get this output in the grid?
I don't watn to generate a table at runtime.
Is it possible to do it through Descision query?
Please help asap :-)
Rajni
ASKER
kretzschmar
ok i have no problem in using decision gid
can u tell how to make the query.
Rajni
ok i have no problem in using decision gid
can u tell how to make the query.
Rajni
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
kretzschmar
Can you tell how to user ADO connection component (Database compoenent) in the Descision query.
Rajni
Can you tell how to user ADO connection component (Database compoenent) in the Descision query.
Rajni
hmm,
a new aspect,
will take a look this evening
(no delphi on hand yet),
could be, that the decission-query
did not support ado.
meikl ;-)
a new aspect,
will take a look this evening
(no delphi on hand yet),
could be, that the decission-query
did not support ado.
meikl ;-)
use the tdecissioncube with a tadoquery,
tdecissionquery is not needed in this case
meikl ;-)
tdecissionquery is not needed in this case
meikl ;-)
ASKER
i am not able to create the decisioncube dimensions properly. and not able to get the right output in the grid.
can u plz tell me waht is base field & what to set in this field.
can u plz tell me waht is base field & what to set in this field.
rajniyadav:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
>Post your closing recommendations! No comment means you don't care.
i am definitivly not able to post recommendations for 200+ cleanup-posts per day.
that means not, that i didn't care of it, if i post no recommendation there!!
even so on this q, i post this unseen of the q
i am definitivly not able to post recommendations for 200+ cleanup-posts per day.
that means not, that i didn't care of it, if i post no recommendation there!!
even so on this q, i post this unseen of the q
Wow, Its been a long time since this comment have been visited!
rajniyadav,
No comment has been added lately (19 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
RECOMMENDATION: Award points to kretzschmar http:#6887926
-- Please DO NOT accept this comment as an answer ! --
Thanks,
knightmad
EE Cleanup Volunteer
Remember you (all) can object this recommendation if you disagree, just leave a post here explaining why are you objecting and what should be done instead.
Within 7 days probably this thread will be closed, so, hurry up! : )
rajniyadav,
No comment has been added lately (19 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
RECOMMENDATION: Award points to kretzschmar http:#6887926
-- Please DO NOT accept this comment as an answer ! --
Thanks,
knightmad
EE Cleanup Volunteer
Remember you (all) can object this recommendation if you disagree, just leave a post here explaining why are you objecting and what should be done instead.
Within 7 days probably this thread will be closed, so, hurry up! : )
yes, but the result must be displayed in the decission-grid