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

[Former Member]

Hi Kevin,

The SQl Expressions fields is only enable if the report was created based on Tables or Views.

if any report created on ADD Command  then SQL Expression fields are not displayed in field explorer. This is by design of the crystal reports...

Thanks & regards,

Naga.