Crystal Report log into two databases

[mknoll217]

Hello. I have been trying to log onto two databases at run time for a crystal report. I have tried both the crystal report viewer and the report document object viewer. I have no figured out a way to make it possible.

The code for the report document object viewer is below (with the server, password and user not included for both databases). It gives me an error saying that it cannot find the employee table (which is in the EmployeeTrack database).

protected void Page_Init(object sender, EventArgs e)
    {
        ConfigureCrystalReports();
    }
    private void ConfigureCrystalReports()
    {
        //string fieldUniqueID = Request.QueryString["UniqueID"];
        //string fieldParID= Request.QueryString["ParID"];
 
       string fieldUniqueID = "100252";
       string fieldParID = "1";
 
        ConnectionInfo connectionEmployee = new ConnectionInfo();
        connectionEmployee.ServerName = "***************";
        connectionEmployee.DatabaseName = "EmployeeTrack";
        connectionEmployee.UserID = "***";
        connectionEmployee.Password = "******";
 
        ConnectionInfo connectionPAR = new ConnectionInfo();
        connectionPAR.ServerName = "********";
        connectionPAR.DatabaseName = "PAR";
        connectionPAR.UserID = "****";
        connectionPAR.Password = "*****";
 
        reportSeparation = new ReportDocument();
        string reportPath = Server.MapPath("Separation_Report_Local.rpt");
        reportSeparation.Load(reportPath);
 
       SetDBLogonForReport(connectionEmployee, reportSeparation);
       SetDBLogonForReport(connectionPAR, reportSeparation);
 
        SetCurrentValuesForParameterFieldUniqueID(reportSeparation, fieldUniqueID);
        SetCurrentValuesForParameterFieldParID(reportSeparation, fieldParID);
 
        crystalReportViewer.ReportSource = reportSeparation;
    }
    private void SetCurrentValuesForParameterFieldUniqueID(ReportDocument reportDocument, String field)
    {
        ParameterValues currentParameterValues = new ParameterValues();
        ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();
        parameterDiscreteValue.Value = field;
        currentParameterValues.Add(parameterDiscreteValue);
 
        ParameterFieldDefinitions parameterFieldDefinitions = reportDocument.DataDefinition.ParameterFields;
        ParameterFieldDefinition parameterFieldDefinition = parameterFieldDefinitions[PARAMETER_FIELD_UNIQUE];
        parameterFieldDefinition.ApplyCurrentValues(currentParameterValues);
    }
    private void SetCurrentValuesForParameterFieldParID(ReportDocument reportDocument, String field)
    {
        ParameterValues currentParameterValues = new ParameterValues();
        ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();
        parameterDiscreteValue.Value = field;
        currentParameterValues.Add(parameterDiscreteValue);
 
        ParameterFieldDefinitions parameterFieldDefinitions = reportDocument.DataDefinition.ParameterFields;
        ParameterFieldDefinition parameterFieldDefinition = parameterFieldDefinitions[PARAMETER_FIELD_PAR];
        parameterFieldDefinition.ApplyCurrentValues(currentParameterValues);
    }
    private void SetDBLogonForReport(ConnectionInfo connectionInfo, ReportDocument reportDocument)
    {
        Tables tables = reportDocument.Database.Tables;
        foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
        {
            TableLogOnInfo tableLogonInfo = table.LogOnInfo;
            tableLogonInfo.ConnectionInfo = connectionInfo;
            table.ApplyLogOnInfo(tableLogonInfo);
        }
    }
}
 
 

My code for crystal report viewer is below. I just have to fill in the password for one of the databases with the code below. The log in window for only one of the databases shows up.

 
private const string PARAMETER_FIELD_UNIQUE = "UniqueID";
    private const string PARAMETER_FIELD_PAR = "ParID";
 
 
    protected void Page_Init(object sender, EventArgs e)
    {
        ConfigureCrystalReports();
    }
 
    private void ConfigureCrystalReports()
    {
       string fieldUniqueID = Request.QueryString["UniqueID"];
      string fieldParID = Request.QueryString["ParID"];
 
      //string fieldUniqueID = "100028";
      // string fieldParID = "14";
 
        ConnectionInfo connectionEmployee = new ConnectionInfo();
        connectionEmployee.ServerName = "********";
        connectionEmployee.DatabaseName = "EmployeeTrack";
        connectionEmployee.UserID = "****";
        connectionEmployee.Password = "********";
 
        ConnectionInfo connectionPAR = new ConnectionInfo();
        connectionPAR.ServerName = "***********";
        connectionPAR.DatabaseName = "PAR";
        connectionPAR.UserID = "*******";
        connectionPAR.Password = "*********";
 
        string reportPath = Server.MapPath("PAR_Report_Local.rpt");
        crystalReportViewer.ReportSource = reportPath;
 
        SetDBLogonForReport(connectionEmployee);
        SetDBLogonForReport(connectionPAR);
 
 
        SetCurrentValuesForParameterFieldUnique(parameterFields, fieldUniqueID);
        SetCurrentValuesForParameterFieldPAR(parameterFields, fieldParID);
 
    }
    private void SetCurrentValuesForParameterFieldUnique(ParameterFields parameterFields, String field)
    {
        ParameterValues currentParameterValues = new ParameterValues();
 
        ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();
        parameterDiscreteValue.Value = field;
        currentParameterValues.Add(parameterDiscreteValue);
 
 
        ParameterField parameterField = parameterFields[PARAMETER_FIELD_UNIQUE];
        parameterField.CurrentValues = currentParameterValues;
 
    }
    private void SetCurrentValuesForParameterFieldPAR(ParameterFields parameterFields, String field)
    {
        ParameterValues currentParameterValues = new ParameterValues();
 
        ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();
        parameterDiscreteValue.Value = field;
        currentParameterValues.Add(parameterDiscreteValue);
 
 
        ParameterField parameterField = parameterFields[PARAMETER_FIELD_PAR];
        parameterField.CurrentValues = currentParameterValues;
 
    }
 
    private void SetDBLogonForReport(ConnectionInfo connectionInfo)
    {
        TableLogOnInfos tableLogOnInfos = crystalReportViewer.LogOnInfo;
        foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos)
        {
            tableLogOnInfo.ConnectionInfo = connectionInfo;
        }
    }
}
 
 

Any help would be greatly appreciated. Thanks.

-Michelle