Skip to Content
author's profile photo Former Member
Former Member

Edit "Show SQL Query"

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2011 at 07:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.