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) ?