Crystal report is not showing any data when loaded

Question

Hi All I'm working with crystal reports and C#. In the design mode of the report when I make a preview it is working fine. But when I execute my application the report viewer is not showing any result at all. And there ain't either any error message nor warning. Can anybody help on that one.. kaiser@lorson

Crish · Answer

Hi you can refer below code for crystal report.It will help you. myClass = new Dbcon(); this.conn = new System.Data.OracleClient.OracleConnection(); this.conn.ConnectionString = user id=HRddd;data source=XE;password=cfvvv; //Database Connection ConnectionInfo ConnInfo = new ConnectionInfo(); { ConnInfo.ServerName = 127.0.0.1; ConnInfo.DatabaseName = XE; ConnInfo.UserID = HRddd; ConnInfo.Password = cfvvv; } // For Each Logon parameters foreach (TableLogOnInfo cnInfo in this.CrystalReportViewer1.LogOnInfo) { cnInfo.ConnectionInfo = ConnInfo; } //CrystalReportViewer1.ReportSource = oRpt; /////////////////////////////// conn.Open(); if (bool.Parse(myClass.table_exists(COUNTVIEWDE conn).ToString()) == true) { myClass.DbNonQuery(DROP VIEW COUNTVIEWDE conn); } sql = CREATE VIEW COUNTVIEWDE AS  + SELECT COUNTRY_IDCOUNTR If you want to get more detail about this code than just go for this below link. http://www.dotnetspark.com/links/41221-crystal-report-export-and-print-button-not.aspx