Crystal Reports Error
Posted on 2014-10-02
Main report with Sub Reports; Sub reports use SQL Expressions to pull 'counts' from tables. 1st Subreport 'fine'; succeeding reports which use different tables; are not working.
WHERE purchase_order.order_id = "client_"."ord_id"
GROUP BY purchase_order.order_id )
Gives me an error of:
Error in Compiling SQL Expression:
Database Connector Error: '42000: MS SQL Server Native Client 10.0
The Multi-part identifier "client_"."ord_id" Could not be bound (Db vendor code 4104
The 'only' difference between this sql expression and the first sub report's sql expression is: "client_"."ord_id"
the reports are 'all' alike in framework, tables are only difference.