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

how to pass query to crystal report using visual basic

Status
Not open for further replies.
arunrote

arunrote

Programmer
Oct 10, 2001
6
IN
how to pass query to crystal report using visual basic.I have written below code,i am getting error saying subscript out of range.What may be the reason,how to over come with this problem.Pls some help me in this.

SQLStr = "select ROAD,YEAR from PUPIL"
Set pAdors = New ADODB.Recordset
pAdors.Open SQLStr, pAdoCon,adOpenKeyset,adLockOptimistic
pReport.Database.SetDataSource pAdors
 
Status
Not open for further replies.

Similar threads

XrayboX
  • Question
Dynamically pass Crystal Reports formula to a Stored procedure Parameter
Replies
1
Views
178
PeterDimitrov
PeterDimitrov
hg05
  • Locked
  • Question
Crystal Reports Left outer join and link type
Replies
1
Views
597
PeterDimitrov
PeterDimitrov
MH6
  • Locked
  • Question
Example to Run a Crystal Report from an Oracle Stored Procedure?
Replies
3
Views
700
tomcat24
tomcat24
SAINI2020
  • Locked
  • Question
Crystal Reports 2008 and SharePoint
Replies
1
Views
467
hilfy
hilfy
DSenger
  • Locked
  • Question
Developing a Crystal Report in text format
Replies
8
Views
631
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top