Crystal report Command edit option not visible

[former_member230931]

Hi All,

I need to edit an existing crystal report "command", however when I right click the option is not available in database expert

Thanks

[former_member230931]

Problem is I need to edit the report so I can add two new fields , without editing the so called command there is no way to add the new fields. Basically what i'm asking is how to modify a report if the query behind is not exposed irrespective of the nature of the command

[julie_jamieson2]

Can you show a shot of the other side of the database expert?

[former_member227598]

Hi DIck,

You cannot modify the SQL behind a Table or View that is added from the Database Expert and moreover what you're called a Command Object is NOT really what you think it is!

To be able to 'modify', you first need to add a Command Object via the "Add Command" option. This option should be available under the Database Connection name in the Database Expert.

Using this option you can add a SQL Query and report against it. The option to "Edit" the command in the Database Expert is available for such objects only.

Rgds,

Kamlesh Naware