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

[abhilash_kumar]

Hi Kevin,

SQL Expression Fields are not available when reporting against a Command Object.

Connect to a Table/View and use an ODBC or OLEDB connection with the driver from the Vendor.

-Abhilash