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.