none
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..

    TRANSFORM Sum(ALCFIL_PPFMTRC.PFAHRS) AS ActualHr<BR>SELECT ALCFIL_PPFMTRC.PFWKC1   
    AS Machine, ALCFIL_PPFMTRC.PFCREW AS Crew, Sum(ALCFIL_PPFMTRC.PFQYGD) AS   
    Quanity, Sum(ALCFIL_PPFMTRC.PFEHRS) AS EarnedHr, Sum(ALCFIL_PPFMTRC.PFARRT) AS   
    ActualRunRT, Sum(ALCFIL_PPFMTRC.PFDRRT) AS DefaultRunRt,   
    Sum(ALCFIL_PPFMTRC.PFALLB) AS AluminumWeight, Sum(ALCFIL_PPFMTRC.PFCMLB) AS   
    CompositeLBS<BR>FROM ALCFIL_PPFMTRC<BR>GROUP BY ALCFIL_PPFMTRC.PFWKC1,   
    ALCFIL_PPFMTRC.PFCREW<BR>PIVOT ALCFIL_PPFMTRC.PFDWND 

    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