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!

 

[OrionStar]

Sounds like your tables are not linked properly, please check your Database table expert and check the linking. Let us know what you find there.

M

"A man is only as happy,... as he makes up his mind to be...

 

[Bobbber]

Thanks for the reply. The links are correct.

Although I've shown these as tables in the SQL Expressions, they are actually SQL Server Views...

I'm still not sure why this will cause the error though. Even if the table links were incorrect, should not cause this problem though? Surely would only cause extra data?