Skip to Content
0
May 25, 2009 at 02:44 PM

Logon info for Oracle from .NET application

17 Views

Hello,

I am new to Crystal Reports. Crystal Reports XI and Oracle 10g Client are installed on my PC and allow me to display my test report with one parameter.

1) I am trying to show my c:\temp\Test.rpt in CR Viewer in C# application by means of the following lines:

ReportDocument crReport = new ReportDocument();

crReport.Load("c:\temp\Test.rpt");

crReport.SetDatabaseLogon("myuser", "mypassword");

crystalReportViewer1.ReportSource = crReport;

However, I cannot figure out how to pass Oracle SID.

What is the proper way of passing logon information (Oracle SID, user id, password ) at runtime?

2) Also, how can I pass one parameter to my report at runtime?

Thank you.