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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Active Data Driver/SQL query retrieval

Status
Not open for further replies.
BillX

BillX

Programmer
Nov 16, 2001
2
US

I have several reports that I want to make available from web (ASP) pages and a VB application. The reports are designed using the Active Data driver and CR version 8.0.

During report creation, I specified an ADO ODBC data source and a SQL query string. I was unaware that this SQL query is not the SQLQueryString used by the RDC (for the Active Data driver anyway.)

Is there any way to programmatically access that SQL string in the report so that I can open my own ADO recordset using a modified version string?

Bill
 
Status
Not open for further replies.

Similar threads

Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
553
Ivan Kok
Ivan Kok
dgillz
  • Locked
  • Question
Outlook as a Datasource?
Replies
0
Views
534
dgillz
dgillz
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
919
LyleU
LyleU
Gary Hnat
  • Locked
  • Question
Crystal SQL Code linking to partial database field entries
Replies
2
Views
564
Gary Hnat
Gary Hnat
BTPJayW
  • Locked
  • Question
Verify Database Not Working Against Stored Procedure
Replies
1
Views
619
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top