Skip to Content
author's profile photo
Former Member

Database - Show SQL Query question..

Greetings:

I am helping a co-worker with Crystal. I don't use crystal but I am able to explain the problem. My co worker is currently using crystal reports 8.5. If he pulls a query and the report is generated he can then click on Database menu then click on Show SQL Query. From there he is able to edit, add, remove fields. Now we want to place him on Crystal V10. When he does the same task, instead of being able to edit the Show SQL query he can only view it. Is there a way around this so that he can Edit the sql query in version 10 or did that feature go away in versions 9 and above. Also we are going to Purchase Crystal 2008, is this feature available in 08? Any help would be appreicated..

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Sep 04, 2008 at 05:38 AM

    Keith,

    I never used 8.5, so I never knew that you could ever do that. In what version it went away, I don't know... It's just gone... sort of.

    It just got replaced with SQL Commands.

    Copy the SQL code

    Go back to the Database Expert and expand your current connection

    Select "Add Command"

    Paste your edited SQL code into the Command window.

    Hint: don't SQL Commands with tables or other SQL Commands.

    Hope this helps,

    Jason

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks, Jason! That is just what I did. I still find it interesting that they don't allow you to simply modify the SQL to match exactly what you are trying to query. I guess I'm just not accustomed to tools like these. I'm accustomed to working with databases more directly. 😊