Sur62
Posts: 22
|
Posted: 03/16/2008, 11:42 PM |
|
I have created a crosstab query in Access. Now how to bring it in CCS? When i click Build Query button it shows only the simple query but not the crosstab query. Can somebody help on this problem please.
|
|
|
DonB
|
Posted: 03/21/2008, 12:57 PM |
|
The Access query depends on functionality within the Jet engine to construct
the output.as a 'cross tab'. The ODBC interface does not provide access to
that because you aren't invoking access.exe, only the data interface.
Having said that, there are numerous ways to construct cross tabs, albeit in
a less flexible manner than what Jet does. Pick up a copy of Joe Celko's
"SQL for Smarties" book. He's one of the top SQL gurus out there and his
book covers the topic in detail and very clearly.
--
DonB
"Sur62" <Sur62@forum.codecharge> wrote in message
news:647de12e91d4f2@news.codecharge.com...
>I have created a crosstab query in Access. Now how to bring it in CCS? When
>i
> click Build Query button it shows only the simple query but not the
> crosstab
> query. Can somebody help on this problem please.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
asoares
Posts: 8
|
Posted: 03/22/2008, 5:18 AM |
|
I faced with this problem in a project, that started with MS ACCESS database.
To make a long history short, I migrated to SQLEXPRESS 2005 database, since it supports CROSS TABLE QUERIES now using PIVOT clause as well (not available in SQL 2000).
You can write your transformation inside a PROCEDURE and just get the resultant table. Works fine with CCS.
You can read something at http://msdn2.microsoft.com/en-us/library/ms140308.aspx (Microsoft Library) or
Dynamic Crosstab Queries: http://www.sqlmag.com/Articles/ArticleID/15608/15608.html?Ad=1 (some code is avalilable for downloading).
_________________
Alcides Soares Filho
Clicks to Bricks
c2b@clickstobricks.info
Brasil |
|
|
Sur62
Posts: 22
|
Posted: 03/23/2008, 10:12 PM |
|
Thanks a lot for your replies. Will go through what you have said and come back if i have any doubts.Thanks again.
|
|
|
AQUANANU
Posts: 107
|
Posted: 04/01/2008, 12:08 PM |
|
mine ccs shows the crosstab query in the builder, but the page when executed gives following error
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/popup/Classes.asp, line 3361
_________________
Navneet Kakkar
CEO
Positive Thinker's Inc. |
|
|
|