Business Views and SQL Expressions

[Bobbber]

I am designing a report in CR10, using a Business View from CE10. It has several SQL Expressions in the business view – which I created in the Foundation.

The SQL Expressions are similar, like this :

CASE WHEN "Table1"."Price">0 THEN
("Table2"."Total"/"Table1"."Price")*100
else
0
END

Other SQL Expressions used, have the same layout, but are used for Table3, Table4 etc…

When I put one of these SQL Expressions in the Report (in the Crystal Reports Designer) and it doesn’t matter which one, the report runs fine.

However, if I put more than one SQL Expression in the Report, I get the following messages :

’Failed to Open a Rowset’
‘Cannot find the QE property. Details: - -‘

What is going wrong here?!?!?! Help!

Thanks!


Stay Blue, Bob. x

 

[Bobbber]

Anyone???

 

[mdwyer]

Try forum 149. It's oriented to CR; this is a CE forum. There are good report folk here (I'm not one of 'em), but probably more in the other forum.