Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Query to Crystal Reports

Status
Not open for further replies.

cherokee10

IS-IT--Management
Oct 26, 2004
8
CA
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"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top