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

    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.
    Wednesday, March 18, 2009 4:26 PM

Answers