Crystal Report in Visual Studio with Access 2007

First, Server Name when connecting to Access Database contains the complete path and it worked well with Access 2003
Second, Even User Id and Password werent required in Access 2003 Database
Lastly, I still followed your solution but with no results. Please Help :(

i hope this help :-

DataSet ds = new DataSet();
            
            creport_laundry crReportDocument  = new creport_laundry();
            ReportDocument rptFile = new ReportDocument();
            ds = clsHlpr.ExecuteDataset(connection_name, CommandType.Text, "select * from abc");
            if (ds.Tables[0].Rows.Count > 0)
            {
                rptform.Text = ".........";
                rptFile.Load(Application.StartupPath + "\\mainR.rpt");
                
                crReportDocument.crys.ReportSource = rptFile;
                rptFile.SetDatabaseLogon("admin", "lbbs");
                rptFile.SetDataSource(ds);
                crReportDocument.crys.RefreshReport();
                rptFile.Refresh();
                rptFile.PrintToPrinter(1, false, 0, 0);// for send repot direct to print
                      //or
                crReportDocument.crys.Show();//for show report
                crReportDocument.Show();

                            }

Whats clsHlpr and crys ?
Whats mainR.rpt --- I am using Crystal Reports embedded in Visual Studio; so not sure if that file would be found;
And doing it through connection string would be my last preference as there are 100+ reports :(


.................................................................................................................

Following the above code I got to a solution but again this will mean changing 100+ reports(Any solution where connection string is not given through code(and the one used in Crystal Report Designer) is still highly welcomed :) :

CrystalReport1 rpt1=new CrystalReport1();
OleDbCommand com=new OleDbCommand("SELECT * FROM lo_bill_det");
com.CommandType = CommandType.Text;
com.Connection = con;// '' give connection to command
OleDbDataAdapter adp= new OleDbDataAdapter();// '' declare adapter
adp.SelectCommand = com ;//'' select command for adpapter to work on

adp.Fill(ds1, "Crystal");// '' fill the dataset through adapter
try
{
rpt1.DataSourceConnections[0].SetConnection("",@GlobalClass.hostIP,false); // GlobalClass.hostIP is the //database path
rpt1.DataSourceConnections[0].SetLogon("Admin", "");

}
catch
{}

rpt1.SetDataSource(ds1.Tables["Crystal"]);// '' select the Dataset to the source of the report
rpt1.PrintToPrinter(1, false, 0, 0);


A SOLUTION BUT THE EXACT SOLUTION IS STILL BEING WAITED...

It is approved right!
I spend half day to do the research! can't find any documents on line.

Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim rpt As New ReportDocument
        Dim A As CrystalDecisions.CrystalReports.Engine.Table
        'Dim B As CrystalDecisions.Shared.TableLogOnInfo

        Dim tblLog As TableLogOnInfo
        rpt.Load("C:\report file.rpt")
        rpt.RecordSelectionFormula = "" '"({CommissionTable.SalesRep}='" & 123 & "') "
        Dim cnnInfo As New ConnectionInfo
        With cnnInfo
            .Type = ConnectionInfoType.CRQE  ' ODBC type
            .ServerName = "ERP" 'ODBC name, no need password here
        End With
        'rpt.Load("c:\database.mdb")
        For Each A In rpt.Database.Tables
            tblLog = A.LogOnInfo
            tblLog.ConnectionInfo = cnnInfo
            A.ApplyLogOnInfo(tblLog)
        Next

        CrystalReportViewer1.ReportSource = rpt

    End Sub