on 09-25-2015 3:04 PM
This the the SQL Query for which I keep receive the error qty completed is ambigious. I only want the report to pull the information from jobs that are still not completed.
SELECT "job_hdr"."order-no", "job_hdr"."name", "job_routing"."oper-no", "job_routing"."work-ctr", "job_routing"."start-date", "job_routing"."end-date", "job_routing"."QtyToMfg", "job_routing"."QtyCompleted", "job_hdr"."req-date"
FROM "E100LIVE"."PUB"."job-routing" "job_routing" INNER JOIN "E100LIVE"."PUB"."job-hdr" "job_hdr" ON ("job_routing"."company"="job_hdr"."company") AND ("job_routing"."order-no"="job_hdr"."order-no")
WHERE "qtycompleted"= "0.00"
ORDER BY "job_hdr"."name"
Not sure if you followed up in the Crystal Reports space.
The issue is that the column qtycompleted exists in both job_routing and job_hdr tables so you will need to qualify which table you want in the WHERE condition.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
http://scn.sap.com/community/crystal-reports
Hello,
You have posted your question to SAP SQL Anywhere space.
Is Crystal Reports connecting to SAP SQL Anywhere?
Otherwise, above the link to SAP Crystal Reports space is.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
http://scn.sap.com/community/crystal-reports
Please post your question to Crystal Reports space (link above)
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.