Question Re: Missing SQL Expression Fields Folder in Technology Q&A

Missing SQL Expression Fields Folder

Former Member — Tue, 11 Jun 2013 17:33:08 GMT

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

Re: Missing SQL Expression Fields Folder

abhilash_kumar — Tue, 11 Jun 2013 18:01:57 GMT

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

Re: Missing SQL Expression Fields Folder

Former Member — Tue, 11 Jun 2013 18:07:54 GMT

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.

Re: Missing SQL Expression Fields Folder

DellSC — Tue, 11 Jun 2013 19:14:08 GMT

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