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

[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.

[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