on 09-15-2008 7:53 AM
hi kings
when i using this query in crystal report sql command and excute its through the error --- multi part identifier "oitm"."ItemCode" could not be bound.
SELECT '61', '', GetDate(), 'TOTAL', "wor1"."ItemCode", Sum("wor1"."IssuedQty"),Sum( Convert(numeric(20,3),("wor1"."BaseQty""owor"."CmpltQty"))) 'Consumed Qty', Sum(Convert(numeric(20,3),("wor1"."IssuedQty" - ("wor1"."BaseQty""owor"."CmpltQty")))) 'Pending Qty', Sum("wor1"."U_UBundletoKg"), "oitm"."invntryuom", "ocrd"."cardname", "T0.Warehouse" FROM "OWOR" INNER JOIN "WOR1" ON "owor".DocEntry = "wor1"."DocEntry" INNER JOIN "OITM" T2 ON "wor1"."ItemCode" = "oitm"."ItemCode" inner join "ocrd" on "owor"."U_subcontractor" = "ocrd"."cardcode" ...
Thanks & best regards
B.Narain
Hi
-When we made any changes in database structure and then old report points to the old structure,at this time you may get this error.
-Other possibility is the specified field doesn't get the matching criteria(oitm).
-Check with the data type of Item Code and oitm.
Answers to these question will help us to move ahead.
Regards
Asha.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.