• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 443
  • Last Modified:

Manually edit the SQL

hi all,

I wonder if it is possible to edit the SQL generated by crystal report 9, I could view the SQL by clicking Database | Show SQL Query, but I cannot edit it. What I want is to edit the whole SQL,
Not just the formula in Record. Is there a way to do it.. ?

Much much thanks
ME
0
john_wsm
Asked:
john_wsm
  • 4
  • 2
1 Solution
 
frodomanCommented:
No, it is not possible.  Although it was in some previous versions, CR9 removed that possibility completely.

When you use Show SQL Query, you're seeing the SQL created by using the "select records" and other options.  To make a change here, just change the appropriate option.

frodoman
0
 
john_wsmAuthor Commented:
Hi frodoman,

thanks for your help and my problem have been solved partly.

actually my problem is that i have a rpt file (which i have no idea about which version the file is created), and whenever i opened the file and selected Show SQL Query, a reset button is enabled and i have to reset the sql before any change is being made to the file to take effect. so i suspected the rpt file is being made with an older version of CR and my CR 9 forced me to reset the SQL as a result. Do u think so?

So, could u kindly let me know which versions allow the direct editing of SQL and how to edit in that version of CR??

much much thanks

ME
0
 
frodomanCommented:
>>> So, could u kindly let me know which versions allow the direct editing of SQL and how to edit in that version of CR??

I believe in version 8.0 you could edit it with the "Show SQL" menu option.  In version 9 (and I believe 8.5 also) this is now a read-only field.

0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
bdreed35Commented:
ME:

It sounds like might have edited the SQL in a past version, and verison 9 doesn't know how to utilize it.

My suggestion to you would be to copy the SQL from the "Show SQL" window, and then create a SQL Command and paste the SQL there.  The report would then use the SQL Command as the datasource and you won't need to bother with the reset anymore.
0
 
frodomanCommented:
It's only 20 points, but bdreed simply restated what I'd already written...

frodoman
0
 
bdreed35Commented:
frodoman:

You stated it wasn't possible.  My first sentence may have been a recap of what you said, but you never mentioned anything about using a SQL Command as a possible solution to the problem, so I think overall, my post was not a paraphrase of yours.

0
 
frodomanCommented:
bdreed,

That's a fair observation - points are yours.

Cheers,

frodoman
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now