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!

question on redirecting report connection during run time

Status
Not open for further replies.
paulanwarbat

paulanwarbat

Programmer
Sep 27, 2005
1
PH
Hi! i have a question. My reports are integrated in visualbasic. and Im using the OLEDB SQL connection. How can I redirect my report to .UDL during runtime? please help me with this problem. Im trying to use this code but im getting an error that the "database has not yet been open"

crPincodeDtl.Database.Tables(1).Location = "d:\MyProjects\LCS_Report(kaye)\LCSSQL.udl"
crPincodeDtl.Database.Tables(2).Location = "d:\MyProjects\LCS_Report(kaye)\LCSSQL.udl"
crPincodeDtl.Database.Tables(1).SetLogOnInfo "d:\MyProjects\LCS_Report(kaye)\LCSSQL.udl"
crPincodeDtl.Database.Tables(2).SetLogOnInfo "d:\MyProjects\LCS_Report(kaye)\LCSSQL.udl
 
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top