I am creating crystal report from 2 tables in desktop application in vs 2010.i tried following code
on form load
DataSet ds = new DataSet();
string strSQL = "SELECT Department.Department, Employees.Name, Employees.State FROM Department INNER JOIN Employees ON Department.DepartmentID = 1";
SqlConnection con=new SqlConnection("Data Source");
SqlDataAdapter da = new SqlDataAdapter(strSQL,con);
da.Fill(ds, "DataTable1");
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(@"path\CrystalReport1.rpt");
cryRpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
I am getting following error
"Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified."
any help will be appreciable
regards