how to avoid: fields inserted in "where clause" are inserted automatically in "select"

[Former Member]

Hi,

I don't want that fields inserted in "where clause" are inserted automatically in "select" because when I'm grouping some fields can't be in select clause.

How do I exclude these "where fields" from select?

Thanks,

Iasmini

[abhilash_kumar]

Hi Iasmini,

Create the report against the SQL Query via the 'Add Command' option. This way you can get rid of the field from the Select clause.

-Abhilash

[Former Member]

Hi,

Thank you for a quick answer. Where can I find this 'Add Command' button?

My Crystal Reports' version is 11.5.12.1838 (XI R2)

Iasmini

[abhilash_kumar]

Go to the Database Expert > Expand the database connection > Double-click Add Command > Paste the SQL Query.

-Abhilash