Skip to Content
avatar image
Former Member

Unknown database connector Crystal Report 13

I have a problem in server computer when I click button to show report(crystal).

The Report is created in Crystal report 9 and i have converted into Crystal Report 13.

And I'm not sure why this issue is happening. While checking the connection it is not connected (TestConnectivity() is always false).

You can see my source code below,

private void ViewCystalReport()
        {
            OracleConnectionStringBuilder builder = new OracleConnectionStringBuilder(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);            
            Tables CrTables;
            string dbDataSource = builder.DataSource;
            string userId = builder.UserID;
            string pass = builder.Password;
            ReportDocument cryRptdocUMENT = new ReportDocument();
            string sRptFolder = Server.MapPath("S36.rpt");
            string path = sRptFolder;
            cryRptdocUMENT.Load(path);


            ConnectionInfo crConnectionInfo = new ConnectionInfo();
            crConnectionInfo.ServerName = builder.DataSource;
            crConnectionInfo.DatabaseName = "Vision";
            crConnectionInfo.UserID = builder.UserID;
            crConnectionInfo.Password = builder.Password;
            CrTables = cryRptdocUMENT.Database.Tables;
            TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
            crtableLogoninfo.ConnectionInfo = crConnectionInfo;
            int y = 0;
            foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
            {
                crtableLogoninfo = CrTable.LogOnInfo;
                crtableLogoninfo.ConnectionInfo = crConnectionInfo;
                CrTable.TestConnectivity();                
                CrTable.ApplyLogOnInfo(crtableLogoninfo);
                CrTable.LogOnInfo.ConnectionInfo.ServerName = crConnectionInfo.ServerName;
                CrTable.LogOnInfo.ConnectionInfo.DatabaseName = crConnectionInfo.DatabaseName;
                CrTable.LogOnInfo.ConnectionInfo.UserID = crConnectionInfo.UserID;
                CrTable.LogOnInfo.ConnectionInfo.Password = crConnectionInfo.Password;
                CrTable.Location = "dbo." + CrTable.Location;
                y++;
            }
            cryRptdocUMENT.SetDataSource(Ds);
            cryRptdocUMENT.SetDatabaseLogon(builder.UserID, builder.Password, builder.DataSource, "Vision");
            SetDBLogonForReport(connectionInfo);


            if (ParameterArrayList.Count != 0)
            {
                //Getting Value From the Report (Parameter and Formula Feild)
                int ParameterFieldCount = cryRptdocUMENT.DataDefinition.ParameterFields.Count;
                for (int i = 0; i < ParameterFieldCount; i++)
                {
                    string paramname = cryRptdocUMENT.DataDefinition.ParameterFields[i].Name;
                    var myValue = ParameterArrayList.FirstOrDefault(x => x.Key.ToUpper() == paramname.ToUpper());                   
                    cryRptdocUMENT.SetParameterValue(paramname, myValue.Value);
                }
            }
            CrystalReportViewer1.ReportSource = cryRptdocUMENT;
            CrystalReportViewer1.DataBind();
            //Set generated report document as Crystal Report viewer report source            
            cryRptdocUMENT.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, @"D:\\Crystal\\s36.pdf");
        }

Kindly verify the code and update me the information asap.

I'm looking for a work around for 2 day still there is no resolution.

If i'm filling the Dataset it is woking fine but while exporting the Report it is always blank.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 11, 2016 at 07:19 PM

    Incorrect SCN Space. Please post to here:

    http://scn.sap.com/community/crystal-reports-for-visual-studio

    - Ludek

    Senior Support Engineer Product Support, Global Support Center Canada

    Follow me on Twitter

    Got Enhancement ideas? Use the SAP Idea Place

    Add comment
    10|10000 characters needed characters exceeded