Can the Dataset Designer support a crosstab query? RRS feed

  • Question

  • Hello,

    I create most of my queries in MS Access and then copy and paste them into Visual Studio's Dataset Designer, most do NOT work without first massaging them.

    I wanted to know if a Crosstab query that runs in MS Access can also run or be duplicated in VS's Dataset designer?

    I'm pulling data via an ODBC connection from an AS/400 and creating reports with reportviewer, I can spend hours creating a routine to convert the data manually, but the crosstab query really would be a timesaver.

    Any help or work-arounds would be appreciated!

    Thanks, and have a great day!

    Bill Lock

    Even though this might not help... here is my query from MS Access I want to use in VS 2008's Dataset Designer..

    ActualRunRT, Sum(ALCFIL_PPFMTRC.PFDRRT) AS DefaultRunRt,   

    The error I am getting seems to involve my ODBC driver - Token TRANSFORM was not valid, but using the same ODBC driver/connection, this query works flawlessly in MS Access.
    Wednesday, March 18, 2009 4:26 PM