john_wsm
asked on
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
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
ASKER
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
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
>>> 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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It's only 20 points, but bdreed simply restated what I'd already written...
frodoman
frodoman
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.
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.
bdreed,
That's a fair observation - points are yours.
Cheers,
frodoman
That's a fair observation - points are yours.
Cheers,
frodoman
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