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

Edit data definition sql query


I develop a report using odbc ado as

start crystal report and open new file

on data tab select ODBC/SQL
select Active Data (Ado) server type
select relative ado and next and finish
select sql and write query in text area
and design report.

Now i want to change the query on this design report how can i edit this query.

1 Solution
I believe you can go to edit or view (not at my crystal pc right now) and select "show sql query" there you can manually edit it.
Hi pak_slm,

In addition to what AConover said above, in any versions of crystal reports, you can only edit the FROM, WHERE and ORDER BY parts of the query if required and not the SELECT part.


why pak_slm is posting the same question times again.
already "Change sql query in data definition of report" the question with the above heading I have given some directions how to do that.
I think he forgot to open that thread.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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