cherokee10
IS-IT--Management
I have this query (below here) in Crystal Query, that runs fine.
What tables should I put in my crystal report into the Visual Link to see this in a Crystal Report. This is because I want to call a subreport with some fields from this query.
Thanks
Carlos
SELECT
sum(TTDPUR041101."T$AMTA") ,
TTDPUR041101."T$SUNO",
TTCCOM020101."T$NAMA"
FROM
"BAAN"."TTDPUR041101" TTDPUR041101,
"BAAN"."TTCCOM020101" TTCCOM020101,
"QA"."AM_RECORD" AM_RECORD
WHERE
TTDPUR041101."T$ODAT" > sysdate - 730 and
TTDPUR041101."T$SUNO" = TTCCOM020101."T$SUNO" and
AM_RECORD."SUPPLIER" = trim(TTDPUR041101."T$SUNO") and
AM_RECORD."AUDIT_STATUS" = 'W' and
exists (SELECT DISTINCT VENDOR_RATE_OVERALL."VENDOR" FROM "QA"."VENDOR_RATE_OVERALL" VENDOR_RATE_OVERALL WHERE VENDOR_RATE_OVERALL."VENDOR" = AM_RECORD."SUPPLIER")
GROUP BY
TTDPUR041101."T$SUNO",
TTCCOM020101."T$NAMA"
What tables should I put in my crystal report into the Visual Link to see this in a Crystal Report. This is because I want to call a subreport with some fields from this query.
Thanks
Carlos
SELECT
sum(TTDPUR041101."T$AMTA") ,
TTDPUR041101."T$SUNO",
TTCCOM020101."T$NAMA"
FROM
"BAAN"."TTDPUR041101" TTDPUR041101,
"BAAN"."TTCCOM020101" TTCCOM020101,
"QA"."AM_RECORD" AM_RECORD
WHERE
TTDPUR041101."T$ODAT" > sysdate - 730 and
TTDPUR041101."T$SUNO" = TTCCOM020101."T$SUNO" and
AM_RECORD."SUPPLIER" = trim(TTDPUR041101."T$SUNO") and
AM_RECORD."AUDIT_STATUS" = 'W' and
exists (SELECT DISTINCT VENDOR_RATE_OVERALL."VENDOR" FROM "QA"."VENDOR_RATE_OVERALL" VENDOR_RATE_OVERALL WHERE VENDOR_RATE_OVERALL."VENDOR" = AM_RECORD."SUPPLIER")
GROUP BY
TTDPUR041101."T$SUNO",
TTCCOM020101."T$NAMA"