Hi All,
I am trying to open a crystal report which is using OLEDB (ADO) connection and stored procedures to retrieve data.
I am trying to change the database connection information dynamically from the vb.net code. The method I have used is:
1. create a new crystal report(crystalreport1.rpt) in vb.net project and load the crystal report which is already developed.
2. place a crystal viewer in form1 and choose the rystalreport1.rpt as the source
3. Now if from anywhere I try to change the cnnection info using setconnection as below
the report whilerunning does not ask for parameter and throws error
Me.DataSourceConnections.Item(0).SetConnection("aceR", "SAP_SP_DB", False)
If I am trying to pass the parameter through the code , the report does not take the parameter value. The code which I use for passing parameter is correct since when this code is executed without the connection info code( commenting that part of code) is working fine.
I have also tried he belowcode but no success.
Me.CrystalReport11.DataSourceConnections.Item(0).IntegratedSecurity = False
Me.CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.IntegratedSecurity = False
Me.CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.AllowCustomConnection = True
Me.CrystalReport11.DataSourceConnections.Item(0).ServerName.Replace("192.168.10.157","Acer")
Any Idea why this happens. I just need to give the databse server connection information dynamically.
Regards,
Priya