Compile error "Der mehrteilige Bezeichner konnte nicht gebunden werden"

[Former Member]

Hi,

we tried to upgrade our reports from crystal reports 8.0 to 2008. Some reports have now problems with SQL Expressions.

For example we have an article-list that prints the ordered stock for each article. Therefore we use a SQL expression like "(SELECT SUM(QuantityOrdered) FROM Orders WHERE Orders."ArticleNr" = "Article"."ArticleNr").

This runs well with CrystalReports 8.

In CrystalReports 2008 we get a SQL Server Error "Der mehrteilige Bezeichner konnte nicht gebunden werden".

Have anybody an idea to fix this problem or to optimise the report (maybe using a stored procedure) ?

Thanks Peter

[former_member11696]

SQL Expression should NOT have SELECT statements in them. Use Command Objects to get data.