Missing SQL Expression Fields Folder

[Former Member]

I am working on a report that was converted to use an SQL Command.  i.e. it does not use the distinct tables, it uses one SQL query as the datasource.  But somehow during the conversion process the SQL Expressions in Crystal got deleted (including the "SQL Expressions" folder in the "Field Explorer").

Does anyone know how to get the "SQL Expression Fields" folder back so I can add a new SQL Expression to the report?  I have included a screenshot so you can see what exactly is missing.

Without the "SQL Expression Fields" folder I cannot add a new "SQL Expression".

Any assistance is appreciated.

Kevin

[DellSC · Accepted solution]

That explains why the option is not there, but what do you do instead?  That's actually fairly easy - Since you're writing SQL anyways, add the SQL expression to the query in the command. 

-Dell