Edit "Show SQL Query"

[Former Member]

I upgraded a Crystal Reports from version 8.5 to Crystal Report 2008. I need to add one more field to the report. How can I change the query in "Show SQL Query" using Crystal Reports 2008? I read there is option to use "Add Command" option but that would mean I have to rebuild many other things in the report. All I need is to add a new field in the query.

[Former Member · Accepted solution]

You can not edit the SQL since about CR 9. YOu have to use a command if you want bespoke SQL

If you want to add another field/table to existing report go to Database-> database expert and add it there.

You can also replace a table and point to a view instead, this is done is Set data source, highlight current table and the update to use a view.

Ian

[Former Member · Accepted solution]

Just to go a small bit further than Ian.

if this is a field on an existing table you should be able to just click it in feild explorer.

if the database is already a query then you can edit it directly

if this is a new field then do a refresh (verify database)

all of these will not mean you need to change any of your existing report, and if you do another "Show SQL Query" you will see the new field.