Can the Visual Studio 2008 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.
    • Moved by Young Gah Kim - MSFT Wednesday, March 25, 2009 6:15 PM Move it to the appropriate forum so that it can be addressed better. (Moved from ADO.NET Data Providers to Visual Studio Team System - Microsoft Solutions Framework (MSF))
    • Moved by Clementino de Mendonça Thursday, May 14, 2009 7:09 PM It was moved to MSF Forum by mistake. (From:Visual Studio Team System - Microsoft Solutions Framework (MSF))
    • Moved by Gert Drapers (MSFT) Friday, May 15, 2009 1:10 AM This is a DataSet related question (From:Visual Studio Team System - Database Edition)
    Tuesday, March 24, 2009 10:36 PM