Hi everyone, I created a crystal report viewer and I have it to load some report with subreports and a dataset filled with all the data the report needs.

My thing is everytime I try to display the report it prompts a dialog box asking for database authentication, which I don't need cause i'm passing an already filled Dataset.

My code is this:

            TableLogOnInfo logOnInfo = new TableLogOnInfo();
            int i = 0;
            ReportDocument rpt = new ReportDocument();
            String SQL1 = "";
            SQL1 = mvarRutaReporte;

            try
            {
                logOnInfo.ConnectionInfo.ServerName = mvarNombreServidor;
                logOnInfo.ConnectionInfo.DatabaseName = mvarNombreBD;
                logOnInfo.ConnectionInfo.UserID = mvarUsuarioBD;
                logOnInfo.ConnectionInfo.Password = mvarClave;
                rpt.Load(SQL1);
                rpt.SetDataSource(clsReportes.dsReporte);

                foreach (Table tabla in rpt.Database.Tables)
                {
                    tabla.ApplyLogOnInfo(logOnInfo);
                    if (tabla.TestConnectivity())
                    {
                        MessageBox.Show("Error en la Coneccion de las tablas del reporte!!!", "S.I.M.M.");
                    }
                }
                #endregion
                #region autenticando los subreportes
                foreach (ReportDocument Subreporte in rpt.Subreports)
                {
                    Subreporte.Database.Tables[0].ApplyLogOnInfo(logOnInfo);
                    if (Subreporte.Database.Tables[0].TestConnectivity())
                    {
                        MessageBox.Show("Error en la Coneccion de las tablas del SubReporte!!!", "S.I.M.M.");
                    }
                }
            
                this.crtReportes.ReportSource = rpt;
            
            }
            catch (Exception a)
            {
                MessageBox.Show(a.ToString());
            }

I even tried to handle the authentication with this routine:

            Sections crSections;
            ReportDocument crReportDocument, crSubreportDocument;
            SubreportObject crSubreportObject;
            ReportObjects crReportObjects;
            ConnectionInfo crConnectionInfo;
            Database crDatabase;
            Tables crTables;
            TableLogOnInfo crTableLogOnInfo;
            crReportDocument = new ReportDocument();
            crReportDocument.Load(RutaReporte);
            crReportDocument.SetDataSource(clsReportes.dsReporte);
            crDatabase = crReportDocument.Database;
            crTables = crDatabase.Tables;
            crConnectionInfo = new ConnectionInfo();
            crConnectionInfo.ServerName = NombreServidor ;
            crConnectionInfo.DatabaseName = NombreBD;
            crConnectionInfo.UserID = UsuarioBD;
            crConnectionInfo.Password = Clave;
            foreach (CrystalDecisions.CrystalReports.Engine.Table aTable in crTables)
            {
                crTableLogOnInfo = aTable.LogOnInfo;
                crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
                aTable.ApplyLogOnInfo(crTableLogOnInfo);
            }
            // Para los reportes que poseen subreportes 
            // pongo el objeto seccion del la seccion actual del reporte 
            crSections = crReportDocument.ReportDefinition.Sections;
            // busco en todas las secciones el objeto reporte
            foreach (Section crSection in crSections)
            {
                crReportObjects = crSection.ReportObjects;
                //busco en todos los reportes por subreportes
                foreach (ReportObject crReportObject in crReportObjects)
                {
                    if (crReportObject.Kind == ReportObjectKind.SubreportObject)
                    {
                        crSubreportObject = (SubreportObject)crReportObject;
                        //abro el subreporte y me logeo con los datos del reporte general
                        crSubreportDocument = crSubreportObject.OpenSubreport(crSubreportObject.SubreportName);
                        crDatabase = crSubreportDocument.Database;
                        crTables = crDatabase.Tables;
                        foreach (CrystalDecisions.CrystalReports.Engine.Table aTable in crTables)
                        {
                            crTableLogOnInfo = aTable.LogOnInfo;
                            crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
                            aTable.ApplyLogOnInfo(crTableLogOnInfo);
                        }
                    }
                }
            }

Any help?