Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports / How to Modify an Existing SQL Query

Status
Not open for further replies.
PCSAARON

PCSAARON

Programmer
Jul 9, 2002
131
US
We created an Active Data connection with ADO and wrote an SQL statement for the report. How do you edit the SQL statement after the report is saved (or at least view it?)

Crystal Reports v8.5


Aaron
 
Sort by date Sort by votes
Hi there

Database -> Verify Database to view/change your sql string

Transcend
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
864
Kennymc
Kennymc
Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
597
dgillz
dgillz
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
570
Ivan Kok
Ivan Kok
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
683
hilfy
hilfy
Gary Hnat
  • Locked
  • Question
Crystal SQL Code linking to partial database field entries
Replies
2
Views
580
Gary Hnat
Gary Hnat

Part and Inventory Search

Sponsor

Back
Top