I am trying to display a count of products from a oracle database

 

select count (active) from PRODUCT_REPOSITORY where active = 1

 

I have tested this query on the SQL developer with success, and i have other similar queries that work. For some reason this one just displays 0. I know it should display 21000 ish as the result

 

The SQL statements pass in Crystal fine, no errors.

 

This has me stumped.

 

Why is it showing 0? It seems to connect to the databse as other queries that use the same connection have results come up.

 

Any help would be great

 

Using CR 11.0.0.1282 with oracle 10g