SQL Expressions can not be used in this report

[regulatre]

I've created a Crystal report to chart sales totals by date and by store from a large Progress database. In Crystal the data looks great, I'm using SQL expressions to parse out discrete values from extented fields using pro_element() ...

However in my application, when I run the report I receive the following error:

"SQL Expressions can not be used in this report".

The report does not show up in my application due to the above error. If I remove references to the SQL expression fields then the report displays (but without the sales figures!).

Am I going about this the wrong way? How should I be accessing the extented data from my application?

 

[regulatre]

I averted the problem by using a Crystal/VB formula instead of an expression. I then used the split() function to parse out the desired field. At that point it was a trivial task to get to the subfield (extent) that I wanted.