SQL FOR CRYSTAL REPORTS

[Former Member]

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"

[chris_keating · Accepted solution]

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.

[Former Member · Accepted solution]

Chris,

I gave up on creating an SQL and instead used the sort expert. thanks

[former_member207653]

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.

[Former Member]

Hi  Mirco,

Have question on Crystal Report. We have 4 regions , client want to create a global list of value for all the region in crystal report for enterprise. so users can select from the global lov's. Do you have any idea on how

Please help

[former_member207653]

http://scn.sap.com/community/crystal-reports

Please post your question to Crystal Reports space (link above)